>>I propose that you guys are doing something suspicious in these stored procedures. I use this technique all of the time in many different apps, and have never had that problem.
>>
>>Would you be game for posting the procedure at fault?
>
>This is the code I had in the DBC the last time I had problems. It's a procedure for getting a new primary key. It's an old bit of code I got from someone down the line that was probably written for FP 2.6. It works in VFP, but I suppose it wouldn't be a bad idea to update it.
>
This code looks fine to me. It is very similar to what my own ADDID() procedure does. If there are other stored procedures running from triggers or default values, I would be much more suspicious of those...
Erik Moore
Clientelligence