code=Delphi(Pascal)] strsql:='Select ID,转出社区 From ZL_双向转诊转出单 Where 个人档案ID="'+grdah+'" And 状态="申请" And 申请时间=(Select Max(申请时间) From ZL_双向转诊转出单 Where 个人档案ID="'+grdah+'" And 状态="申请")'; try {dm.ExecSql(strsql,errmsg); m_strout:=m_strout+dm.QrySvr.Fields[0].AsString+'|';} dm.ExecSql(strsql,errmsg); if not dm.QrySvr.IsEmpty then begin m_zzid:=dm.QrySvr.Fields[0].AsString; m_zcsq:=dm.QrySvr.Fields[1].AsString; result:=0; end else result:=1;[[/code] 帖上一段代码
參考一下: procedure TRes_HrCq_YD_F.GetoldYDCB; begin cbb_cb.Properties.Items.Clear; cbb_cb.Text:=''; cbb_cb.Properties.Items.Clear; qry_getoppo.Close; qry_getoppo.SQL.Clear; qry_getoppo.SQL.Add( ' select CB from Res_User_Temp where CB is not null group by CB '); qry_getoppo.Open; while not qry_getoppo.Eof do begin cbb_cb.Properties.Items.Add(Trim(qry_getoppo.fieldbyname('CB').AsString)); qry_getoppo.Next; end; end;
strsql:='Select ID,转出社区 From ZL_双向转诊转出单 Where 个人档案ID="'+grdah+'" And 状态="申请" And 申请时间=(Select Max(申请时间) From ZL_双向转诊转出单 Where 个人档案ID="'+grdah+'" And 状态="申请")';
try
{dm.ExecSql(strsql,errmsg);
m_strout:=m_strout+dm.QrySvr.Fields[0].AsString+'|';}
dm.ExecSql(strsql,errmsg);
if not dm.QrySvr.IsEmpty then
begin
m_zzid:=dm.QrySvr.Fields[0].AsString;
m_zcsq:=dm.QrySvr.Fields[1].AsString;
result:=0;
end
else result:=1;[[/code]
帖上一段代码
procedure TRes_HrCq_YD_F.GetoldYDCB;
begin
cbb_cb.Properties.Items.Clear;
cbb_cb.Text:='';
cbb_cb.Properties.Items.Clear;
qry_getoppo.Close;
qry_getoppo.SQL.Clear;
qry_getoppo.SQL.Add( ' select CB from Res_User_Temp where CB is not null group by CB ');
qry_getoppo.Open;
while not qry_getoppo.Eof do
begin
cbb_cb.Properties.Items.Add(Trim(qry_getoppo.fieldbyname('CB').AsString));
qry_getoppo.Next;
end;
end;
sqloledb.1你知道你说的是不是这个?谢谢大家啊