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
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
to be set to 'real' data.
sqlite3_errmsg(db) returns an empty string.
Thanks
*** Doug Fajardo
3 matches
Mail list logo