Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Some RI ideas
Message
 
 
To
17/04/2007 16:33:32
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01216870
Message ID:
01217048
Views:
18
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
Previous
Reply
Map
View

Click here to load this message in the networking platform