Skip to Content
avatar image
Former Member

@Prompt error

Hello All,

I'm facing an issue with prompt error, error message is Microsoft SQL server native client 10.0: An expression of non boolean type specified in a contextwhere a condition is expected near ')'

object formula: @prompt('enter message','A','Department\group name',mono,free,persistent)

BO version: Business Objects 4.0 Sp2

Database: Microsoft sql server 2008



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Aug 19, 2014 at 04:01 PM

    Are you having a condition in the prompt syntax ? Prompts needs to be defined with a condition for example.. TABLENAME.CUSTOMER_NAME IN @Prompt('Enter Customer NAME','A',,Multi,Free,Persistent,{'ALL'})

    Add comment
    10|10000 characters needed characters exceeded

    • Curious if you ever found an answer to this problem.

      I am having the same issue when I try to use an MONO @prompt, I need to use "in" operator to get past one error but then it doesn't parse in the webi report.  If I use an "=" it parses in webi but gives error in universe.

      Guessing this is related to the SQL Server Native Client 10.0.  I use this so I can make OLE DB connections to the database.

      Curious if you found a way around it.  Works find when you use in/multi but can't seem to use mono.