Please help me.
I used in Delphi DTPicker1(from data) and DTPicker2(to data).
This scrip is in VB6.0. How is equivalent scrip for DELPHI?
.SelectionFormula = "{PERSONAL.Data} In Date (" & Format$(dFrom.Value, "yyyy,mm,dd") & ") To Date (" & Format$(dTo.Value, "yyyy,mm,dd") & ") "
Many thanks!
Please how use BETWEEN in this script ?
1. DTPicker1 = from data
2. DTPicker2 = to data
/////////
procedure TForm3.Button3Click(Sender: TObject);
begin
With CRP1 do
begin connect := 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=dbase.mdb;Persist Security Info=False;Pwd='+ 'system'...
Please how use BETWEEN in this script ?
1. DTPicker1 = from data
2. DTPicker2 = to data
/////////
procedure TForm3.Button3Click(Sender: TObject);
begin
With CRP1 do
begin connect := 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=dbase.mdb;Persist Security Info=False;Pwd='+ 'system'...
All ok, i have solve
...
ADOQuery1.Active := False;
ADOQuery1.SQL.Text:='';
ADOQuery1.SQL.Text :='SELECT * FROM Total1 WHERE Data BETWEEN :First and :Second';
ADOQuery1.Parameters.ParamByName('First').DataType:= ftdate...
No, please , how extract one period from .mdb queries for report?
Ex. period DTPicker1 =01/01/2005 to DTPicker2= 05/07/2005.
How use BETWEEN in DELPHI?
Thanks
....
ADOQuery1.Close;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Text:='SELECT * FROM Total1 WHERE Data BETWEEN '+Quotedstr(datetostr(DTPicker1.Date))+ ' AND ' + Quotedstr(datetostr(DTPicker2.Date));
ADOQuery1.Prepared := True;
ADOQuery1.ExecSQL;
ADOQuery1.Open;
ADOQuery1.Active := False;
if...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.