Thanks for everyones help, I'm actually building the
query dynamically based on what the user inputs, must
be my string handling functionality in Borland that
causing probs.... Thanks again.
--- Jay Sprenkle <[EMAIL PROTECTED]> wrote:
> > 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.
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
