H hqlww Unregistered / Unconfirmed GUEST, unregistred user! 2001-09-28 #1 求购一个利用Table中setkey,gotokey,gotonearest的查询方法，比如要查询一个学生信息 记录中的分数是80分的同学的信息，80分是有Edit自己输入，也就是动态的。
S smilboy Unregistered / Unconfirmed GUEST, unregistred user! 2001-09-28 #2 select cdname ,b.childname,c.childname from costdefine as a left join commoncode as b on a.shjtype=b.childcode and b.typecode='cpttype' left join commoncode as c on a.shjobject=c.childcode and c.typecode='cptobj' 我可是懒的写，我自己程序里面的一部分
select cdname ,b.childname,c.childname from costdefine as a left join commoncode as b on a.shjtype=b.childcode and b.typecode='cpttype' left join commoncode as c on a.shjobject=c.childcode and c.typecode='cptobj' 我可是懒的写，我自己程序里面的一部分
B Brave Unregistered / Unconfirmed GUEST, unregistred user! 2001-09-28 #3 with Table1do begin SetKey; FieldByName('FS').AsFloat := 80; GotoNearest; end; with Table1do begin EditKey; FieldByName('FS').AsFloat := strtofloat(Edit1.text); GotoKey; end;
with Table1do begin SetKey; FieldByName('FS').AsFloat := 80; GotoNearest; end; with Table1do begin EditKey; FieldByName('FS').AsFloat := strtofloat(Edit1.text); GotoKey; end;
