Walter Meester
HoogkarspelPays-Bas
Hi jeff,
>>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 ?
>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.
Cascading updates and deletes are possible from the VFP ribuilder. I think you're confused with the fact that you cannot update, insert or delete records (within the trigger) from the same alias which called the trigger.
Therefore you might use the record validation rule, which can handle such things.
Walter,
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement