General information
Category:
ActiveX controls in VFP
Environment versions
Network:
Windows 2003 Server
This doesn't catch the error. We need to be able to return/throw an error in the VFP Stored Procdure so ADO knows there was an error, but not an actually error in code.
For example, lets say, I have the following update code:
UPDATE accounts SET acctType = 'ABC' WHERE AccountID = ' 1' AND AcctType = ''
The code is valid and no error will be issued, even if nothing was updated. What I need to do, is if nothing is updated, throw an error to ADO. I can't get this to work. ERROR command is a non supported via ole db. You have any sugguestions. We thought about just typeing in A=1...however, that is a nasty looking error message with no meaning at all.
Thanks
Mark
Previous
Next
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