Re: SQLite Problem

For Sqlite, you can query the sqlite_master table: select tbl_name from sqlite_master where type = ‘table’ Bob S On Mar 14, 2015, at 09:47 , Dr. Hawkins mailto:doch...@gmail.com>> wrote: I have found relying on revDatabaseColumnaNames() and revDatabaseTableNames() unreliable--tablenames so mu

Re: SQLite Problem

s > 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 wrote: > > > No errors on that. Subsequently I use revDatabaseColumnNames to get > > the column names followed by a loop

RE: SQLite Problem

-Original Message- From: use-livecode [mailto:use-livecode-boun...@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 wrote: > No errors on that. Subsequently I

Re: SQLite Problem

On Thu, Mar 12, 2015 at 10:21 AM, Peter Haworth 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

SQLite Problem

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

Re: SQLite problem on iOS Simulator

Ah, OK. Glad it was a simple fix. Pete lcSQL Software Home of lcStackBrowser and SQLiteAdmin On Sun, Jul 6, 2014 at 1:41 PM, Klaus major-k wrote: > Hi Peter, > > Am 06.07.2014 um 21:26 sc

Re: SQLite problem on iOS Simulator

Hi Peter, Am 06.07.2014 um 21:26 schrieb Peter Haworth : > Have you checked the contents of tDBID? I don;t see it as a a parameter to > your function. you obviously missed my second posting where I embarrassingly had to admit that i did not check "SQLite" on the "iOS" tab of the standalone buil

Re: SQLite problem on iOS Simulator

Have you checked the contents of tDBID? I don;t see it as a a parameter to your function. Pete lcSQL Software Home of lcStackBrowser and SQLiteAdmin On Sun, Jul 6, 2014 at 7:46 AM, Klaus ma

Re: SQLite problem on iOS Simulator

Hi all, of course I need to check "SQLIte" on the "iOS" tab in the standalone builder settings! 8-) Am 06.07.2014 um 16:46 schrieb Klaus major-k : > Hi friends, > > strange problem when using SQLite in the iOS Simulator. > LC 6.6.2, XCode 5.1, Simulator iOS 7.1 > > Database file copied to spe

SQLite problem on iOS Simulator

Hi friends, strange problem when using SQLite in the iOS Simulator. LC 6.6.2, XCode 5.1, Simulator iOS 7.1 Database file copied to specialfolderpath("documents") In general all database access runs fine, but there is one handler where CONSOLE outputs an script error, found out by using a TRY s