SET TABLEPROMPT Command

Enables or disables display of the Open Dialog Box (Visual FoxPro) in commands that allow the user to select a table (or view) if one is not open.

SET TABLEPROMPT ON | OFF

Parameters

• ON
  (Default) The Open dialog box is displayed when no table or view is open, and a command is executed that requires an open table or view.

  The Visual FoxPro SELECT - SQL command looks for tables in all work areas in the current session. Other commands only look for a table in the current work area unless a work area is explicitly specified. The following are some of the commands affected by the TABLEPROMPT setting.

  SELECT - SQL Command

  DELETE - SQL Command

  INSERT - SQL Command

  UPDATE - SQL Command

  BROWSE Command

  GO | GOTO Command

  INDEX Command

  PACK Command

  REPLACE Command (Visual FoxPro)

  REPORT FORM Command

  SET FILTER Command

  SKIP Command

  ZAP Command

• OFF
  The Open dialog box is suppressed when no table or view is open, and a command is executed that requires an open table or view.

  The command will fail and an error will be generated. Typical errors are File "name" does not exist (Error 1) and No table is open in the current work area (Error 52).

Remarks

You can use SET("TABLEPROMPT") to determine the current setting. You can also specify a startup value for TABLEPROMPT in the Config.fpw, the Visual FoxPro configuration file.

This feature is supported in COM server scenarios (MTDLL and DLL) where users do not have access to a user interface. SET TABLEPROMPT provides similar support in Visual FoxPro. You can use SYS(2335) - Unattended Server Mode to control modal states for COM servers.

See Also

Reference

Open Dialog Box (Visual FoxPro)
GETFILE( ) Function
Special Terms for Configuration Files