General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi J :o)
I tried the following as you suggested:
I added the below line in the oConnect [(oConnect = CREATEOBJECT("adodb.connection")] object.
.CursorLocation = adUseClient
Then I retrieve a RecordSet using oCommand [oCommand = CREATEOBJECT("adodb.command")] object.
WITH oCommand
.CommandType = adStoredProc
.CommandText = "Get_All_Open_Invoices"
.ActiveConnection = oConnection
ENDWITH
oRecordSet = oCommand.Execute
When do the following I get "the operation is not supported by the Provider" type message.
oRecordSet.AddNew <-- this crashes
However, when I retrieve a RecordSet using the RecordSet object, the oRecordSet.AddNew works?
What am I missing?
Thanks,
Mal
>Set client side recordset property of connection object (CursorLocation). You also want to read the docs on the way you can combine your options for recordset types. For example, you cannot have a dynamic client side recordset. HTH
>>Hi all:
>>
>>ADO (using OLE DB) from SQL SERVER 7.0 is what I'm trying to implement.
>>
>>I can't seem to get a client side cursor when using the ADO COMMAND object to get a RECORDSET via STORED PROCEDURES. Is the combination of COMMAND Object/STORED PROCEDURES to retrieve a RECORDSET always read only or is there something I'm missing?
>>
>>Thanks in advance,
>>
>>Mal
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only