MyDAC 4.00.1.5 : Bug when calling DefsFields.Update

swierzbicki · Post by **swierzbicki** » Thu 13 Oct 2005 14:43

MyQuery doesn't display anymore records when calling the FieldDefs Update method *Before* opening the dataset :

Just put a Dataset.FieldDefs.update in the OnBeforeOpen event and try to open your dataset

GEswin · Post by **GEswin** » Thu 13 Oct 2005 22:16

I found the same bug and had to roll back version. I made some investigation, i attached DBMonitor, and after doing this:

Code: Select all

 // MyQuery1.SQL -> SELECT cmcwin.conductos.* FROM cmcwin.conductos
 MyQuery1.FieldDefs.Update;
 MyQuery1.Open;

SQL at monitor is showed like:

Code: Select all

SELECT cmcwin.conductos.* FROM cmcwin.conductos
 SELECT cmcwin.conductos.* FROM cmcwin.conductos LIMIT 0

That's why there are no records show.

GEswin · Post by **GEswin** » Fri 14 Oct 2005 07:56

To add some info, when calling Fielddefs.Update, the query is not show in DBMonitor, it's strange then that when i open query i get two select statments.

Ikar · Post by **Ikar** » Fri 14 Oct 2005 08:53

We have reproduced and fixed problem with LIMIT 0, but we can't reproduce problem with DBMonitor. Please describe more detailed steps needed to reproduce it.

GEswin · Post by **GEswin** » Fri 14 Oct 2005 09:14

Hi, I sended you a small sample.