Syntax and Parameters





Add()

object.Add item, key, before, after

where:

item is an expression of any type that specifies the member to add to the collection
key is a unique string expression that specifies a key string that can be used
before is an expression that specifies a relative position in the collection
after is an expression that specifies a relative position in the collection



AddNew()

AddNew





AppendChunk()

recordset.field.AppendChunk source

where:

recordset is an object variable that represents the Recordset object containing the Fields collection.
field is an object variable that represents the name of a Field object.
source is a String expression or variable containing the data that you want to append to the Field object specified by the field.



BatchUpdate()

object.BatchUpdate (singlerow, force)

where:

object is an object expression that evaluates to an object in the Applies To list.
singlerow is a Boolean value that is True if the update is done only for the current row, or False if the update applies to all rows in the batch. Default is False.
force is a Boolean value that is True if the row or batch of rows will overwrite existing rows in the database regardless of whether they cause collisions.



BeginTrans()

BeginTrans




Cancel()

Cancel





CancelBatch()

object.CancelBatch (singlerow)

where:

object is an object expression that evaluates to an object in the Applies To list.
singlerow is a Boolean value that is True if the cancel action is done only for the current row, or False if the cancel action applies to all rows in a batch.



CancelUpdate()

CancelUpdate





Close()

Close





ColumnSize()

varname = object.column.ColumnSize

where:

varname is the name of a Long or Variant variable.
object is an object expression that evaluates to the rdoResultset object containing the rdoColumns collection.
column is the name of an rdoColumn object whose ChunkRequired property is set to True.



CommitTrans()

CommitTrans





CreateQuery()

object.CreateQuery Name,SQLString

where:

object is an object expression that evaluates to an rdoConnection object.
name is a string expression that evaluates to the name for the new object.
SQLString is the SQL query for the new prepared statement.



Delete()

Delete





Edit()

Edit





EstablishConnection()

object.EstablishConnection prompt, readonly, options

where:

object is an object expression that evaluates to an rdoConnection object.
prompt is an integer value indicating the OBDC prompting characteristic.
readonly is a Boolean value that is True if you intend to use connection as read-only.
options is an integer value that indicates connection options.



Execute()

connection.Execute source [, options]

where:

connection is an object expression that evaluates to the rdoConnection object on which the query will run.
Query is an object expression that evaluates to the rdoQuery object whose SQL property setting specifies the SQL statement to execute.
Source is a string expression that contains the action query to execute or the name of an rdoQuery.
Options is a variant or constant that determines how the query is run. If set to rdAsyncEnable, executes operation asynchronously. If set to rdExecDirect, bypasses creation of a stored procedure to execute the query. Runs an action query or executes an SQL statement that does not return rows.



GetChunk

Set variable = recordset.field.GetChunk (offset, numbytes)

where:

variable is a String that receives the data from the Field object named by field.
recordset is an object variable that represents the Recordset object containing the Field collection.
field is an object variable that represents a Field object.
Offset is a long value equal to the number of bytes to skip before copying begins.
numbytes is a long value equal to the number of bytes you want to return.



GetClipString()

resultsetstring = object.GetClipString_
(numrows, [columndelimiter],_
[rowdelimiter], [Nullexpr]


where:

resultsetstring is a variable used to reference the entire result set as a delimited string.
object is an object expression that evaluates to an rdoResultset object.
numrows is the number of rows to copy into the clip string.
columndelimiter is a string expression used to separate data columns.
rowdelimiter string expression used to separate data rows, as described in Settings.
Nullexpr is a String expression used when NULL values are encountered.



GetRows()

array = object.GetRows(rows)

where:

array is the name of a Variant type variable to store the returned data.
object is an object expression that evaluates to an object in the Applies To list.
rows is a Long value indicating the number of rows to retrieve.



MoreResults()

MoreResults





Move()

object.Move rows[, start]

where:

object is an object expression that evaluates to an object in the Applies To list.
rows is a signed Long value that specifies the number of rows the position will move, as describe in Settings.
start is a variant value that identifies the bookmark, as described in Settings.



MoveFirst()

MoveFirst





MoveLast()

MoveLast





MoveNext()

MoveNext





MovePrevious()

MovePrevious





OpenConnection()

Set connection = environment.OpenConnection_
(dsName [,prompt[,readonly[,connect_
[,options]]]])


where:

connection is an object expression that evaluates to an rdoConnection object that you're opening.
environment is an object expression that evaluates to existing rdoEnvironment object.
dsName it is a string expression that is the name of the registered OBDC data source name.
prompt it is a variant or constant that determines how the operation is carried out.
readonly is a boolean value that is True if the connection is to be opened for read-only access, and False if the connection is to be opened for read/write access.
connect is a string expression used to pass arguments to the ODBC driver manager for opening the database.
options is a variant constant that determines how the operation is carried out.



OpenResultset()

Set variable = object.OpenResultset_
(name [,type[, locktype[, option]]])


where:

variable is an object expression that evaluates to an rdoResultset object.
object is an object expression that evaluates to an existing rdoQuery or rdoTable object that you want to use to create the new rdoResultset.
name is a string that specifies the source of the rows for the new rdoResultset.
type is a variant or constant that specifies the type of cursor to create.
locktype is a variant of constant that specifies the type of concurrency control.
option is a variant or constant that specifies characteristics of the new rdoResultset.



rdoCreateEnvironment()

Set variable = rdoCreateEnvironment_
(name,user,pswd)


where:

variable is an object expression that evaluates to an rdoEnvironment object
name is a String variable that uniquely names the new rdoEnvironment object.
user is a String parameter that identifies new owner of the rdoEnvironment object.
pswd is a String variable that contains the password for the new rdoEnvironment object.



rdoRegisterDataSource()

rdoRegisterDataSource DSN,_
driver, silent, attributes


where:

DSN is a string expression that is the name used in the OpenConnection() method that refers to a block of descriptive information about the data source.
driver is a string expression that is the name of the ODBC driver.
silent is a boolean value that is True if you don't want to display the ODBC driver dialog boxes that prompt for driver-specific information and False if you don't to display the ODBC driver dialog boxes.
attributes is a string expression that is a list of keywords to be added to the ODBC.INI file.



Refresh()

Refresh





Remove()

object.Remove index

where:

index is an expression that specifies the position of a member of the collection.



Requery()

object.Requery[options]

where:

object is the object placeholder represents an object expression that evaluates to an object in the Applies To list.
options is a Variant or constant that determines how the query is run; If set to rdAsyncEnable — execute operation asynchronously.



RollbackTrans()

RollbackTrans





Update()

Update