> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of John Christenhusz
> Sent: Tuesday, 10 October 2000 20:26
> To: Multiple recipients of list database
> Subject: [DUG-DB]: Paradox - Date
>
>
> G'day all,
>
> Can anybody tell me what the syntax is for the current date in a SQL for
> Paradox?
>
> Thus something like:
>
> select *
> from TABLE
> where FieldDate <= NOW
>
>
>
> However, NOW & DATE don't seem to work! What should it be?
There is no NOW or DATE functions in Local SQL. Use a parameterised query or
dynamically generated SQL.
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
