Wrong results with revDatabaseColumnNamed

[D4vidrim]

I'd like to ask about a problem I'm having with LiveCode Community Edition.

I make a database connection to the oracle DB we have in our company, via ODBC.
But I think there is some kind of bug in this function: revDatabaseColumnNamed

If I use this query

put "SELECT amc01_id_elab as amc01_id_elab FROM amc01_avvio" into sqlQuery

where this table amc01_avvio has only one column called amc01_id_elab, with only one record (32)


I get "3" as a result of the query. (first char of the result, while I should get 32)


BUT if I use this query:

put "SELECT 'id_' || amc01_id_elab as amc01_id_elab FROM amc01_avvio" into sqlQuery

I get 'id_32' as a result of the query. (which is correct)


It is like in some occasions, I only get the first char of the result, instead of getting the full value.

I've read on the forum that the same problem has happened before:
http://forums.runrev.com/phpBB2/viewtop ... med#p21355

But I have no idea how to solve it.

Thanks for any suggestions!

[Mark]

Hi,

I don't see what this problem has to do with revDatabaseColumnNamed.

Make sure that your database returns plain ASCII text. That should work. If not, please post the LiveCode syntax used to retrieve the data.

Kind regards,

Mark