On 13 Mar 2010, at 10:16pm, CDN Mark wrote: > am trying to run an sql file of DELETE commands, but not totally successful. > Of the 43, only 30 deleted from the database on the first try, second time 10 > more, third time 2 more, one wouldn't delete.
Try putting BEGIN ... COMMIT before and after the commands. I mean BEGIN before the first DELETE command, and COMMIT after the last one. > Was wondering if the format mattered in that the commands were in 43 > continous rows, but everywhere I've seen about the DELETE command it quotes > it as DELETE xxxx on one line, with the WHERE xxxx on the next line. Doesn't matter. SQL commands don't end until the ';'. You can split a command into as many lines as you want and SQL doesn't notice it until the ';'. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
