What's the right way to use MYSQL DAC

[mierlp]

hi,

Something i'm doin wrong....

There's a MYSQL database and 1 table. On the form i put a :
- MyConnection,
- MyQuery
- MyTable
- dsDataset
- Standaard DBGrid
- Standaard DBEDit
- Standaard DBNavigator

Everything is connected...i think on the right way because
i can see the data an can CHANGE data. Appending a new
record creates in the DBGrid a new line. When i click in the
DBEDit the row will be ''deleted'' and i can't add new records.

Greetz PEter

[Ikar]

It can happen because of DBGrid.Options.dgCancelOnExit set to True. Try to setting it to False to avoid this behaviour.