Walter Meester
HoogkarspelNetherlands
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
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