Frequently Asked Questions
How to execute a parameter stored procedure from B1 queries
Please see the example below to execute the SP compare_proposale_order with parameter RentalOrder number.
-----> Start
Declare @order as int
SELECT @order = T0.[DocEntry] FROM [dbo].[@CIM_R007] T0 WHERE T0.[DocEntry] =[%0]
execute compare_proposal_order @DocEntry = @order
-----> Start
Declare @order as int
SELECT @order = T0.[DocEntry] FROM [dbo].[@CIM_R007] T0 WHERE T0.[DocEntry] =[%0]
execute compare_proposal_order @DocEntry = @order
Last Updated 5 years ago
