cancel
Showing results for 
Search instead for 
Did you mean: 

using Store Procedure Program for SAP Business One

Former Member
0 Kudos

Hi All,

  Any sample program for using Store Procedure in VB.net for SAP Business One?

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Atul ,

Thanks.  Any sample program for using Store Procedure in VB.net for SAP Business One Application ?

Former Member
0 Kudos

Hi Lakshmi,

I can provide you SQL Procedure for SAP B1.


Please wait some other experts will provide you here.


Thanks'

--

--

Regards:::

Atul Chakraborty

ANKIT_CHAUHAN
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Lakshmi,

If I am getting you right, you can use it as follows:

SAPbobsCOM.Recordset oRecSet = (SAPbobsCOM.Recordset)SBO_Company.GetBusinessObject(BoObjectTypes.BoRecordset);

string Query = "Exec PROC_TestProcedure '" + Parameter1+ "','" + Parameter2+ "'";

oRecSet.DoQuery(Query );

where PROC_TestProcedure is the Procedure Name. And Parameter1 and Parameter2 are the parameters, if you are using any.

Hope it helps.

Thanks & Regards

Ankit Chauhan

Former Member
0 Kudos

Hi Lakshmi,

Please Re-Post in SDK Forum to Get Quick Response.

Thanks'

--

--

Regards::::

Atul Chakraborty