Get from ODBC Database

Retrieves data from any ODBC-capable database such as MySQL, Microsoft Access, and Oracle databases.

 

Input Arguments

 

0

Connection String

Connection String

The connection string to the database.

1

Table Name

Table Name

The name of the table to access.

2

String

WHERE

A string containing the SQL selection criteria for the data.

3->n

USER

USER

ADDITIONAL USER-DEFINED ARGUMENTS

 

Return Arguments

None.

 

Returned Status

 

SUCCESS

The data was successfully retrieved from the database.

FAILURE

The database or table could not be accessed.

 

Remarks

Unless you know how to format the connection string, the easiest thing to do is to change the entry method to Browse and then click the down-arrow button in the Value field. This opens the Windows ODBC data source picker, which guides you through selecting the proper database.

Unless you know how to format the table name string, the easiest thing to do is to change the entry method to Browse

(once the connection string has been specified) so that you can enter the value using a graphical user interface.

If the WHERE string results in the selection of more than one record from the database, only the first selected record is considered. For more details on valid SQL strings, search the internet or look into one of many texts on SQL data- bases.

To add, remove, or edit the arguments that will be populated from the table, use the buttons listed under the comment area of the MP editor. When adding arguments, the Description should match the column name, and the data type should be compatible with the data type in the database (values will be converted to the proper type, if possible). To enter the values using a graphical interface, use the Add Using Column Picker button, but be aware that a valid con- nection string must be specified first before using this option.