General information
Category:
Coding, syntax & commands
>>Our office has a decent error handler currently, but needs one more piece to identify.
>>
>>Lets say in a program we have
>>
>>select * from SomeTable into cursor test1
>>
>>and the "SomeTable" is not yet opened, or part of the path. By default VFP will bring up the Open table dialog and wait for a response for the user to pick a file, or cancel. Only then, with the error get trapped upon return.
>>
>>Q: Is it possible to turn the automatic Open table dialog off so it goes directly to the error handler?
>>
>>TIA
>
>Probably, the better way is to check
>IF USED("mytable") before firing SELECT-SQL.
Yeah, I would, but I don't want to go back to every possible select statement and pre-verify all possible tables being opened. Especially when many of the queries are all generated on the fly, and the aliases Source can constantly change... Yes, I could apply the IF USED( lcNewSource ), but again, don't want to go back to every class/form to qualify other developers code.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only