Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set TablePrompt scope
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Set TablePrompt scope
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01138569
Message ID:
01138569
Views:
63
Hello All,

I use the SET TABLEPROMPT OFF to allow me to trap errors if a table cannot be opened instead of having VFP bring up a dialog for the user to pick one (Gasp!). It does not state the scope of this command in the help but it seems to be scoped to the entire project (which seems to be validated by the notation you can set it in the Config.FPW file). Seems to work as expected MOST of the time. However, on my login form I have an error logger which brings up the file picker dialog on an INSERT INTO command wrapped by a TRY/Catch.

If I step through the code just prior, I can see by using SET('TABLEPROMPT') that it is set to ON even though every where elese it shows as OFF. I used the code references tool to make sure I didn't have an accidental reference that did this.

Anybody else see this behavior?

Bob
'If the people lead, the leaders will follow'
'War does not determine who is RIGHT, just who is LEFT'
Next
Reply
Map
View

Click here to load this message in the networking platform