同一个存储过程,在桌面下正常,在web service下却出错?
同一个存储过程,在桌面下正常,在web service下却出错?
如下,其中strMemo为Text类型,数据库服务器为MS SqlServer2000。
出错提示:External exception EEFFACE
//------------------------------------------------------------------------
String sql= " Create Procedure GetMemoOfStudent "
" @Name varchar(100) as "
" select Name,strMemo from Student "
" Where =@Name ";
Query->Close();
Query->SQL->Text=sql;
Query->ExecSQL();
adoStoredProc->Close();
adoStoredProc->ProcedureName="GetMemoOfStudent";
adoStoredProc->Parameters->AddParameter();
adoStoredProc->Parameters->Items[0]->Name = "Name";
adoStoredProc->Parameters->Items[0]->DataType = ftString;
adoStoredProc->Parameters->Items[0]->Direction = pdInput;
adoStoredProc->Parameters->Items[0]->Value = "大刘";
String strMemo;
adoStoredProc->Prepared ;
adoStoredProc->Open();
strMemo=adoStoredProc->FieldByName("strMemo")->Value;
adoStoredProc->Close();