Topic: Need Help
Hi friends,
I am facing a problem. Any one who guide me? Problem is:
I have made a project. Suppose it has a form1, a editbox two date time pickers and a table name Sale having svalue currency field, a date sdate field and a item text field. I want to get svalue on editbox. I use this statement which works very will
procedure form1_OnShow (Sender: TObject; Action: string);
begin
form1.edit1.Text:= SQLExecute('Select Sum(svalue) from Sale');
end;
but I want to get svalue for specific period or date. How can I write statement which will give my required result.
Thank in advance.