请问各位高手,我想控制错误提示,我做一个小程序实现的功能是指定数据库下的指定表存在就正常,如果指定数据库下的指定数据表不存在就给出错误提示此表不存在,而我做的是给出系统的提示错误信息,不知道我的代码错在哪里,请指教
try
with adoquery1 dobegin
close;
sql.clear;
sql.add('if exists(select * from sysobjects where name=''t_bus'' And xtype=''u'')');
sql.add('select * from t_bus');
open;
showmessage('此表存在');
end;
except
showmessage('此表不存在');
如何改正,
try
with adoquery1 dobegin
close;
sql.clear;
sql.add('if exists(select * from sysobjects where name=''t_bus'' And xtype=''u'')');
sql.add('select * from t_bus');
open;
showmessage('此表存在');
end;
except
showmessage('此表不存在');
如何改正,
on e:exception do
showmessage(e.message);
end;
英文的错误提示!
begin
try
with adoquery1 dobegin
close;
sql.clear;
sql.add('select * from sysobjects where name=''t_bus'' And xtype=''u''');
open;
First;
if not eof then
showmessage('此表存在')
else
showmessage('此表不存在');
end;
except
showmessage('查询出错!');
end;
end;
sql.add('select * from sysobjects where name=''t_bus'' And xtype=''u''');
open;
if adoquery1.recordcount>0 then
showmessage('此表存在')
else
showmessage('此表不存在');
还是用
adoconnection1.GetTableNames(combobox1.items,false);
判断一下
Try
open;
except
on e:exception do
showmessage(e.message);
end;
Try
open;
except
execsql;
end;
就好了。
adoquery1.connectionstring:='';
adoquery1.connectionstring:='Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog='''+edit1.text+''';Data Source=WWW-A6X0D1T7LH2';将如何改正,请各位高手指教