>>>A little off the subject...Be aware that I had to correct the RI code for cascading deletes ( a bug verified by MS) when using SQL delete/insert updates
>>
>>What kind of bug? AFAIK, RI has problems dealing with compound keys, but surrogate keys should work Ok.
>
>If you set the SQL delete old and insert new update method, VFP currently deletes child records. I had to put a patch in the stored procs (delete trigger) to correct this. It is a real pain that I have to remember to save my changes if I have to rebuild the stored procedures, as VFP will overwrite my changes..
Do you mean UpdateType property of remote/local view? Yes, incidentally you can go into troubles here. But I guess, that default setting (Update) shouldn't pose a problem.
Edward Pikman
Independent Consultant