FUNDAMENTAL ORACLE PROBLEM

[gb]

Hi

Having previously used Delphi !! to access Oracle DB's. I am trying to get my head round ADO etc.

I am just creating a basic data input form using the form wizard to access an Oracle 7.3.3 db.

When I try to add/delete or anything other than browse I receive an error message saying that there is "insufficient base table information to do the actions".

I must admit this has me puzzled as I can do this ok when trying the same thing on SQL Server db. The dataset is being opened as dynamic and lock optimistic.

Sorry but I found Delphi much easier to use iro Data access ?!

Any help appreciated.

GB

[Clunietp]

Does the table that you are working with have a key column, or are you selecting the key column when specifying your SQL statement?

[gb]

Clunietp

The table doesn't have a key column - it is a very basic 5 field table - just to test with.

[Clunietp]

That's your problem. With ADO, you MUST have a key column when you do your updates/deletes