How to use Declare parameter into SQL Query SAP Business One

[nikunjmehta2290]

Dear all,

How to use Declare parameter into SQL Query , SAP Business One.

Regards,

Nikunj Mehta

[LoHa · Accepted solution]

Hi

you can use different way to ask for parameter in query generator.

like

SELECT *  FROM OCRD T0 WHERE T0.[CardType] = '[%0]'

/**SELECT FROM [OFPR] T0 **/
DECLARE @DocDateFrom AS Date
/* WHERE */
SET @DocDateFrom = /* T0.F_RefDate */ '[%0]'

/**SELECT FROM [OFPR] T1 **/
DECLARE @DocDateTo AS Date
/* WHERE */
SET @DocDateTo = /* T1.T_RefDate */ '[%1]'

declare @from as dateTime
declare @TO as dateTime
set @from=(SELECT top 1 T0.[RefDate] FROM OJDT T0 where T0.[RefDate]=[%0])
set @TO=(SELECT top 1 T0.[RefDate] FROM OJDT T0 where T0.[RefDate]=[%1])

Look for the book

Mastering SQL Queries for SAP Business One by Gordon Du

regards Lothar