procedure TForm1.Edit2Change(Sender: TObject); var d:string; no,i:integer; s,tj:string; begin tj:=edit1.text+'-'+edit6.text; edit5.Text:=tj; i:=strtoint(form1.Edit2.text); with ADOQuery1 do begin close; sql.Clear; s:='select * from itemactivity where lngReceiptNO=:no and lngActivityTypeID=11 and strDate like "'+tj+'%"'; ---------------------------------------------- sql.Add(s);
try open; except execsql; end; if ADOQuery1.RecordCount=0 then begin form1.DateTimePicker2.Datetime:=date; form1.DateTimePicker3.Datetime:=form1.DateTimePicker2.Datetime end else begin form1.DateTimePicker2.Datetime:=form1.ADOQuery1.FieldByName('strReceiptDate').AsDateTime; form1.DateTimePicker3.Datetime:=form1.ADOQuery1.FieldByName('strDueDate').AsDateTime; end end;------------------------------------
----------------------------------------------
-