Devart Forums

Hi,

I'm having trouble specifying a time in a filter correctly.

e.g. UniQuery1.Filter := 'STARTTIME = ''06.45.00''';

returns no records although there are some which start at that time and will appear if you clear the filter.

What is the correct syntax for times and what operators can I use with times in filters please?

Regards, Paul.

paul,

if STARTTIME is of type TIME, then I think you should be using ":" separator between hours, minutes, and seconds, e.g. STARTTIME = "06:45:00"

joe

Hi,

The fields are declared as type time(7) on the server and the delphi persistent fields are TTimeFields.

I had used ":" previously and just tried the "." to see if it would happen to work. I hadn't noticed that I had posted the later code containing the "."

Neither syntax seems to work anyway but thanks for your suggestion.

Regards, Paul.

You should use the same format as the TimeToStr function returns:

'6:45:00'

Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next UniDAC build.

Hi Plash,

Thanks but I tried that first. I've also tried dropping the leading zero but it still shows no records.

I'm sure there is a problem somewhere.

All other types of fields work for filtering, it's just times that are not working.

Any other suggestions please?

Regards, Paul.