| |
rdoParameters
The rdoParameters collection provides information only about marked parameters in an rdoQuery object or stored procedure. You can't append objects to or delete objects from the rdoParameters collection.
When the rdoParameters collection is first referenced, RDO and the ODBC interface parse the query, searching for parameter markers — the question mark (?). For each marker found, RDO creates an rdoParameter object that places it in the rdoParameters collection. However, if the query cannot be compiled or otherwise processed, the rdoParameters collection isn't created and your code will trigger a trappable error indicating that the error doesn't exist. In this case, check the query for improper syntax, permissions or underlying objects, the proper placement of parameter markers.
rdoParameters Object Properties
| Property |
Description |
| Item |
Returns a specific member of an RDO collection object, either by position or by key. |
| Count |
Returns the number of objects in a collection. |
rdoParameter
When you work with stored procedures or SQL queries that require use of arguments that change from execution to execution, you should create an rdoQuery object to manage the query and its parameters. For example, if you submit a query that includes information provided by the user, such as a date range or part number, RDO and ODBC interface can insert these values into the SQL statement automatically at specific positions in the query. The rdoParameter object supports just one method, AppendChunk(), which appends data from a Variant expression to an rdoColumn object with a data type of rdTypeLONGVARBINARY or rdTypeLONGVARCHAR. The AppendChunk() method has the following syntax:
object column.AppendChunk source
The object parameter is an object expression that evaluates to the rdoResultset object containing the rdoColumns collection. column is an object expression that evaluates to an rdoColumn object whose ChunkRequired property is set to True. The source parameter is a string expression or variable containing the data that you want to append to the rdoColumn object specified by column.
rdoParameter Object Properties
| Property |
Description |
| Direction |
Returns or set a value indicating how a parameter is passed to or from a procedure. If set to rdParamInput — the parameter is used to pass information to the procedure. If set to rdParamInputOutput — the parameter is used to pass information both to and from the procedure.. If set to rdParamOutput — the parameter is used to return information from the procedure as output parameter in SQL. If set to rdParamReturnValue — the parameter is used to return the return status value from a procedure. |
| Name |
Returns the name of a RemoteData object. |
| Type |
Returns or sets a value that indicates the type or data type of an object. |
| Value |
Returns or sets the value of an object. |
rdoPreparedStatement
An rdoPreparedStatement object is a prepared query definition.
rdoPreparedStatement Object Properties
| Property |
Description |
| BindThreshold |
Returns or sets a value specifying the largest column that will be automatically bound under ODBC. |
| Connect |
Returns or sets a value that proides information about the source of an open rdoConnection. The Connect property contains the ODBC connect string. This property is always readable, but can't be changed after the connection is established. |
| ErrorThreshold |
Returns or sets a value that determines the severity level that constitutes a fatal error. |
| HStmt |
Returns a value corresponding to the ODBC statement handle. |
| KeysetSize |
Returns a set of value indicating the number of rows in the keyset buffer. |
| LockType |
Returns a sets of Long integer value indicating the type of concurrency handling. |
| LogMessages |
Enables ODBC trace logging and returns or sets a value that indicates the path of the ODBC trace file that was created by the ODBC Driver Manager to record all ODBC operations. |
| MaxRows |
Returns or sets a value indicating the maximum number of rows to be returned from a query or processed in an action query. |
| Name |
Returns the name of a RemoteData object. |
| QueryTimeout |
Returns or sets a value that specifies the number of seconds the ODBC Driver Manager waits before a timeout error occurs when a query is executed. |
| RowsAffected |
Returns the number of rows affected by the most recently invoked Execute() method. |
| RowsetSize |
Returns or sets a value that determines the number of rows in an rdoResultset cursor. |
| SQL |
Returns or sets the SQL statement that defines the query executed by an rdoQuery. |
| StillExecuting |
Returns a boolean value that indicates whether a query is still executing. |
| Type |
Returns or sets a value that indicates the type or data type of an object. |
| Updatable |
Returns a boolean value that indicates whether changes can be made to a remote data object. |
rdoPreparedStatement Object Method
| Method |
Description |
| Cancel() |
Cancels the processing of a query running in asynchronous mode, or cancels any pending result against the specified RDO object. |
| Close() |
Closes an open remote data object. |
| Execute() |
Runs an action query or executes an SQL statement that doesn't return rows. |
| OpenResultset() |
Creates a new rdoResultset object. |
rdoPreparedStatement
An rdoPreparedStatements collection contains all the rdoPreparedStatement objects in an rdoConnection.
rdoPreparedStatements Object Properties
| Property |
Description |
| Item |
Returns a specific member of an RDO collection object, either by position or by key. |
| Count |
Returns the number of objects in a collection. |
Copyright� 2000 by Noel
|