Re: [sqlite] Data structure for versioned data

Not quite the same issue, but I've set up triggers to generate a journal record whenever a record is added/changed/deleted from a table. This mechanism (triggers) could easily be used to generate a 'version' record. *** Doug F. John Stanton wrote: > We perform some versioning by holding column mat

[sqlite] alter table syntax ?

Help! I keep getting a syntax error from the 'alter table' sql command, when used to add a column to a table. Can someone help with this error? Below is an example of one attempt, and its results: [tuna]$ sqlite test2.db SQLite version 2.8.16 Enter ".help" for instructions sqlite> create table x1

[sqlite] help - sqlite3_get_table returns SQLITE_ROW?

to be set to 'real' data. sqlite3_errmsg(db) returns an empty string. Thanks *** Doug Fajardo