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
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