>>Native RI builder allows to insert NULLs. At least in VFP8 it does. Basically, it gives an error on SEEK command, which is handled in rierror routine and as the end result returns true.
>
>I had tested it only on VFP9 and it doesn't allow to insert NULLs ("trigger failed in child_table"). But I just tested it on VFP8 and there it works fine ! It doesn't have to do with the generated code. Building the RI code in VFP8 and inserting in VFP9 doesn't work either. I didn't try it the other way round as I am not interested in working with VFP8. I suspect that the RI builder wasn't changed between VFP8 and VFP9.
>I will try to submit this as a VFP9 bug.

Hi David,

It actually did change a little bit. Yesterday there was a thread from Debra S (don't remember her last name) and she pointed out to the lines of code which were changed and gave her now some trigger failures where she didn't have this problem before. Alexey from MS claims, that the code is now more bullet-proof and it's good that it is failing...

Anyway, you better check that thread yourself.
>
>>I'm currently writing my own RI builder where I'll try to avoid things which are not allowed in the Ole Db. Do you have link handy?
>
>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_foxhelp/html/dglrfunsupportedvisualfoxprocommandsfunctions.asp
>

Yep, I found that link. I noticed that SET COMPATIBLE is in the list of unsupported commands, yet VFP native code has it. On the other hand, evaluate, execscript, & are not listed there, though in my opinion they should, because these commands present a clear security whole...

In my code I want to use ON ESCAPE to provide a graceful exit (though it doesn't seem to work 100% so far), so I'm unable to create a builder which would work with Ole DB.
Here is the thread, where I'm exchanging ideas about triggers with Gregory Adam and Thomas (?), you may jump in
Re: SEEK(),INDEXSEEK() or KeyMatch() or SELECT-SQL? Thread #1002645 Message #1004128
>Thanks a lot for that input !

You too. I gained a lot from your thread.