Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 2 of 2 total |
Locate a date on edbquery |
Thu, Apr 15 2010 12:46 PM | Permanent 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 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 |
This web page was last updated on Wednesday, May 15, 2024 at 08:40 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |