File Menu¶

The File menu lets you select the DataFlex filelist or workspace, connect to the target server, or run a DataFlex program.

  • Login (Toolbar Item i_Login): Connects the user to the database server.

  • Logout (ToolbarItem i_Logout): Disconnects the user from the database server.

  • Open|Select Workspace (Toolbar Item i_Folder or i_Folder droppdown, i_SelectWorkspace): Displays the Workspace Manager dialog box, which lists the available Visual DataFlex (VDF) workspaces for the selected VDF Version.

  • Open|Select Filelist (Toolbar Item i_Folder dropdown, i_SelectFilelist): Displays the Select a FileList dialog box which allows you to select a DataFlex filelist.

  • Open|Files Without Filelist Entry (Toolbar Item, i_Folder dropdown, i_FilesWOFilelist): Displays a Open File dialog. Select which .dat or .int file you wish to load into the utility and press Open. The Add/Remove Driver Prefix buttons will not work when selecting files this way.

  • Open|Open Last filelist: Opens the last filelist loaded into the Flex2SQL utility.

  • Add Filelist Item (Toolbar Item i_FileListItemEdit): Displays the Add/Edit a Filelist dialog which allows you to add a file to the filelist.

  • Edit Filelist Item (Toolbar Item i_FileListItemAdd): Displays the Add/Edit a Filelist dialog which allows you to modify the selected file in the filelist. This menu item is disabled if no file is selected.

  • Remove Filelist Item (Toolbar Item i_FilelistItemRemove): Deletes the selected file from the filelist. The file/table itself is not deleted. This menu item is disabled if no file is selected.

  • Load Selections: Shows an open file dialog box which allows you to load a previously saved fileset. Please see Save Set button in Convert Dat to Table, Create Intermediate File, or Create Script SQL for more information about File Sets.

  • Recent Filesets: Lists the recently used filesets and allows you to load one. Please see Save Set button in Convert Dat to Table, Create Intermediate File, or Create Script SQL for more information about File Sets.

  • Run a DataFlex Program: Displays a Windows Run DataFlex Program dialog box so you can browse to select and run a DataFlex program. Note: You can only use this option if the program to be run is compiled with the same version of Visual DataFlex as Flex2SQL. Even though DataFlex data files are compatible across different versions of DataFlex, compiled VDF programs are not. Select Help | About from the main menu to view the VDF Runtime Version. Version 17.0.22 in the example below indicates VDF version 17 programs can be run.

  • Exit: Exits Flex2SQL.