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