Why does this work:

SELECT * FROM Sales
WHERE (dateEntered >= DATE {dateFrom='2017-01-09'}) AND (dateEntered <= DATE {dateTo='2017-01-09'})
ORDER BY salesNumber DESC


But, the following does not?

SELECT * FROM Sales
WHERE (dateEntered >= DATE {dateEnteredFrom}) AND (dateEntered <= DATE {dateEnteredTo})
ORDER BY salesNumber DESC

Isn't the DefaultValue optional?

What do you mean by "work" and "does not" ?  Is this at run-time or design-time in the Database Manager ?

Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:
<< What do you mean by "work" and "does not" ?  Is this at run-time or design-time in the Database Manager ?>>

"work" and "does not" means I get an error message when I try to Preview in the 'Editing dsName DataSet' window. And, if I drop a dataset from the Database Manager onto a form an error message appears alerting me to an error in the SQL.

Design-time. This has always been the case hence I am in the habit of populating the DefaultValue with a random 'never to be used' value as in this example.

<< "work" and "does not" means I get an error message when I try to Preview in the 'Editing dsName DataSet' window. And, if I drop a dataset from the Database Manager onto a form an error message appears alerting me to an error in the SQL.

Design-time. This has always been the case hence I am in the habit of populating the DefaultValue with a random 'never to be used' value as in this example. >>

This has already been fixed for 2.06 - EWB now uses a NULL parameter to eliminate these issues.

Tim Young
Elevate Software
www.elevatesoft.com