Hi All,

I am into constructing my data access classes for MySQL databases. I use the DE as sort of a datalayer class which houses my CursorAdapter subclasses.

Everything works fine. Except for this weird behaviour. So, here it is:

I have a parent-child form, the underlying tables are obtained from CAs "pointing" to MySQL tables.

So, record navigation (TOP, NEXT, PREV, BOTTOM) moves the parent table to the appropriate records, which causes the child CA to do a Requery. The child CA records are in a grid.

I put code in the DblClick to pop up a form which shows the selected child record data.

This is where the weird behaviour happens: the "FIRST" dblclick will always have the "TOP" record pop out in the child form! Succeeding double clicks will only then show the correct record!

I then put code in BeforeRowColChange and AfterRowColChange to track it... it really
GOES to top in the first doubleclick!

Help! Thanks too for any help given!

I am stumped at this for days.

Dennis