Query1.Close;
Query1.SQL.Clear;
Query1.SQL.Add('Select * ');
Query1.SQL.Add('From "DATA.DB" ');
Query1.SQL.Add('Where 주민번호 LIKE :sYearCode ');
Query1.SQL.Add('And 학력 LIKE :sScholarship ');
Query1.SQL.Add('And 자격증 LIKE :sLicense ');
Query1.SQL.Add('And 전공 LIKE :sMajor');
Query1.ParamByName('sYearCode').AsString := lbl1.Caption;
Query1.ParamByName('sScholarship').AsString := lbl2.Caption;
Query1.ParamByName('sLicense').AsString := lbl3.Caption; ;
Query1.ParamByName('sMajor').AsString := lbl4.Caption; ;
Query1.SQL.Add('Order By 성명;');
Query1.Open;
|