SQLite ALTER added columns not sticking around (or are they

[dochawk]

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.

Code: Select all

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

produces

Code: Select all

0   dnaKey int 1 1

after my creation of the database.

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

Code: Select all

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

)

I then tell it

[shaosean]

Looks like some of your post got lost somewhere..

[dochawk]

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