Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error when generating RI
Message
De
16/04/2003 15:51:03
Walter Meester
HoogkarspelPays-Bas
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00778363
Message ID:
00778571
Vues:
26
Jon,

I don't know the exact answer to your question, but why don't you try my TaxRiBuilder available from the files section. It will run perfectly within VFP 8 and should also take care of additional function after the RI function in the INSERT,DELETE and UPDATE triggers.

The TaxRiBuilder has many advantages over the normal Ribuilder. For example: it's more flexible, faster, creates compacter and more readable RI code, but is fully compatible with the standard RI builder.

Walter,



>OK - was able to do a little more research and found out some information. This error is being generated from VFP's RI builder - NOT our own procedure code. I did, however, get the debugger to pop up and I see the problem but I don't know how to resolve it.
>
>Using a table called "Lags" as an example, here is our CURRENT insert trigger on the table as it existed under VFP7:
>
>__ri_insert_lags().AND.(createauditrecord("Insert"))
>
>Obviously, we manually added everything after __ri_insert_lags(). When regenerating the RI under VFP7 there is no problem. However the VFP8 builder does something different. The reason we're getting the error is because the variable lcOldTrigger only contains ".AND.(createauditrecord("Insert"))". So, the statement "CREATE TRIGGER ON (tcTableName) FOR &tcEvent AS &tcOldTrigger" would indeed fail because there is nothing to the left of the ".AND.".
>
>Any ideas on how we are supposed resolve this? If this change to the RI builder is documented somewhere where is it? If it isn't, then why not??
>
>Jon
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform