用下面语句
select r_time from record where id=1 order by r_time
假如查询出5条数据
想取出第i条数据,应该怎样卸写呢?
大概是这样:
for i:= 1 to 5
begin
r_time(变量):= 第i条数据 ......... next;
end;
select r_time from record where id=1 order by r_time
假如查询出5条数据
想取出第i条数据,应该怎样卸写呢?
大概是这样:
for i:= 1 to 5
begin
r_time(变量):= 第i条数据 ......... next;
end;
adoquery1.Sql.Clear();
adoquery1.sql.add('select r_time from record where id=1 order by r_time');
adoquery1.open();for i := 1 to 5 do
begin
r_time(变量):= adoquery1.FieldByName('r_time').asString;
adoquery1.Next;
end;
ADOQuery1.MoveBy(i);
ADOQuery1.MoveBy(i);