FiveTech Software tech support forums

Hello,

I use traditional navigation access (like any RDD) to ADT files and SQL with RDDADS, when I have some error in SQL operation
a dialog error is showed, are there some seting to avoid it?

Rergards

Marcelo

I suggest you use TRY .. CATCH .. END.
When an error occurs you can retrieve the error with ADS functions and deal with the error accordingly.

For SQL statments, I stongly suggest you first try executing manually in Arc32 and only when the SQL runs there without errors you should incorporate in your code.

Hello,

thanks for response, I don't have problems with SQL sentences (sintax ,etc), e.g. if you try to delete some record DELETE FROM table WHERE column=data
if some row on the table are locking for other user you have an error from ADS not from xHabour, the TRY CATCH not work for this situation the ADS error dialog
will be present in the screen

regards

Marcelo

nageswaragunupudi wrote:I suggest you use TRY .. CATCH .. END.
When an error occurs you can retrieve the error with ADS functions and deal with the error accordingly.

For SQL statments, I stongly suggest you first try executing manually in Arc32 and only when the SQL runs there without errors you should incorporate in your code.