Virtual Tables filters using Dates

Wilton · Post by **Wilton** » Thu 20 Jul 2006 16:00

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.

Antaeus · Post by **Antaeus** » Fri 21 Jul 2006 10:59

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.

Wilton · Post by **Wilton** » Fri 01 Sep 2006 14:30

Sorry guys, but version 4.40.0.18 don't solved this problem.

Antaeus · Post by **Antaeus** » Sat 02 Sep 2006 07:34

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.