[sqlite] not all delete commands completed

Hi there, 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. Was wondering if the format mattered in that the commands were in 43 continous rows,

Re: [sqlite] not all delete commands completed

On Sat, Mar 13, 2010 at 4:16 PM, CDN Mark wrote: > Hi there, > > 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. Was wondering if the forma

Re: [sqlite] not all delete commands completed

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 aft