>>I'd say that the database is not selected, maybe none is or another database is selected
>>
>>try this
>>
>>
>>acti screen
>>?'database =', set('database')
>>assert set('database') == 'THEONEYOUWOULDEXPECT'
>>
>>
>>
>>if not used('System_Parameters')
>> use System_Parameters
>>endif
>>
>>
>
>Gregory,
>
>We're going to try that, but the code is executing from the Stored Procedure! So, why executing code from SP doesn't open that database? Does it mean that we can not rely on SP knowing to take tables from the database SP belongs too? But if that's the case, when we may need to change all code in SP to be more explicit about our tables.
Nadya,
Your first message said that the problem occurred after some changes of yours. So I guess there's a problem with the changes you've made. I would look there first since it used to work, didn't it ?
Gregory