Add new data in the table

[sntk]

Hello!

I don't know hot to add new data in the table.
I use oraclesession1, oracledataset1,
oracle navigator, dbgrid1 and datasource1.

In the oraclenavigator don't appear the button +.
Could you possibly tell me how to solve this problem.

You can see which component i used in delphi.

Thank you

 

[Marco Kalter]

Perhaps this section from the User's Guide explains the problem?

Making a dataset updateable

To be able to update records, a dataset needs to know the 'rowid' of every retrieved record. A rowid is an internal Oracle structure that uniquely identifies a record in the database. As long as you do not include it in the query, the CanModify property of the dataset remains False. To make an updateable dept dataset, the SQL property would be: select dept.*, dept.rowid from dept

Furthermore, you should not use column aliases for the updateable table in the select statement of an updateable dataset. These alias names would be used in subsequent insert or updates to the updating table, and would therefore lead to an error.

If for some reason it is not possible to supply a rowid in the query, you can use the OnApplyRecord event to make the dataset updateable.