In some cases, you must create multiple [Execute]
sections to execute several SQL statements. If this is set, it executes the SQLStatement
in each of the sections for each row returned by the current query.
This parameter is not normally required. You can usually create a view that contains all the required data and which requires only a single statement that is configured in the [ODBC]
section.
Type: | String |
Default: | |
Required: | No |
Configuration Section: | Database Repository or Execute |
Example: | [ODBC] GroupServerLibrary=ogs_odbc.dll ConnectionString=DSN=Groups ExecuteSection0=ODBC_GetUsers [ODBC_GetUsers] SQLStatement=SELECT DISTINCT Username FROM Groups AddType=USER UserColumn=Username ExecuteSection0=ODBC_GetGroups [ODBC_GetGroups] SQLStatement=SELECT Groupname FROM Groups WHERE Username='@(Username)' AddType=USERGROUP UserColumn=@(Username) GroupColumn=Groupname In this example, no SQL statement is found in the In this case, multiple execute sections are not necessary and the configuration can be simplified: [ODBC] GroupServerLibrary=ogs_odbc.dll ConnectionString=DSN=Groups SQLStatement=SELECT Username, Groupname FROM Groups AddType=USERGROUP UserColumn=Username GroupColumn=Groupname NOTE:
|
See Also: | SQLStatement |
|