Skip to Content
0
Apr 26, 2012 at 10:16 AM

Internal Error (6001) occured

141 Views

Dear all,

I am trying to get data after selection of CFL.

I have custom form SAY "Work Order".

In that i have Vendor Code CFL. After Selection of CFL, i want to fetch ShiptoAdress of that corresponding Vendor.

Code:

((SAPbouiCOM.EditText)(oForm.Items.Item(pVal.ItemUID).Specific)).Value = val;//code ((SAPbouiCOM.EditText)(oForm.Items.Item(destControl).Specific)).Value = val1;//name

string Querry="select isnull([Address],'')+', '+ isnull(Street,'')+', '+isnull(Block,'')+ "+

" ', '+isnull(ZipCode,'') +', '+isnull(City,'') +', '+isnull([State],'') + "+

" ', '+isnull(Country,'') from CRD1 where CardCode='" + val + "' and AdresType='S' ";

SelectRec = ((SAPbobsCOM.Recordset)(oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)));

SelectRec.DoQuery(Querry);

if (SelectRec.EoF == false) { str = SelectRec.Fields.Item(0).Value.ToString(); } ((SAPbouiCOM.EditText)(oForm.Items.Item("txtAddr").Specific)).Value =str ;//name