Hi,
Just wondering what would be a typical SQL request structure with error handling. Here is what I got :
Does that make sense?
[code]Var strSQL As String = “UPDATE inspection.savescaledamages SET” + _
" savescaledamages_dam_uuid = $1" + _
" WHERE savescaledamages_id = $2;"
Var values(1) As Variant
values( 0 ) = dam_UUID
values( 1 ) = id
//Executing the SQL Querry
Try
db.BeginTransaction
db.ExecuteSQL( strSQL, values )
Catch error As DatabaseException
MessageBox("DB Error : " + error.Message )
End Try
//Committing if no error encountered
Try
db.CommitTransaction
Catch error As DatabaseException
db.RollbackTransaction
End Try
[/code]