Page 1 of 1
MyDAC 4.00.1.5 : Bug when calling DefsFields.Update
Posted: Thu 13 Oct 2005 14:43
by swierzbicki
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
Posted: Thu 13 Oct 2005 22:16
by GEswin
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.
Posted: Fri 14 Oct 2005 07:56
by GEswin
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.
Posted: Fri 14 Oct 2005 08:53
by Ikar
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.
Posted: Fri 14 Oct 2005 09:14
by GEswin
Hi, I sended you a small sample.