Search found 20 matches

by benr_mc
Fri Jun 10, 2022 9:40 am
Forum: Databases
Topic: Does anyone use LiveCode (on any platform) with Oracle?
Replies: 4
Views: 9661

Re: Does anyone use LiveCode (on any platform) with Oracle?

Hi David, Glad to know I'm not alone. Sorry to hear that you don't have the secret to give me! FWIW I'm mostly able to achieve what I need using ODBC to access Oracle: although this is not without problems, so I've been keen to see if direct Oracle access will improve things. (Although ODBC/Oracle h...
by benr_mc
Fri May 06, 2022 10:55 am
Forum: Databases
Topic: Does anyone use LiveCode (on any platform) with Oracle?
Replies: 4
Views: 9661

Does anyone use LiveCode (on any platform) with Oracle?

I have encountered a few problems with retrieving data from Oracle using LiveCode on various platforms - has anyone else worked with this combination?
by benr_mc
Mon Mar 28, 2022 11:55 am
Forum: Databases
Topic: Reading integers sometimes truncated
Replies: 7
Views: 4869

Re: Reading integers sometimes truncated

Hi Richmond, thanks for engaging, but that's not the case. It all goes through variables (see above: put revDatabaseColumnNumbered(cursorID, c) into tRawData get revDatabaseColumnNumbered(cursorID, c, "tRawData") ) (and as a matter of fact never goes into a field) - and I've inspected in the debugge...
by benr_mc
Mon Mar 28, 2022 10:04 am
Forum: Databases
Topic: Reading integers sometimes truncated
Replies: 7
Views: 4869

Re: Reading integers sometimes truncated

Hi Craig, Thanks for taking an interest. I've tried it both ways - put revDatabaseColumnNumbered(cursorID, c) into tRawData get revDatabaseColumnNumbered(cursorID, c, "tRawData") in both cases, tRawData has the truncated number. Has anyone else seen something like this? I have a faint memory of havi...
by benr_mc
Sun Mar 27, 2022 7:03 pm
Forum: Databases
Topic: Reading integers sometimes truncated
Replies: 7
Views: 4869

Re: Reading integers sometimes truncated

Hi Craig, I think it is an LC issue, precisely because changing to another app worked! I think I wasn't very clear. I didn't change the database or the ODBC connection; I downloaded a couple of apps which read from ODBC and Oracle databases, and did a basic query on the table; and in both cases got ...
by benr_mc
Sun Mar 27, 2022 8:02 am
Forum: Databases
Topic: Reading integers sometimes truncated
Replies: 7
Views: 4869

Reading integers sometimes truncated

Reading a bunch of tables from an Oracle database over ODBC, on Mac, using revOpenDatabase and revDatabaseColumnNumbered (Livecode 9.6.6). Many of the relationships as you'd expected connected by integer ids on the tables. For some tables when I read the data I consistently get these integer ids tru...
by benr_mc
Fri Mar 11, 2022 7:54 pm
Forum: Databases
Topic: Can't use ODBC on Linux - no error reported
Replies: 2
Views: 2555

Re: Can't use ODBC on Linux - no error reported

Hi stam, thanks for replying.

Good idea but the whole function is in fact running inside a try-catch block, and unfortunately it doesn't throw any error - revOpenDatabae just returns an empty string.
by benr_mc
Fri Mar 11, 2022 5:39 pm
Forum: Databases
Topic: Can't use ODBC on Linux - no error reported
Replies: 2
Views: 2555

Can't use ODBC on Linux - no error reported

I've posted this already on the Linux board, but no replies. My first question is really whether anyone has succesfully accessed a database over ODBC on Linux? Details: I'm trying create a LiveCode app (currently using LC 9.6.6) to run on Linux (currently targeting Ubuntu 18) which needs to read fro...
by benr_mc
Fri Mar 11, 2022 11:44 am
Forum: Linux
Topic: revOpenDatabase (ODBC) failing with no error on Ubuntu 18
Replies: 0
Views: 7501

revOpenDatabase (ODBC) failing with no error on Ubuntu 18

I'm a linux newbie (but don't think that's the issue here). I'm trying create a LiveCode app (currently using LC 9.6.6) to run on Linux (currently targeting Ubuntu 18) which needs to read from a database over ODBC. I have a working ODBC connection, tested with isql. When the LiveCode app executes re...
by benr_mc
Tue Mar 03, 2020 5:52 pm
Forum: Talking LiveCode
Topic: How to split a folder structure into an array with sub arrays?
Replies: 11
Views: 8290

Re: How to split a folder structure into an array with sub arrays?

If I've understood the requirement correctly - I may not have! - this should work. -- return a nested array representing the files and folders of a tree of folders -- invoke with single parameter, full path to the root folder -- function directoryTreeAsArray tRoot, tSubPath --> aTree local aTree set...
by benr_mc
Tue Feb 25, 2020 12:34 pm
Forum: Using Externals
Topic: Bluetooth promiscuity - mergBLE confusion
Replies: 0
Views: 8866

Bluetooth promiscuity - mergBLE confusion

[I posted this previously on the use- list, but without response. So I thought I'd dip my toe in the scary waters of the forum] If I execute `mergBLEScanForPeripheralsWithServices` with no parameters, I then get a shed-load of `mergBLEDidDiscoverPeripheral` messages, as expected (and as warned by th...
by benr_mc
Thu Mar 12, 2015 10:27 am
Forum: Engine Contributors
Topic: Retaining Backwards Compatibility in a Changing World
Replies: 52
Views: 44322

Re: Retaining Backwards Compatibility in a Changing World

Add me to the omelette lovers (per Monte, i.e. prepared to break some eggs for a more satisfying result). I would also note that these are not all of the same class. Some of Marks list I at least would be prepared to view as always wrong, now righted (eg arrays really should throw an error when atte...
by benr_mc
Mon Feb 17, 2014 9:31 pm
Forum: Databases
Topic: Retrieving UTF8 from Oracle with native driver
Replies: 0
Views: 2023

Retrieving UTF8 from Oracle with native driver

Has anyone successfully used LiveCode's database functions, with the native Oracle driver, to retrieve UTF8? The application is running on a Windows 2008r2 machine, addressing Oracle Database 11g Release 11.2.0.2.0 - 64bit Production. The particular column in the database is apparently in UTF8, acco...
by benr_mc
Mon Mar 12, 2007 10:53 am
Forum: Building Externals
Topic: XCMD -> Revolution External shim kit?
Replies: 0
Views: 4432

XCMD -> Revolution External shim kit?

I know - and I agree - most of the XCMDs one used to use can be recoded in Transcript, often with no loss of speed, sometimes even an increase, and obviously with a gain in portability. But I am left with a couple of XCMDs that I don't want to be ported to Transcript, because their value is that the...
by benr_mc
Tue May 23, 2006 8:29 am
Forum: Off-Topic
Topic: only announcement shown when not logged in
Replies: 17
Views: 23294

That's right - the announcements forum is public, everything else requires registration. The forums are only partially public by design. Registration isnt asking much if you are a sentient being and have a modest interest in Revolution. Lynn, I disagree with your policy - but that's your decision. ...

Go to advanced search