>With local error handler you don't have to run Sql select twice.
>
Hi Sergey,
I surrounded this SQL block with local error handler invokation and it worked just fine. Do you see any problems with it and insist on opening table instead?
>>Sergey,
>>
>>Do you know, can I run the same select statement twice or I really need to use "USE" command instead?
>>
>>
>>>See Message #
583255.
>>>
>>>>>Nadya your SELECT will open the tables if they are not already open so when you get that error the table that the SELECT is open don't have the CDX file associated to them.
>>>>>
>>>>
>>>>Hi Alexandre,
>>>>
>>>>Yes, I understand that :) My question is: how can I prevent this error? What should I do?
>>>>
>>>>>>Hi everybody,
>>>>>>
>>>>>>I select multiple files using Common Dialog Control. Then I do a loop and select from each file to cursor. Once in a while I get a message "Structural CDX is not found" and the program stops. I do not open files explicitly, though SELECT statement does it. What can I do to prevent this error?
>>>>>>
>>>>>>Thanks a lot in advance.
If it's not broken, fix it until it is.
My Blog