>I wouldn't ever insist but I could recomend. :)

BTW, recommend :)

>
>I always open tables explicitly in my code and I would recomend that you do the same. This way the code is easier to read and maintain. Also you can handle problems with openning tables in one place, your opentable program.

Ok, seem like very valuable points, so I re-program :)

Ok, I did and it works fine. Thanks.

>
>>>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.