cancel
Showing results for 
Search instead for 
Did you mean: 

How to execute the procedure in sap b1

Former Member
0 Kudos

Hai to all,

I done a procedure in sql server .but i don't know how to execute that procedure in sap b1?

can anyone help me immediately.

Regards,

Ramya.S

Accepted Solutions (0)

Answers (7)

Answers (7)

Former Member
0 Kudos

hi,

Dim RSAs SAPbobsCOM.Recordset

RS = OCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)

SQl = "Exec Serial"

RS.DoQuery(SQl)

try..it will work

regards,

Avijit

Former Member
0 Kudos

execute in query generator

Former Member
0 Kudos

u can execute query by query generator

open query generator.

select Database

and then write query

Exec sp_name par1,par1

eg.

Exec Serial 1,2

Regards,

Avijit

Former Member
0 Kudos

hi,

try this code.

Dim rs As SAPbobsCOM.Recordset

RS = OCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)

RS.DoQuery("exec itemgrp '" & whs & "'")

Former Member
0 Kudos

Hi,

Still u have same problem.

please update in forum , so it will help for others .

Regards,

Avijit

Former Member
0 Kudos

Hi,

You can execute procedures i SBO by writing them in "SBO_SP_TransactionNotification" which i run with every Add or update un SBO. You can use conditions to limit down the frequency, by using the object_type parameter.

Regards

Andre

Former Member
0 Kudos

Hai David,

Thanks for your reply..i have an doubt.It is possible to execute the procedure directly through query Generator.

Regards,

Ramya.S

Former Member
0 Kudos

Hi,

In this case, you have to prefix (just like in any SQL-Server Management console) the name of your SP by the adhoc SQL command : EXEC

Regards,

Eric

Former Member
0 Kudos

Dear Ramya.S,

You could execute the store procedure by using Recordset object in SDK DI code. It is like:


Dim myRecordSet As SAPbobsCOM.Recordset

myRecordSet =                                    
SBO_Company.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecord
set)

myRecordSet.Command.Name = "TestStoredProcedure"

myRecordSet.Command.Parameters.Item("@ItemLike").Value = "IT%"

myRecordSet.Command.Parameters.Item(2).Value = "C0001"

myRecordSet.Command.Execute()

Nussi
Active Contributor
0 Kudos

Hi,

i hope it's still immediately

Look at this

[Link|;

regards

David