Jon,

I did use this strategy a long time ago, and stopped using this, because it gave me all kinds of problems when wanting to do some datamunging outside the application. Only the RI I handle via triggers. For the rest I use form or buisiness object based checks and procedures.

However. It still is strange the TaxRi does not work. If you can find out I would be very pleased. Maybe the compiled _Handleri procedure grew out of the maximum size of 64 Kb, at which case you'll have to split it up into two (Take out a bunch of CASE statement, PLACE an OTHERWISE and refer to an addition procedure (Like _HandleRi2) and place the cut CASE statements in there).

Anyway's, I would not spend my energy in the OLD vfp RI builder, just find out what's wrong with TAXRI and we'll work to a solution.

Walter,





>>Very strange. You're using the same database for your tests in VFP 7.0 and 8.0. If not and index could be corrupt or something.
>>
>>At this time I did not have any reports of the TaxRi code failing, so I could very little for you at this time. The best you can do is to place a set step on at the beginning of the _RIHandle procedure and find out where things go wrong. If you can find out, please give me a mail and I can see what I can do for you.
>
>Walter,
>
>I will have to see if I can get something together for you. Yes, the exact same database is used for testing in VFP7/VFP8 and VFP7's RI gets generated flawlessly. TaxRI is creating the triggers successfully but something is obviously not working in the implementation. If I have some spare time, I'll look into stepping through the handler to see why it's not working.
>
>The real thing that bothers me, though, is that the RI builder that comes with VFP is supposed to work! Given the traditional short-staffing of Microsoft's support for VFP, I'm really not looking forward to submitting this problem through that channel but it seems I've no choice in the matter.
>
>Is there no one else here who has added function/procedure calls to their database triggers?
>
>Laterness,
>Jon