티나 님이 쓰신 글 :
: procedure TfrmOpen.btnViewReportClick(Sender: TObject);
: var
: strQuery : string;
: startDate, endDate : TDateTime;
: begin
:
: strQuery := 'Select * From weight' + #13 +
: 'Where DateTime > :pStartDateTime' and DateTime < :pEndDateTime';
:
: startDate := StrToDateTime(datetostr(dtpStartDate.Date)+ ' '+ cbStartTime.Text + ':00:00');
: EndDate := StrToDateTime(datetostr(dtpEndDate.Date)+ ' '+ cbEndTime.Text + ':00:00');
: with dm.adoQuery do begin
: sql.Clear;
: // sql.Text := strQuery;
sql.Add('Select * From weight');
sql.Add('Where DateTime > :pStartDateTime' and DateTime < :pEndDateTime');
Parameters.ParseSQL(SQL.Text, True);
: Parameters.ParamByName('pStartDateTime').Value := startDate;
: Parameters.ParamByName('pEndDateTime').Value := endDate;
: end;
:
: 위 소스가 'pStartDateTime' /'pEndDateTime' 파라미터를 찾을수 없다고 나오네여
: 제발 좀 갈켜주세요
|