Could you paste your VB code? Maybe I could help you with that.... I think the statement is rather ok.
Marcin Pytel
The code is:
Private oAdoRec As Recordset
...
Set oAdoRec = New Recordset
oAdoRec.Open sSQL, oMain.ADO.ADOConnection, adOpenStatic, adLockOptimistic, adCmdText
I'll have a look at it with our 'chief programmer' because the open code line comes from her. We only use SELECT with that code. UPDATE and DELETE is done by a completely other class and via oMain.ADO.ADOConnection.Execute sSQL, lRowsAffected
(oMain.ADO.ADOConnection is of type Connection)
So I didn't look at the code above.
Thanks for your advice! :-)
Kind regards,
Benjamin Lukner trinomix GmbH
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
