在C++BUILDER中为什么不能处理SQL中的标签行(100分)

  • 主题发起人 meifeng99
  • 开始时间
M

meifeng99

Unregistered / Unconfirmed
GUEST, unregistred user!
sqlstring =" if exists(select name from sysobjects where name='aaa' and type='P')
sqlstring =" begin
";
sqlstring =" drop procedure aaa";
sqlstring =" end";
ADOQuery1->Active=false;
ADOQuery1->Connection=ADOConnection1;
ADOQuery1->SQL->Clear();
ADOQuery1->SQL->Add(SqlString);
ADOQuery1->ExecSQL();
ADOQuery1->Active=false;
//上边执行没有问题
sqlstring =" create procedure aaa"
sqlstring +=" as"
sqlstring +=" declare @bbb int"
sqlstring +=" set @bbb=1"
sqlstring +=" meifeng:"  //在C++Builder 中出错,在Sql中不出错
sqlstring +=" set @bbb=@bbb+1"
sqlstring +=" if @bbb<=10 "
sqlstring +=" goto meifeng" 
ADOQuery1->Active=false;
ADOQuery1->Connection=ADOConnection1;
ADOQuery1->SQL->Clear();
ADOQuery1->SQL->Add(SqlString);
ADOQuery1->ExecSQL();
ADOQuery1->Active=false;
 

Similar threads

S
回复
0
查看
3K
SUNSTONE的Delphi笔记
S
S
回复
0
查看
2K
SUNSTONE的Delphi笔记
S
I
回复
0
查看
1K
import
I
I
回复
0
查看
702
import
I
D
回复
0
查看
769
DelphiTeacher的专栏
D
顶部