Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 2 of 2 total |
conversion error |
Mon, Mar 9 2009 2:45 PM | Permanent Link |
Michael Fullerton | I'm getting a conversion error when I try to do a locate with two date
fields and two datetime fields: ElevateDB Error #1011 An error occurred with the value 0000-00-00 00:00 (A conversion error occurred) I checked the values and none of them is null or otherwise odd (3/06/09,3/06/09 11:00:00 AM,3/06/09 11:30:00 AM,3/06/09). I saw a related thread on 9/14/08. But all variables used in the Locate are TDateTimes. In the table the date fields are date and not timestamp. |
Tue, Mar 10 2009 5:02 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Michael,
<< I'm getting a conversion error when I try to do a locate with two date fields and two datetime fields: ElevateDB Error #1011 An error occurred with the value 0000-00-00 00:00 (A conversion error occurred) I checked the values and none of them is null or otherwise odd (3/06/09,3/06/09 11:00:00 AM,3/06/09 11:30:00 AM,3/06/09). I saw a related thread on 9/14/08. But all variables used in the Locate are TDateTimes. In the table the date fields are date and not timestamp. >> Please send me an example of this and I'll take a look. I suspect that you're assigning something incorrectly, but I can't say for sure without running your code. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Thursday, May 23, 2024 at 03:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |