Search found 20 matches
- Fri Jun 10, 2022 9:40 am
- Forum: Databases
- Topic: Does anyone use LiveCode (on any platform) with Oracle?
- Replies: 4
- Views: 16859
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...
- Fri May 06, 2022 10:55 am
- Forum: Databases
- Topic: Does anyone use LiveCode (on any platform) with Oracle?
- Replies: 4
- Views: 16859
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?
- Mon Mar 28, 2022 11:55 am
- Forum: Databases
- Topic: Reading integers sometimes truncated
- Replies: 7
- Views: 6801
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...
- Mon Mar 28, 2022 10:04 am
- Forum: Databases
- Topic: Reading integers sometimes truncated
- Replies: 7
- Views: 6801
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...
- Sun Mar 27, 2022 7:03 pm
- Forum: Databases
- Topic: Reading integers sometimes truncated
- Replies: 7
- Views: 6801
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 ...
- Sun Mar 27, 2022 8:02 am
- Forum: Databases
- Topic: Reading integers sometimes truncated
- Replies: 7
- Views: 6801
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...
- Fri Mar 11, 2022 7:54 pm
- Forum: Databases
- Topic: Can't use ODBC on Linux - no error reported
- Replies: 2
- Views: 4265
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.
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.
- Fri Mar 11, 2022 5:39 pm
- Forum: Databases
- Topic: Can't use ODBC on Linux - no error reported
- Replies: 2
- Views: 4265
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...
- Fri Mar 11, 2022 11:44 am
- Forum: Linux
- Topic: revOpenDatabase (ODBC) failing with no error on Ubuntu 18
- Replies: 0
- Views: 14081
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...
- 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: 8618
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...
- Tue Feb 25, 2020 12:34 pm
- Forum: Using Externals
- Topic: Bluetooth promiscuity - mergBLE confusion
- Replies: 0
- Views: 10915
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...
- Thu Mar 12, 2015 10:27 am
- Forum: Engine Contributors
- Topic: Retaining Backwards Compatibility in a Changing World
- Replies: 52
- Views: 46872
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...
- Mon Feb 17, 2014 9:31 pm
- Forum: Databases
- Topic: Retrieving UTF8 from Oracle with native driver
- Replies: 0
- Views: 2088
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...
- Mon Mar 12, 2007 10:53 am
- Forum: Building Externals
- Topic: XCMD -> Revolution External shim kit?
- Replies: 0
- Views: 4538
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...
- Tue May 23, 2006 8:29 am
- Forum: Off-Topic
- Topic: only announcement shown when not logged in
- Replies: 17
- Views: 25670
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. ...