LiveCode Forums.

Posted: **Fri May 18, 2012 1:03 am**

I've set up a loop to check on fieldnames and add them to the SQLite database, to automatically catch new fields of my interface as they are added.

 put "PRAGMA table_info(dna)" into dCmd
   put revDataFromQuery(tab, cr,theDB,dCmd) into currentFields

produces

0   dnaKey int 1 1

after my creation of the database.

("dnaKey" is indeed what I told it., with

  put "CREATE TABLE dna(dnaKey int NOT NULL, PRIMARY KEY(dnaKey))" into dCmd
   revExecuteSQL debtorDB, dcmd

)

I then tell it

Posted: **Fri May 18, 2012 4:19 am**

Looks like some of your post got lost somewhere..

Posted: **Fri May 18, 2012 11:40 pm**

I set "delete" after the premature transition, but apparently it didn't!

SQLite ALTER added columns not sticking around (or are they