Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

problems on writing data in a oracle db via recordset

Status
Not open for further replies.

macl

Programmer
Joined
Sep 15, 2004
Messages
65
Location
DE
hi everybody i have a problem
i have a programme that gets data from a oracle database and also should write data into the database
now i get the datas with a recordset like that

GetData SQLUserData, adOpenForwardOnly, recData

function GetData()
'setting the recordset
Set GetData1 = New ADODB.Recordset

'execute the SQL-Query
GetData1.Open strSQL, conDB, strCursortype, adLockBatchOptimistic

Set rsOutput = GetData1
-----
The strSQL contains the sql-query
that works so far but if i want to write data into that recordset with

recData.Fields(4) = Date
recData.UpdateBatch
recData.Close

then i get this message:

"Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype"


does somebody know what is the problem here and how i can solve that?
thanks a real lot
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top