Hi,

I have tried many different ways but is still not able to extract the
data by date range.. >.<

What should I need to define in the Dictionary and what SQL syntax
should I use?

Many Thx.

Rgds,

SQL-CREATE-TABLE test order.date=DATE

SELECT * FROM test WHERE order.date >= #01/01/06# and order.date <=
#03/01/06#

IIRC, the syntax #date# internalizes the date whereas "date" does a string
compare

Make sure the D3 dictionary has a D conversion in attr 7, not attr 8.

The D3 SQL engine should internalize date comparisons (pick internal, not
windows).

You can test by running D3ODBCSV in a foreground window. (D3ODBCSRV for
*nix)
You should see the SQL query and see just what's being passed as a
parameter.

Mark Brown

"skypirate" <singdad (AT) singdad (DOT) no-ip.com> wrote

I am not sure what you are using by WinSQL is an excellent tool for
testing SQL statements with D3