Error in Value

[#1]

Dear all,

I have a multibox and and one input box.. user will select value from the multibox

and data will be automatically filled up into the input box..Based on input box value my script will be execute..But problem is that my script get wrong value from input box.. For your better understanding i have attched my script, error picture...

Script:

Select * From ifsapp.CUSTOMER_ORDER_JOIN_UIV co, ifsapp.SALES_PART sp, ifsapp.CUST_MAIN_CATEGORY ct

where CO.CONTRACT= SP.CONTRACT

and SP.PART_NO= CO.PART_NO

and CO.CONTRACT='D010'

and CT.MAIN_CATEGORY_CODE= SP.MAIN_CATEGORY_CODE

//and CT.MAIN_CATEGORY_DESC like nvl('$(vcat)','%');

and CT.MAIN_CATEGORY_DESC ='$(vcat)';

Regards,

Masba

[tresB]

Probably while defining your variable vcat in the fron-end, you included ''(single quotes) around it. Try removing them.

[jonathandienst]

Hi

I am fairly certain that the GetFieldSelections function does not work in the script as the fields are not defined until the script run is complete.You will need to assign the GetFieldSelections() values directly to variable vcat before calling the script.

HTH

Jonathan

[#4]

Dear Jonathan,

Thanks for ur reply. can u give me one example file so that it will be so much helpfull me as a new beginner...

Regards,

Masba

[tresB]

Check the attached qvw.

[SunilChauhan]

Load  *

Where  CT.MAIN_CATEGORY_DESC ='$(vcat)';

Select * From ifsapp.CUSTOMER_ORDER_JOIN_UIV co, ifsapp.SALES_PART sp, ifsapp.CUST_MAIN_CATEGORY ct

where CO.CONTRACT= SP.CONTRACT

and SP.PART_NO= CO.PART_NO

and CO.CONTRACT='D010'

and CT.MAIN_CATEGORY_CODE= SP.MAIN_CATEGORY_CODE

//and CT.MAIN_CATEGORY_DESC like nvl('$(vcat)','%');

[#7]

Dear Sunil,

Thanks for your response.. Sorry to say u that ur provided solution is not working..

Regards,

masba