Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Locate a date on edbquery
Thu, Apr 15 2010 12:46 PMPermanent Link

Hershcu Sorin

Hello

I try to find a specific date on a dateField on an open edbquery and I use.

DateVar: Variant;
MyQuery.Locate('DateField', DateVar, [])

This raise a conversion error.
I try to change the DateVar to string or to TDate but it's still raise an
error.

What I'm missing here?
Thanks
Sorin

Sat, Apr 17 2010 6:35 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Sorin,

<< I try to find a specific date on a dateField on an open edbquery and I
use.

DateVar: Variant;
MyQuery.Locate('DateField', DateVar, [])

This raise a conversion error.
I try to change the DateVar to string or to TDate but it's still raise an
error. >>

Declare the variable as TDateTime and that should work (provided that the
column that you're searching on is a DATE, TIME, or TIMESTAMP column).

--
Tim Young
Elevate Software
www.elevatesoft.com
Image