CODEWITHSUNDEEP
delphilistboxdelphi-2007dbgrid
Amiru
Amiru

Reputation: 121

Delphi 2007 Unable to modify the data in beforescroll event using source code, Error: Dataset not in Edit or Insert Mode

A bit of History: I have a DBlistbox containing textt descriptions and I store just the codes of this in a mysql table which is displayed in a dbgrid. User can select multiple options and I like to process these and store as comma separated values in one of the columns (this column is invisible in the dbgrid).

Right now I can populate the listbox when the user scroll through the dbgrid using event Afterscroll and Formcreate. But when I try to process the list and update the myquery behind the dbrgid I get an error saying 'Dataset not in Edit or Insert mode' - I do this in beforescroll

Please help!! I have tried to set the dataset to edit mode before changing then as soon the data is posted dbgrid seems to have funny characters

Upvotes: 0

Views: 900

Answers (1)

Uwe Raabe
Uwe Raabe

Reputation: 47714

If I got you right, the DBListBox is not connected to the dataset lonked in the grid? This would explain why the grid's dataset is not set to edit mode when you change the data in the DBListBox.

Anyway, whenever you change data that has to go into the mysql table, you should switch this dataset into edit mode. Then you can place your coding of the comma separated values into the OnBeforePost event.

When the dataset scrolls without any change in the data of the listbox, there is no need to store any data. This is achieved with the above approach as without edit mode no BeforePost event will fire in this case.

Upvotes: 1

Related Questions