🚀 go-pugleaf

Hi Paul.

Use the Params property of the TQuery component, like this:

Start by setting the SQL statement to:

'SELECT * FROM AIRCRAFT WHERE TYPE=:Type'

This will create a parameter in the Params list named 'Type'.
Change the type of the parameter to date and use the following statement to
set the value before executing the query:

Query.Params.ParamByName('Type').AsDateTime := Now

or

Query.Params.ParamByName('Type').AsString := '01/01/99'

This way, the conversion to the actual date format required by the SQL
server is done by BDE. All you have to care about is setting the
value of the parameter.

Hope that helps.

Regards,
Torsten Seemann





Paul Day <paul@pday.freeserve.net.uk> wrote in message
news:7cjnlk$7b9$1@news5.svr.pol.co.uk...
>Hi
>I am using buttonclick events to set the SQL property of a Query object at
>run time. This will display the records I require depending on the
>parameters of the statement.
>I have no problem with say :
>
>Query1.SQL.Add ('SELECT * FROM aircraft where type=Sea king');
>
>aircraft being my record table and type being one of the fields.
>
>However... another of the fields in the table is a date field, and I need
to
>display records in response to the user typing in a date in an Edit box and
>use this date as the WHERE. ie
>
>Query1.SQL.Add ('SELECT * FROM aircraft WHERE built =  Edit1.Text');
>
>This of course does not work but neither does anything I Try....Can anyone
>help,
>I must be mixing things up and missing a simple point..
>Im using Delpi2.
>
>Paul
>
>
>
>
>
>
>
>