>Hi jeff,
>
>>>After having looked at much of the source code that ships with VFP (from GenMenu and the Class Browser to the entire VFP6 Framework) over the years, it isn't hard to notice the ugly code - it works, but some of it is sure ugly.
>>>
>>>However, I nominate the RI Generator to the
VFP Ugly Code Hall of Shame as generating the ugliest code I have ever seen.
>>
>>Ooooo. Yes, that is some ugly code. I definitely second that nomination. Not only that, but the RI capabilities of VFP leave much to be desired (as compared to a server database like SQL Server or Oracle). I've rarely seen the RI generator used with VFP databases.
>
>Have you looked at my TaxRiBuilder in the download section ? It produces far better readable code, is faster, more flexible and more compact. Can you describe on which areas you think the common VFP RI builder falls short ?
>
>Walter,
Hmmm. It's been a while since I've actually tried to use it (may have been as far back as VFP 3.0) but I do recall not being able to do any table updates (i.e. cascading deletes, inserts, updates, sum totals) from an RI generated trigger. Could have been my lack of understanding of the tool's capabilities but I recall SQL Server and Oracle being fully capable of using an update trigger.
Jeff Trockman, MCP