CODEWITHSUNDEEP
delphifiredacdbgrid
aravagli
aravagli

Reputation: 21

Delphi FireDac DB2 DBgrid Not in edit

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

Upvotes: 0

Views: 502

Answers (1)

aravagli
aravagli

Reputation: 21

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

Upvotes: 1

Related Questions