-
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
-
Does the table that you are working with have a key column, or are you selecting the key column when specifying your SQL statement?
-
Clunietp
The table doesn't have a key column - it is a very basic 5 field table - just to test with.
-
That's your problem. With ADO, you MUST have a key column when you do your updates/deletes
