LiveCode Forums.

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 ...

I have encountered a few problems with retrieving data from Oracle using LiveCode on various platforms - has anyone else worked with this combination?

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 ...

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 ...

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 ...

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 ...

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.

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 ...

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 ...

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 ...

[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 ...

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 ...

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 ...

That was a creative thought - using the Tango library - and I got all excited about it - but I took a look at the Creative Commons Attribution Share-Alike License, and as Obleo says, it includes the requirement
Share Alike. If you alter, transform, or build upon this work, you may distribute the ...

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 ...