Uni_GenerateINT_2:
Generate .INT File from Table/View/Synonym¶
How To Access:
This option is used when you write a DataFlex program that accesses a table that was created or modified on the target DBMS. Before you can access the table from a DataFlex application, you must bring the table into the DataFlex environment by generating the .INT file, adding an entry for it in the filelist and generating .FD files for compilation.
When the dialog box is first displayed, the previously selected Fetch objects are retrieved from the target database and displayed in a grid on the left side of the dialog box.
Grid display¶
The grid contains the following columns
Check Box: Select the check box to mark this table for importing into DataFlex.
Icon: A green arrow over the list icon indicates the table already exists in DataFlex.
Table Name: The name of the SQL table on the server.
File Number: The existing (if the table already exists in DataFlex) or proposed (for a new table) file number. File numbers for existing tables cannot be changed. File numbers for new tables can be modified.
The INT file name and FD File Name for the currently selected table are displayed at the bottom of the dialog box.
Right Side Bar¶
Fetch: Select a Fetch radio button on the right to choose the type of object to be retrieved from the target DBMS.
Import SQL relationships: Check this box to import any SQL relationships that exist between tables in the SQL database into the DataFlex tables.
Show INT File info view: Check this box to display the Create Intermediate File dialog box, which allows you to choose additional import settings. Additional settings are not usually required.
Insert into Filelist: Check this box insert the imported tables into the DataFlex filelist.cfg file.
Generate FD File: Check this box to generate the FD file.