Error on deleting

[StephanM1]

Hi,
I open the database with standart DataEnvironment with lock type optimistic.

In my program I want to delete on records with:

DataEnvironment1.rsCommand1.Delete adAffectCurrent

and got these error:

Insufficient base table information for updating or refreshing

What setting is wrong !!!
By the way I use an oracle db with odbc.

regards

Stephan

[dfwade]

It many cases the Oracle OLEDB driver does not provide sufficient metadata with the recordset to allow a delete. Try including the primary key of the table in your select query, this will ususally fix the problem, even though you may not need it. Also try setting your CursorLocation to the server.


Yahoo Messenger ID dfWade10900