我用Listview读取Access数据库中的表``````运行总提示“From语法错误”代码如下``````哪位大大 给解答一下``````小第分不多```谢谢帮忙`````procedure TForm1.FormCreate(Sender: TObject);
var
i:integer;
begin
qry1.SQL.Text :=('select * from IN');
qry1.Open;
for i:=0 to qry1.RecordCount-1 do
begin
with lv1.Items.Add do
begin
Caption := qry1.Fields[1].asstring;
SubItems.Add(qry1.Fields[0].asstring);
SubItems.Add(qry1.Fields[5].asstring);
SubItems.Add(qry1.Fields[2].asstring);
qry1.next;
end
end;
qry1.Close;
end;
var
i:integer;
begin
qry1.SQL.Text :=('select * from IN');
qry1.Open;
for i:=0 to qry1.RecordCount-1 do
begin
with lv1.Items.Add do
begin
Caption := qry1.Fields[1].asstring;
SubItems.Add(qry1.Fields[0].asstring);
SubItems.Add(qry1.Fields[5].asstring);
SubItems.Add(qry1.Fields[2].asstring);
qry1.next;
end
end;
qry1.Close;
end;
试试qry1.SQL.Text :=('select * from [IN]');