X xyt3dnow Unregistered / Unconfirmed GUEST, unregistred user! 2002-08-06 #1 如何在编号字段输入时判断它是否已经存在？用什么语句进行检索？
F forgot2002 Unregistered / Unconfirmed GUEST, unregistred user! 2002-08-06 #2 if exists(Select id from table where id=你的编号)
J jack_yuan Unregistered / Unconfirmed GUEST, unregistred user! 2002-08-06 #3 用Locate语句﹕ 例﹕ if Dm.Aperson.Locate(‘Emp_id’,trim(Dbedit1.text),[]) then ShowMessage(‘This Emp_id is already in this table’) Else ShowMessage(‘The Table havn’t this Emp_id’) End;
用Locate语句﹕ 例﹕ if Dm.Aperson.Locate(‘Emp_id’,trim(Dbedit1.text),[]) then ShowMessage(‘This Emp_id is already in this table’) Else ShowMessage(‘The Table havn’t this Emp_id’) End;
