MySQL Forums
Forum List  »  Newbie

SQL Clause
Posted by: Jim Sawyer
Date: August 14, 2016 09:47AM

I have the following

procedure Form1.FormShow( Sender: TObject );
var
dDate: TDateTime;
begin
dDate := StartOfAYear( YearOf( Date ) );
with qRecords do
begin
SQL.Clear;
SQL.Add( 'Select * from Records where RecDate >= dDate' );
Open;
end;

How can I modify the SQL clause to make it work?

Thanks,
Jim Sawyer

Options: ReplyQuote


Subject
Written By
Posted
SQL Clause
August 14, 2016 09:47AM
August 14, 2016 12:09PM
August 15, 2016 06:04AM
August 15, 2016 09:32AM
August 14, 2016 06:54PM
August 15, 2016 06:06AM
August 15, 2016 09:33AM
August 15, 2016 12:41PM
August 15, 2016 12:55PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.