Just came across an SQLite problem.

I issued the following statement in a revQueryDatabase command

SELECT Date,printf('%6.2f',Value) FROM Transactions

No errors on that.  Subsequently I use revDatabaseColumnNames to get the
column names followed by a loop using revDatabaseColumnNamed to get the
column values.  The latter returns an error indicating that printf('%6.2f'
and ,Value are invalid column names.

It appears that the comma in the printf command confuses Livecode. If I use
sqlite3 with .mode column and .headings and issue the same statement, it
uses the printf function as the column heading.

There are a couple of workarounds for this. You can change the SELECT
command to use "printf('%6.2f',Value) AS FormattedValue".  Or you can use
revDatabaseColumnNumbered to get the column values in the order they are
referenced in the SELECT statement.
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Reply via email to