on 05-28-2008 10:16 AM
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
hi,
Dim RSAs SAPbobsCOM.Recordset
RS = OCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)
SQl = "Exec Serial"
RS.DoQuery(SQl)
try..it will work
regards,
Avijit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
execute in query generator
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
try this code.
Dim rs As SAPbobsCOM.Recordset
RS = OCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)
RS.DoQuery("exec itemgrp '" & whs & "'")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hai David,
Thanks for your reply..i have an doubt.It is possible to execute the procedure directly through query Generator.
Regards,
Ramya.S
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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()
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.