>>>Hi All:
>>>
>>>In VFP6 I am getting a 'stored procedure executing' error when I issue a close database all or close database command. DBC() shows no databases selected and ADATABASE() show no databases open after the command. I remeber the error also in VFP5, but it did not seem to appear as often.
>>>
>>>Does anyone have any idea of the source of this error; and any fix???
>>>
>>>TIA
>>>
>>>regards
>>
>>have you modified any RI code? Do any other stored procedures use transactions that might not be ending them?
>
>Hi Eric:
>
>No I have not modified RI code. I'll check for non terminating transactions. But I also am getting this error where I am using neither RI nor stored procedures.
>
>Thanks for the insight.
>
>regards,

You're scaring me! I used to get that error often in VFP 5.0 when I tried to use a stored procedure to assign PKs) and have yet to see it in 6.0 (knock on wood). I'm afraid I never took the time to determine the absolute cause; I moved the stored procedure out of the DBC. Are you using any types of triggers or default values in your tables?