General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Duh??? Of course not!!
sqlexec calls that fail return a -1
But....
The arror function does work and that populates an array with the detail info about the error. This is what I meant to say..
My bad!!
Thanks for catching this!
>ON ERROR won't fire for SPT...
>
>>If the call fails, an error is going to occur on the server, which will be surfaced to the client (fox). You could capture the error locally with an On Error routine or perhaps in an error event if this is being done in an object.
>>
>>The best place to trap errors is on the server. However, you can only do that if you use a stored procedure (yet another reason why stored procedures are usually a good way to go..< s >)
>>
>>Instead of rending the sql from the client, you make a stored procedure call like this:
>>
>>msql = 'insert_proc ?mfield1, ?mfield2'
>>
>>In the stored procedure, you can check for the value of @@error. Using an output parameter, you could return the status of whether any errors occurred.
>>
>>
>>
>>>Does anyone know how to "capture" an error generated by SQL Server from a SQL Passthrough statement?
>>>
>>>Example: msql='INSERT INTO table1 (field1,field2,field3) VALUES '+;
>>> '(?mfield1,?mfield2)'
>>>
>>>obviously this INSERT statement would fail with a similar error message below:
>>>
>>>"There are more columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement."
>>>
>>>but is there anyway to capture this error (or any error really)?
>>>
>>>Thanks
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only