var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Query Date Type - Somebody help me!p
I have a table with the follow fields :
ID - Int
Date - Datetime
I need to make a simple query to result the records between to dates with a single ID.
Ex.: Get the records between 01/08/2003 to 30/08/2003 only from ID=230
I´m using the follow :
ADOQuery1.SQL.Add('Select * from Apro where data between Inicio and Final');
When I open the query it doesn´t work cos it´s result a null set
How can I solve this?
I´m using SQL Server 2000 and Delphi 6
Thanks for atention.
where u have
Select * from Apro where data between Inicio and Final
should data be date ?? --> Date - Datetime
or u did that on purpose
Can u output the record source that is being executed ?