Hello, Will that decrease the performance of my application?
Thanks, Thiago Mello Em Sex, 2003-11-07 ās 11:46, D. Richard Hipp escreveu: > SQLite does not allow you to read and write the > same table at the same time. You need to finish the > read of TABLE1 before you start changing it. Perhaps > like this: > > BEGIN; > CREATE TEMP TABLE t1 AS SELECT id,name FROM table1; > SELECT id,name FROM t1; > > /* Now in the callback function */ > UPDATE table1 SET number=n+1 WHERE id=X; > /* Return from callback function > > DROP TABLE t1; > COMMIT; --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]