If found that revDatabaseColumnaNames() is beyond all belief extremely slow(better part of a second). A SQLite update program sped up better than 10 times when I cached the column names.
SQLite Windows XP Ralph DiMola IT Director Evergreen Information Services [email protected] -----Original Message----- From: use-livecode [mailto:[email protected]] On Behalf Of Dr. Hawkins Sent: Saturday, March 14, 2015 12:47 PM To: How to use LiveCode Subject: Re: SQLite Problem On Thu, Mar 12, 2015 at 10:21 AM, Peter Haworth <[email protected]> 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 _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
