Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Some RI ideas
Message
 
 
À
17/04/2007 16:33:32
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01216870
Message ID:
01217048
Vues:
19
Hi Olaf,

Looks like native RI is buggy by itself in VFP8. It returns Data Type mismatch on the line
llRetVal=!SEEK(lcParentID,lcChildWkArea)
Now, how can I turn RI off? Set everything to ignore?

I think I better go from the interface for now.

Also I still can not figure out how to delete the first record in a grid.

>You may already know all this:
>
>Regarding deployment of dbc changes: For deploying the new stored procedures you can hack into the dbc, use it as a table and change the content of the Code memo field in the record 3 (source code) and record 4 (object code).
>
>Besides that ALTER TABLE and COMPILE are available commands at runtime, also COMPILE DATABASE.
>
>Even if you use native RI you can add an additional trigger running before or after the native one.
>dbgetprop() gets you the expression used for each trigger, DELETE TRIGGER and CREATE TRIGGER helps you to redefine them. To disable triggers, eg for bulk insert, you could set the insert triggers to something like (TYPE("glRIOff")="L" .And. glRIOff) .Or. (...insert trigger expression...). Otherwise delete the triggers (of course not the stored procedures) and recreate them after the bulk insert.
>
>Bye, Olaf.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform