ADOxtra for Macromedia Shockwave Multiuser Server

Query object settings

XtraCommand = "Query: Name"
This command creates a new Query object with the specified name.

AccessMode

XtraCommand = "AccessMode: Normal"
Normal mode allows the data source to be used from both client side and server side.
Note: DataSource object's access mode has also be defined as Normal to allow this query to be used from client side.

XtraCommand = "AccessMode: Limit to server-side"
Secured mode allows to use this data source from server side only.

UseSQL

XtraCommand = "UseSQL: Any"
Non-secured mode allows any SQL to be used by MUS client. In this mode MUS client may specify an SQL as a param to System.ADO.GetData message.

XtraCommand = "UseSQL: Predefined"
Secured mode does not allow using other SQL than this object is configured with.

ADO.SQL

XtraCommand = "ADO.SQL: SELECT * FROM SomeTable WHERE ParentId=<%ParentId%>"
identifies a particular SQL query to be executed upon the data source linked to this query.
Note: use _QUOTE_ if you need to place a quote character inside the connection string definition.
QueryParamStart and QueryParamEnd xtra-level settings define the syntax for parameterized queries. If the query contains parameters, ADOxtra will try to replace them with actual values during run-time.

ADO.CursorType

XtraCommand = "ADO.CursorType: adOpenStatic"
XtraCommand = "ADO.CursorType: adOpenDynamic"
XtraCommand = "ADO.CursorType: adOpenForwardOnly"
XtraCommand = "ADO.CursorType: adOpenKeyset"
Identifies the type of the cursor to be used by default by this query.

ADO.CursorLocation

XtraCommand = "ADO.CursorLocation: adUseClient"
This setting identifies the cursor location to be used by this query. Using client cursor allows caching data by ADO and do not ask the database for every move within the data.
This is a common ADO settings, it has nothing in common with MUS clients.

XtraCommand = "ADO.CursorLocation: adUseServer"
This setting identifies the cursor location to be used by this query. Using server cursor allows keeping data in sync with changes made by other users.
This is a common ADO settings, it has nothing in common with MUS server or clients.

ADO.LockType

XtraCommand = "ADO.LockType: adLockReadOnly"
XtraCommand = "ADO.LockType: adLockPessimistic"
XtraCommand = "ADO.LockType: adLockOptimistic"
Identifies the type of locking to be used by this query.

ADO.CacheSize

XtraCommand = "ADO.CacheSize: 10"
Identifies the size of cache to be used by this query.

ADO.Open

XtraCommand = "ADO.Open"
This command tells ADOxtra to open the recordset in the configuration time (right after detecting this command).
Note: ADO will not allow changing the source SQL string and some other settings if the recordset object is opened.