Query Designer

rbuser

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

nicocizik

Hi Steve,

Unfortunately the Query Designer does not support the use of built-in
functions in the search condition. One option would be to edit the SQL
manually.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com