Home DADE

Query Designer

edited November 2006 in DADE
Hi!

I feel stupid asking this question because I'm pretty sure my problem it's
quite easy to solve ;-)

I use the query designer connected to a MS-SQL database through the BDE. I
need to build a query which the WHERE clause uses the GetDate() function of
MS-SQL (GetDate() returns the current date).

SELECT * FROM MyTableWHERE MyTable.MyDate = GetDate()

When I try to insert a Search criteria with GetDate() in it, the Designer
doesn't seem to accept it (it is not shown under the SQL tab; the WHERE
clause in incomplete).

I managed to work around this problem setting an AutoSearchCriteria by code
under the Calc tab but i'm sure there is a better solution to my problem.

Any hint ?

Thanks!

Steve

Comments

This discussion has been closed.