> Put mulitple record into your table and see what
> occurs.....

D:\temp\convention>sqlite3 test.db
SQLite version 3.0.8
Enter ".help" for instructions
sqlite> create table t (a, b);
sqlite>  insert into t (a, b) values ('foo', 'bar');
sqlite>  insert into t (a, b) values ('test', '2');
sqlite> select * from t;
foo|bar
test|2
sqlite> update t set a = 'foo;qux', b = 'barr' where a = 'foo';
sqlite> select * from t;
foo;qux|barr
test|2
sqlite>

works fine here.

Reply via email to