cancel
Showing results for 
Search instead for 
Did you mean: 

Query Generator Parameter Problem

Former Member
0 Kudos

Hi Expert ,

I'm using below query to display only customer code for parameter selection but its displaying Vendor code too.

Kindly guide me.

Declare @Fromdate Datetime

Declare @frmcode nvarchar(max)

Declare @Tocode nvarchar(max)

set @Fromdate = (select  MAX(T12.RefDate) From JDT1  T12 where T12.RefDate  <= '[%0]')

set @frmcode = (select  MIN(T13.cardcode) From ocrd t13 where t13.CardType='c'  and   T13.cardcode  >= '[%1]')

set @Tocode = (select  MAX(t14.cardcode) From   ocrd t14 where   t14.CardType='c'  and  T14.cardcode  <= '[%2]')

Thanks

-Rajesh N

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Rajesh,

This is by design. You may not be able to change the selection list for the parameter even if you give the condition.

Thanks,

Gordon

Former Member
0 Kudos

Hi ,

Thank you so much .

Rajesh N

Answers (1)

Answers (1)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

The query is working fine. If you add selection parameter for card code, it will show all BP code regardless of card type condition. But when you select for example vendor code, no result will be displayed.

Try without declare statement also same result.

Thanks & Regards,

Nagarajan