DatasheetElement.updateCustomQueryInfo (Method)
Updates the information about a custom query datasheet view.
Returns:
Void
Arguments:
Name | Type | Required | Description |
---|---|---|---|
pageID | RealPageID_NonBaseTemplate | Required | A page's ID. |
elementID | DatasheetElementInstanceID | Required | The datasheet element's control ID. |
viewName | PlainText_NonNull | Required | The view's name. |
datasourceName | PlainText_NonNull | Required | The name of an existing ColdFusion data source. |
sqlQuery | ValidSQLSelectStatement | Required | The SQL query that CommonSpot will run when it generates a datasheet. |
username | PlainText | Optional. Defaults to an empty string. | A database user name. |
password | PlainText_Secure | Optional. Defaults to an empty string. | The password associated with the 'username' argument. |
Context:
License Requirements | Datasheet |
Permission Requirements | element:Author |
Deny Context | None |
Require Context | AuthoringEnabled |
Author Lock | (not required) |
Transaction Logging | If transaction logging is enabled at the site level, calls to this method will be logged |
Customization | This method may be customized at the site level |
Error Codes:
None
Notes:
None