SQLite Problem

Dr. Hawkins dochawk at gmail.com
Sat Mar 14 12:47:10 EDT 2015


On Thu, Mar 12, 2015 at 10:21 AM, Peter Haworth <pete at lcsql.com> wrote:

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

I have found relying on revDatabaseColumnaNames() and
revDatabaseTableNames() unreliable--tablenames so much so that I've written
my own function twice for postgres, as livecode's misses tables
sporadically.

OK, columnNames may be guilt by association.  And it looks like this has
only bitten on postgres, as the switch uses revDatabaseTableNames() for
sqlite.


-- 
Dr. Richard E. Hawkins, Esq.
(702) 508-8462



More information about the use-livecode mailing list