Android Question SQLite Open, Insert Update Delete test for successful completion

[Domingo Garcia]

Hello,
How do I test to verify that an Open of an SQLite DB was successful, same for the Insert/Update/Delete commands, the only one that has a result code seems to be Select.

Thanks

 

[Jeffrey Cameron]

I'm not sure what you mean by "test." The result from a SQL query is dependant upon the query (some queries return nothing, some return success/failure, some the number of rows modified).

If you're looking to see if the command itself failed (i.e. missing file, malformed SQL, etc.) then wrap your command/query in a TRY /CATCH and handle the exception accordingly.

 

[Erel]

As Jeffrey wrote, an exception will be raised if any operation failed. So if there is no exception then the database was opened successfully.

 

[Domingo Garcia]

OK, how do I test for that exception. on the Open DB, INSERT, UPDATE are they all the same?

 

[Mahares]

OK, how do I test for that exception. on the Open DB, INSERT, UPDATE are they all the same?

Hey Domingo: You do something like this;

SQL1.BeginTransaction
Try
  'Execute the sql statements or the NON Query statements: DELETE/UPDATE/INSERT.
SQL1.TransactionSuccessful
Catch
   'the transaction will be cancelled
     Log(LastException.Message)
End Try
SQL1.EndTransaction

 

[Domingo Garcia]

Great, Thanks a bunch....