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