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