Page 1 of 1

What's the right way to use MYSQL DAC

Posted: Thu 26 Jan 2006 11:01
by 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

Posted: Thu 26 Jan 2006 15:13
by Ikar
It can happen because of DBGrid.Options.dgCancelOnExit set to True. Try to setting it to False to avoid this behaviour.