Delphi FireDac DB2 DBgrid Not in edit

Question

I'm migrating an old project from Delphi XE2 with BDE to Delphi 10 Seattle with Firedac. The database is IBM DB2 10.5. After converting the source with refind.exe it correctly reset me query, database, etc. with Firedac But I can't edit a query with cached updates in a dbgrid. To simplify and verify I made a very simple project with FDConnection, FDQuery, FDUpdateSQL, DBGrid but I don't want to edit the grid. Checked in the grid the various readOnly false, option dgEditing true, dgMultiselect false; in FDQuery.updateOption.enableUpdate a true but no edit

Then I simplified again leaving only the FDConnection, an FDTable and the DBGrid: in this case too I can't edit the grid (readOnly false, dgEditing true, dgMultiselect false)

Any suggestions? Thanks in advance

Have you tried examining the individual fields in the IDE Fields editor to see if they are marked readonly? — MartynA
– MartynA, Commented May 11, 2020 at 16:06
I don't add persistent fields to my FDtable and the table is certainly not readOnly — aravagli
– aravagli, Commented May 11, 2020 at 16:38
I tried a sample application with FDConnection, FDTable, Datasource, DBGrid and a DBNavigator. — aravagli
– aravagli, Commented May 11, 2020 at 17:21
When I push the edit button on the navigator the FDTabe state turns to edit mode but I cannot write on fields in DBGrid — aravagli
– aravagli, Commented May 11, 2020 at 17:23
Well if you add a TDBEdit to your form and set it to access one on the fields in your grid, can you edit the field's contents in the DBEdit, yes or no? — MartynA
– MartynA, Commented May 11, 2020 at 17:32

aravagli · Accepted Answer · 2020-05-12 15:47:16Z

1

Fixed: the problem was in FDTable1.updateOptions: the value of CheckReadOnly = true prevented the update

answered May 12, 2020 at 15:47

aravagli

211 silver badge1 bronze badge

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Delphi FireDac DB2 DBgrid Not in edit

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related