SQLite Problem

[Ralph DiMola]

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
rdimola at evergreeninfo.net

-----Original Message-----
From: use-livecode [mailto:use-livecode-bounces at lists.runrev.com] 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 <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
_______________________________________________
use-livecode mailing list
use-livecode at lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode