The tool supports interface of Foresight Analytics Platform 9 or earlier.

SQL Command Parameters

The SQL Command dialog box can be opened on creating or editing an SQL command.

Set up SQL command parameters:

begin

delete from OBJ32305 where Field2=78;

insert into OBJ32305 values('Moscow', 56,13);

end;

delete from OBJ32305 where Field2=78

/

insert into OBJ32305 values('Moscow', 56,13)

delete from OBJ32305 where Field2=78;

insert into OBJ32305 values('Moscow', 56,13)

Command text is automatically saved for the selected driver. Text can be specified for each driver. The text, which was previously set for the driver, is displayed when the driver is changed.

NOTE. Separate use of the semicolon separator is denied for Oracle drivers. It can be used only within the "Begin…end;" brackets.

NOTE. If no text is set for other DBMS drivers, no message is displayed.

Dialog Box for Multiple SQL Commands

The database of the SQL command specified in the connection when the Use Another Connection checkbox is selected may be missing on opening the update. In this case an altered icon is displayed next to the command:

Open command parameters dialog box to check command settings. If parameters of multiple commands need to be checked, it is possible to open the edit dialog box for all selected commands and specify the database. In this case the parameters dialog box looks as follows:

The user needs to select a database in the list of repository objects. The selected database is set for all edited SQL commands.

See also:

Working with SQL Commands