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