>Nadya,
>
>One thought did occur to me. You mention that you have stored procedures by the same name in different databases. VFP may be caching the first one called in memory, the same way it would do with a regular program (prg). Afterall, stored procedures in VFP DBC's are nothing more than compiled Fox code. If it is doing this, it may lead to the wrong code being executed. If so, it might, to some degree, explain the inconsistent results you're seeing. To test this, you could try the same code with and without a CLEAR PROGRAM issued after the call to the stored proc.
Thanks, George. This explains some problems, we're having. It's very important, so I send it to all my team members. Too bad, I had not started this thread, so I can not award you :)
For the particular application, I already renamed this procedure to something else.
Thanks.
If it's not broken, fix it until it is.
My Blog