On Thu, Mar 12, 2015 at 10:21 AM, Peter Haworth <p...@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
