The Syntax of @prompt, @VariablL, @script is incorrect

building reports webintelligence
1

Hi,

we are in the process of migrating all our environment from 6.5 to XI3.1
when i try to compare one of our report , i am getting error.
report is based on free hand SQL. this is the syntax which is parsed in 6.5 and not parsing in XI3.1 environment…


Select	ArabicName, IDNUMBER, CMNO, NEWREFNO, A_NEW_START_DATE, 
                A_NEW_LOAN_AMT, A_REGLAR_INSTL_AMT, TOTAL_OUTSTANDING
From dbo.DRF_Report
Where NEWREFNO = @Prompt('Enter Loan Ref Number(Or Zero if not valid) :',A,,MONO,) OR 
           CMNO = @Prompt('Enter Customer Number(Or Zero if not valid) :',A,,MONO,) OR	
           IDNUMBER = @Prompt('Enter CIVIL ID(Or Zero if not valid) :',A,,MONO,)

same syntax is working fine in 6.5 and asking for Prompt.

when i run the same syntax in XI3.1 environment, its not asking for prompt, Instead it say The Synatax of @prompt,@Variabel,@script is incorrect

please let me know

[Moderator Edit: Added code formatting - Andreas]

Peliyar (BOB member since 2008-05-26)

2

Thanks a lot…

Issue is ressolve…

In BO XI 3 Data type Alpha numeric should come with codes…
‘A’

Peliyar (BOB member since 2008-05-26)