var name:string; name:='test'; adoquery1.close; adoquery1.sql.clear; adoquery1.sql.add('select * from sysobjects where name='+''''+name+'''') adoquery1.open;
Query.sql.text:='select * from ...'; try Query.Open; except ShowMessage('Error Query'); end;while not query.eof do Begin ShowMessage(Query.FieldByName('FiledName').AsString(或者其它)); Query.next; end;我的EMial :[email protected]
多谢,不过还有一点不明白在'select * from sysobjects where name='+''''+name+''''这一行中+和+name+是什么意思?
在'select * from sysobjects where name='+''''+name+''''这一行中后面那个name 是变量,你可以给他赋任何值。
字符串连接。''''是表示一个 ‘引号。只要是构造一般的 sql语句,相当于下面这个语句:select * from sysobjects where name='YourTablename'
name:='test';
adoquery1.close;
adoquery1.sql.clear;
adoquery1.sql.add('select * from sysobjects where name='+''''+name+'''')
adoquery1.open;
try
Query.Open;
except
ShowMessage('Error Query');
end;while not query.eof do
Begin
ShowMessage(Query.FieldByName('FiledName').AsString(或者其它));
Query.next;
end;我的EMial :[email protected]