ExecuteSectionN
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.
NOTE: 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 |