Login
Products
Sales
Support
Downloads
About
Home
»
Technical Support
»
ElevateDB Technical Support
»
Support Forums
»
ElevateDB SQL
»
View Thread
View Thread
The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Select and Date
Thu, Dec 25 2008 4:28 AM
Permanent Link
Dieter Nagy
I wish all of you a merry christmas and a happy new year.
In EDB Manager works this perfect:
select * from Kontobuchungen where valutadatum <= cast('2008-01-01' as date)
When I try this in code:
......
memo1.Lines.Add('AND (Valutadatum =' +quotedstr('2008-01-01')+')');
Then I get "Expected Date expression but found '2008-01-01'.....
Please help me
Tahnks
Dieter
Thu, Dec 25 2008 10:09 AM
Permanent Link
Roy Lambert
NLH Associates
Team Elevate
Dieter
>memo1.Lines.Add('AND (Valutadatum =' DATE +quotedstr('2008-01-01')+')');
Roy Lambert [Team Elevate]