I've a trouble with TMSQuery and TMSStoredProc when Im trying to execute SP ONLY thru these components.
After starting execution an error box are showing.
But all SP's still executable under MSSMS.
Code: Select all
mspFlowDocSearchByAttr->Active=false; if (cxDateEdit3->Text==NULL) mspFlowDocSearchByAttr->ParamByName("FlowDocDateStart")->Value.IsNull();
else mspFlowDocSearchByAttr->ParamByName("FlowDocDateStart")->AsDate = cxDateEdit3->Date;
if (cxDateEdit1->Text==NULL) mspFlowDocSearchByAttr->ParamByName("FlowDocDateEnd")->Value.IsNull();
else mspFlowDocSearchByAttr->ParamByName("FlowDocDateEnd")->AsDate = cxDateEdit1->Date;
mspFlowDocSearchByAttr->ParamByName("FlowDocCode")->Value=cxTextEdit2->Text;
mspFlowDocSearchByAttr->ParamByName("FlowDocDirID")->Value=cxLookupComboBox2->EditText;
mspFlowDocSearchByAttr->ParamByName("FlowDocTypeID")->Value=cxLookupComboBox1->EditText;
mspFlowDocSearchByAttr->ParamByName("FlowDocFromID")->Value=cxLookupComboBox3->EditText;
mspFlowDocSearchByAttr->ParamByName("FlowDocToID")->Value=cxLookupComboBox4->EditText;
if (cxDateEdit2->Text==NULL) mspFlowDocSearchByAttr->ParamByName("FlowDocPodrazdDate")->Value.IsNull();
else mspFlowDocSearchByAttr->ParamByName("FlowDocPodrazdDate")->Value=cxDateEdit2->Date;
mspFlowDocSearchByAttr->ParamByName("FlowDocPodrazdNum")->Value=Trim(cxTextEdit1->Text);
mspFlowDocSearchByAttr->ParamByName("FlowDocIsDeleted")->Value=0;
mspFlowDocSearchByAttr->ParamByName("FlowDocUserLogin")->Value=Trim(cxTextEdit3->Text);
mspFlowDocSearchByAttr->ExecProc(); //ERROR AFTER EXEC OF THIS LINE
I'm using RAD XE, SDAC 5.10pro, MSSQL2008