Dynamic Query error

• Spottypalm

  Newbie

  Points: 2

  More actions

  June 24, 2005 at 2:39 pm

  #167519

  Greetings,

  Getting an error trying to follow the Walkthru on dynamic queries in a report...

  Here is the sql:

  "SELECT FirstName, LastName, Title FROM Employee" & IIf(Parameters!Department.Value = 0,""," WHERE (DepartmentID =   " & Parameters!Department.Value & ")") & " ORDER BY LastName"

  However , when it attempts to execute, it fails and changes the double quotes into brackets [

  Any ideas?

  Thanks,

  ~SFP

   

   

• stevefromOZ

  SSC-Forever

  Points: 43646

  More actions

  June 24, 2005 at 8:54 pm

  #568443

  might have been  typo, but do you have '=' (without quotes) at the start of your sql statement e.g.

  = "select abc, def, ghi from some_table....."

   

  Steve.

• Spottypalm

  Newbie

  Points: 2

  More actions

  June 27, 2005 at 7:28 am

  #568567

  Steve, Thanks for your suggestion... turns out, I needed to be in the generic designer for this to work.