Skip to Content
Former Member
Mar 30, 2010 at 08:40 AM

About query generator.


SAP B1 2007 A PL46

Hi All,

I have many questions about query generator :

1. It is possible to use or to call a stored procedure ? If yes, how can we implement this ?

2. I try to use this query :

declare @commercial integer

set @commercial = [%0]

declare @prjbegin nvarchar(20)

set @prjbegin = '[%1]'

declare @prjend nvarchar(20)

set @prjend = '[%2]'

SELECT T2.[DocNum], T2.[DocDate], T2.[CardCode], T2.[CardName], T3.[ItemCode], T3.[Dscription], T3.[Quantity] FROM [dbo].[OINV] T2 INNER JOIN [dbo].[INV1] T3 ON T2.DocEntry = T3.DocEntry WHERE T2.[SlpCode] =@commercial AND T3.[Project] >=@prjbegin AND T3.[Project] <=@prjend

but it don't work. How can we do to use this ?

Thanks for your help.

Best regards.