SQLCE - Flush DB Changes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a series of 5 DELETE queries one after another using a command object followed by execute non query

No objections are raised when I execute the queries, but it seems like they are not flushed to the db immediately

If I exit the application, the DELETIONS are forced to the db

If I don't exit the application, the next time I insert something into one of the tables, the DELETIONS are forced to the db

I have tried closing the connection after the queries, then reopening but this does not force the queries to go to the db

Any ideas?
 
Joseph Rea said:
I have a series of 5 DELETE queries one after another using a command
object followed by execute non query.
Click to expand...

Are they executing within a transaction? If not, I suggest creating
your own transactions and committing them. I have no evidence that this
will help, admittedly, but it's worth a try.
 
I thought of it (Begin and Commit Trx) but have not had a chance to pursue it yet

Thank
 
Back
Top