Forums

working with query tool and Jade ODBC to interigate a Greentree DB have been unable to figure out how to pass a date into the SQL where Clause
any Hints greatly appreciated

Try this:

WHERE SomeClass.someDate={d '2011-09-22'}

Hi, does anyone know how to pass a date parameter into an ODBC query. Using using MS Query "?" prompts for a parameter:
1. eg WHERE SomeClass.someDate= ?
Parameter={d '2011-09-22'} (Gives Jade ODBC error - invalid parameter type)

2. eg WHERE SomeClass.someDate= {d ?} - (Gives Jade ODBC server error -Expecting 'characterStringLiteral'; found '?')
3. eg WHERE SomeClass.someDate= {?} - (Gives Jade ODBC server error -Expecting 'o d b c date time value'; found '?')