Trigger Failure

[DTRNTR]

I have A stored procedure in a VFP DB that I am attempting to call on an UPDATE trigger.

If I update a record from within FoxPro Browse, the trigger executes without a problem. When updating from an .ASP I am receiving:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Visual FoxPro Driver]Trigger failed.

Not sure why I would be getting an ODBC driver error?

Thanks in advance for any help you can provide!

 

[rgbean]

It depends a lot on the code you have in this trigger. There are are number of things that the ODBC drivers don't support. (e.g. PACKing another table). Also, are you using the standard MS supplied RI routines, or are using one of the many 3rd party substitutes?

Rick

 

[DTRNTR]

Rick,

I've tried to make the procedure call without any 'guts' behind the procedure itself. The procedure now is merely:

Procedure XYZ
Endproc

....and yet I still get the same error message.

Regarding the RI routines, we have not installed any 3rd party RI tools and no associations have been defined between the tables in this particular database.

DTR

 

[rgbean]

Assuming this code is actually in a stored procedure in the DBC, then it should work. I would try explicitly returning a TRUE value, in case this is causing a problem.

Procedure XYZ
RETURN .T.
Endproc

Note: If you do examine some of the generated RI code, you'll see that "almost" anything can be done in one of these trigger procedures - as long as it's all in the stored procedures - I don't believe you can't reference outside procedures and still use these in ODBC.

Rick