Page 1 of 1

Virtual Tables filters using Dates

Posted: Thu 20 Jul 2006 16:00
by Wilton
Hi,

After install MyDac Version 4.30.1.17 (07.07.06)
all Virtual Tables using filter with date fields don't running.

Above a sample line of code thats running in Version 4.30.1.15
without problems.

Code: Select all

  VTbsp.Filter := 'dtbsp = '+QuotedStr(FormatDateTime('yyyy-mm-dd',StrToDate(CBbsp.Items.Strings[CBbsp.ItemIndex])));
  VTbsp.Filtered :=True;
Could you help me.

Posted: Fri 21 Jul 2006 10:59
by Antaeus
Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next MyDAC build. As a temporary solution we recommend you to use local system date format in the Filter expression of TVirtualTable component.

Posted: Fri 01 Sep 2006 14:30
by Wilton
Sorry guys, but version 4.40.0.18 don't solved this problem.

Posted: Sat 02 Sep 2006 07:34
by Antaeus
Try to reinstall MyDAC once more and test this issue. If the problem persists then send us a complete small sample to reproduce the problem including script to create and fill table.