Query Date Type

[Leonardo Almeida]

Hi,

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.Close ;
ADOQuery1.SQL.C lear;
ADOQuery1.SQL.A dd('Select * from Apro where data between Inicio and
Final');

ADOQuery1.Param eters[0].Value:=Inicio;
ADOQuery1.Param eters[2].Value:=Final;

ADOQuery1.Open;

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.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Shervin Shapourian]

Leonardo,

There are two problems in your code:

1. Parameters should start with a colon. (e.g. :Inicio and :Final)
2. You have used Parameters[0] and Parameters[2], what about Parameters[1]!?

So this is the correct code:

with ADOQuery1 do
begin
Close;
SQL.Text := 'Select * from Apro where data between Inicio and Final';
Parameters[0].Value := Inicio;
Parameters[1].Value := Final;
Open;
end;

Good luck,
Shervin
"Leonardo Almeida" <lf******@yahoo .com> wrote in message
news:3f******** *************@n ews.frii.net...

Hi,

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.Close ;
ADOQuery1.SQL.C lear;
ADOQuery1.SQL.A dd('Select * from Apro where data between Inicio and
Final');

ADOQuery1.Param eters[0].Value:=Inicio;
ADOQuery1.Param eters[2].Value:=Final;

ADOQuery1.Open;

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.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Shervin Shapourian]

Oops! Sorry I forgot to add colons before parameters :-) This is the correct
code:

with ADOQuery1 do
begin
Close;
SQL.Text := 'select * from Apro where data between :Inicio and :Final';
Parameters[0].Value := Inicio;
Parameters[1].Value := Final;
Open;
end;

Shervin

"Shervin Shapourian" <Sh**********@h otmail.com> wrote in message
news:vo******** ****@corp.super news.com...

Leonardo,

There are two problems in your code:

1. Parameters should start with a colon. (e.g. :Inicio and :Final)
2. You have used Parameters[0] and Parameters[2], what about Parameters[1]!?
So this is the correct code:

with ADOQuery1 do
begin
Close;
SQL.Text := 'Select * from Apro where data between Inicio and Final';
Parameters[0].Value := Inicio;
Parameters[1].Value := Final;
Open;
end;

Good luck,
Shervin
"Leonardo Almeida" <lf******@yahoo .com> wrote in message
news:3f******** *************@n ews.frii.net...

Hi,

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.Close ;
ADOQuery1.SQL.C lear;
ADOQuery1.SQL.A dd('Select * from Apro where data between Inicio and
Final');

ADOQuery1.Param eters[0].Value:=Inicio;
ADOQuery1.Param eters[2].Value:=Final;

ADOQuery1.Open;

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.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Erland Sommarskog]

Shervin Shapourian (Sh**********@h otmail.com) writes:

1. Parameters should start with a colon. (e.g. :Inicio and :Final)
2. You have used Parameters[0] and Parameters[2], what about
Parameters[1]!?

So this is the correct code:

with ADOQuery1 do
begin
Close;
SQL.Text := 'Select * from Apro where data between Inicio and Final';
Parameters[0].Value := Inicio;
Parameters[1].Value := Final;
Open;
end;

Shervin, did you not for get the colons?

Select * from Apro where data between :Inicio and :Final

--
Erland Sommarskog, SQL Server MVP, so****@algonet. se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[Shervin Shapourian]

You are right, I forgot them. I fixed it.
Thanks Erland.

Shervin

"Erland Sommarskog" <so****@algonet .se> wrote in message
news:Xn******** **************@ 127.0.0.1...

Shervin Shapourian (Sh**********@h otmail.com) writes:

1. Parameters should start with a colon. (e.g. :Inicio and :Final)
2. You have used Parameters[0] and Parameters[2], what about
Parameters[1]!?

So this is the correct code:

with ADOQuery1 do
begin
Close;
SQL.Text := 'Select * from Apro where data between Inicio and Final';
Parameters[0].Value := Inicio;
Parameters[1].Value := Final;
Open;
end;

Shervin, did you not for get the colons?

Select * from Apro where data between :Inicio and :Final

--
Erland Sommarskog, SQL Server MVP, so****@algonet. se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp