When creating a Transaction Services document, users should leverage these two settings. The settings themselves are independent of each other and show different behavior when used in different combinations, outlined below for when no input is defined in the transaction:
ArgumentDescriptionevt2001 - browseFolder Allows users to browse folders when providing an ID, folder name or system folder IDsrcSpecifies both the page component to handle the action and the event.systemFolderAllows access to different folders based on an internal ID (The EnumDSSXMLFolderNames enumeration contains a list of the valid system folders)folderIDSpecifies the ID of the folder to browsefolderNameSpecifies the name of the folder to browse. Uses the first match, in case of multiple matches.No input defined when...Web "Input is required" check box is checkedWeb "Input is required" check box is uncheckedDeveloper "Required" drop down is set to YesUsers will see "One or more required inputs have not been modified".A NULL will be inserted into the SQL if no input is defined.Developer "Required" drop down is set to NoUsers will see "One or more required inputs have not been modified".An error will be delivered by the driver outlining incorrect syntax if input-dependent SQL is not configured.
|
ArgumentDescriptionevt2001 - browseFolder Allows users to browse folders when providing an ID, folder name or system folder IDsrcSpecifies both the page component to handle the action and the event.systemFolderAllows access to different folders based on an internal ID (The EnumDSSXMLFolderNames enumeration contains a list of the valid system folders)folderIDSpecifies the ID of the folder to browsefolderNameSpecifies the name of the folder to browse. Uses the first match, in case of multiple matches.No input defined when...Web "Input is required" check box is checkedWeb "Input is required" check box is uncheckedDeveloper "Required" drop down is set to YesUsers will see "One or more required inputs have not been modified".A NULL will be inserted into the SQL if no input is defined.Developer "Required" drop down is set to NoUsers will see "One or more required inputs have not been modified".An error will be delivered by the driver outlining incorrect syntax if input-dependent SQL is not configured.
|
ArgumentDescriptionevt2001 - browseFolder Allows users to browse folders when providing an ID, folder name or system folder IDsrcSpecifies both the page component to handle the action and the event.systemFolderAllows access to different folders based on an internal ID (The EnumDSSXMLFolderNames enumeration contains a list of the valid system folders)folderIDSpecifies the ID of the folder to browsefolderNameSpecifies the name of the folder to browse. Uses the first match, in case of multiple matches.No input defined when...Web "Input is required" check box is checkedWeb "Input is required" check box is uncheckedDeveloper "Required" drop down is set to YesUsers will see "One or more required inputs have not been modified".A NULL will be inserted into the SQL if no input is defined.Developer "Required" drop down is set to NoUsers will see "One or more required inputs have not been modified".An error will be delivered by the driver outlining incorrect syntax if input-dependent SQL is not configured.
|
ArgumentDescriptionevt2001 - browseFolder Allows users to browse folders when providing an ID, folder name or system folder IDsrcSpecifies both the page component to handle the action and the event.systemFolderAllows access to different folders based on an internal ID (The EnumDSSXMLFolderNames enumeration contains a list of the valid system folders)folderIDSpecifies the ID of the folder to browsefolderNameSpecifies the name of the folder to browse. Uses the first match, in case of multiple matches.No input defined when...Web "Input is required" check box is checkedWeb "Input is required" check box is uncheckedDeveloper "Required" drop down is set to YesUsers will see "One or more required inputs have not been modified".A NULL will be inserted into the SQL if no input is defined.Developer "Required" drop down is set to NoUsers will see "One or more required inputs have not been modified".An error will be delivered by the driver outlining incorrect syntax if input-dependent SQL is not configured.
|
ArgumentDescriptionevt2001 - browseFolder Allows users to browse folders when providing an ID, folder name or system folder IDsrcSpecifies both the page component to handle the action and the event.systemFolderAllows access to different folders based on an internal ID (The EnumDSSXMLFolderNames enumeration contains a list of the valid system folders)folderIDSpecifies the ID of the folder to browsefolderNameSpecifies the name of the folder to browse. Uses the first match, in case of multiple matches.No input defined when...Web "Input is required" check box is checkedWeb "Input is required" check box is uncheckedDeveloper "Required" drop down is set to YesUsers will see "One or more required inputs have not been modified".A NULL will be inserted into the SQL if no input is defined.Developer "Required" drop down is set to NoUsers will see "One or more required inputs have not been modified".An error will be delivered by the driver outlining incorrect syntax if input-dependent SQL is not configured.
|
ArgumentDescriptionevt2001 - browseFolder Allows users to browse folders when providing an ID, folder name or system folder IDsrcSpecifies both the page component to handle the action and the event.systemFolderAllows access to different folders based on an internal ID (The EnumDSSXMLFolderNames enumeration contains a list of the valid system folders)folderIDSpecifies the ID of the folder to browsefolderNameSpecifies the name of the folder to browse. Uses the first match, in case of multiple matches.No input defined when...Web "Input is required" check box is checkedWeb "Input is required" check box is uncheckedDeveloper "Required" drop down is set to YesUsers will see "One or more required inputs have not been modified".A NULL will be inserted into the SQL if no input is defined.Developer "Required" drop down is set to NoUsers will see "One or more required inputs have not been modified".An error will be delivered by the driver outlining incorrect syntax if input-dependent SQL is not configured.
|
ArgumentDescriptionevt2001 - browseFolder Allows users to browse folders when providing an ID, folder name or system folder IDsrcSpecifies both the page component to handle the action and the event.systemFolderAllows access to different folders based on an internal ID (The EnumDSSXMLFolderNames enumeration contains a list of the valid system folders)folderIDSpecifies the ID of the folder to browsefolderNameSpecifies the name of the folder to browse. Uses the first match, in case of multiple matches.No input defined when...Web "Input is required" check box is checkedWeb "Input is required" check box is uncheckedDeveloper "Required" drop down is set to YesUsers will see "One or more required inputs have not been modified".A NULL will be inserted into the SQL if no input is defined.Developer "Required" drop down is set to NoUsers will see "One or more required inputs have not been modified".An error will be delivered by the driver outlining incorrect syntax if input-dependent SQL is not configured.
|
ArgumentDescriptionevt2001 - browseFolder Allows users to browse folders when providing an ID, folder name or system folder IDsrcSpecifies both the page component to handle the action and the event.systemFolderAllows access to different folders based on an internal ID (The EnumDSSXMLFolderNames enumeration contains a list of the valid system folders)folderIDSpecifies the ID of the folder to browsefolderNameSpecifies the name of the folder to browse. Uses the first match, in case of multiple matches.No input defined when...Web "Input is required" check box is checkedWeb "Input is required" check box is uncheckedDeveloper "Required" drop down is set to YesUsers will see "One or more required inputs have not been modified".A NULL will be inserted into the SQL if no input is defined.Developer "Required" drop down is set to NoUsers will see "One or more required inputs have not been modified".An error will be delivered by the driver outlining incorrect syntax if input-dependent SQL is not configured.
|
ArgumentDescriptionevt2001 - browseFolder Allows users to browse folders when providing an ID, folder name or system folder IDsrcSpecifies both the page component to handle the action and the event.systemFolderAllows access to different folders based on an internal ID (The EnumDSSXMLFolderNames enumeration contains a list of the valid system folders)folderIDSpecifies the ID of the folder to browsefolderNameSpecifies the name of the folder to browse. Uses the first match, in case of multiple matches.No input defined when...Web "Input is required" check box is checkedWeb "Input is required" check box is uncheckedDeveloper "Required" drop down is set to YesUsers will see "One or more required inputs have not been modified".A NULL will be inserted into the SQL if no input is defined.Developer "Required" drop down is set to NoUsers will see "One or more required inputs have not been modified".An error will be delivered by the driver outlining incorrect syntax if input-dependent SQL is not configured.
|
To avoid driver errors, users have two options:
- Change all inputs to required for the transaction, which will insert a NULL in the SQL in place of the column. This is ideal in the VALUES clause of an Insert transaction.
- Define input-dependent SQL or XQuery. With the input-dependent text highlighted, right-click and select Input-dependent Text. No dialog box should appear when doing this, and the SQL should change dynamically. This is ideal in UPDATE and WHERE clauses for Update and Delete transactions.
Information on how to define SQL/XQuery in conjunction with input-dependent text can be found in the "Defining input-dependent SQL or XQuery syntax" section of the Advanced Reporting Guide in the Product Manuals.
KB207490
