Remove quotes from @prompt values

building reports desktopintelligence
1

Guys

I am trying to use @prompt in free hand sql so that the user can enter the tablename used in the query. Here is what i have

SELECT distinct(account_nbr)
FROM @prompt(‘Please Enter Table Name’,A,MONO,FREE)

But i get this error when i run the query

Exception: DBD, ERROR: ‘SELECT distinct(account_nbr) FROM ‘cust_acct_200911’ limit 0’
error ^ found “’” (at char 64) expecting an identifier found a keywordState: HY000

So i need to get rid of the quotes in the prompt value. How do i do that.

Thanks in advance

rajivkamath (BOB member since 2009-11-12)