IBDataSet Inner Joins cause dataset to be read only?

[Chris1701]

I'm working on a project using Delphi 6 and Firebird 2. For one particular part of the program I need to edit data in an IBDataSet through a dbgrid and for the grid to be useful to the user and for it to be sorted into the correct order I have to use an Inner Join to get several fields from another table. The problem that I'm having is that after I write the SelectSql and go to the dataset editor the "Generate SQL" button is greyed out and of course none of the Update Sql / Delete Sql or Refresh Sql Code is there and so the dataset is read only.

Does the IBDataset component support editing of Sql query's that use joins and if so what is the proper way to get it to work?

If the answer to the above question is no, then how would I accomplish this?

Thanks,

 

[lespaul]

Do you have a primary key on the table? Is that key included in the fields of the query that you are trying to make updateable?

Leslie

Have you met Hardy Heron?

 

[Chris1701]

yes, both tables have primary keys and those keys are included in the SelectSQL statement as well as the field that is used to join the two tables together.