Error Rep 159 when calling Report from Forms
Hi,
I am trying to call a report with a dynamic sql query from a form, the form passes several parameters to the report, including the where clause to restrict the output of the report.
I use a function in the form to replace all special characters and then change them back in the report. But for some reason it gives me a "syntax error on command line" whenever I enter a character-based parameters, so I assume it has somethign to do with the fact that there are quotes placed around the value (but since I replace all special characters, including the quotes I don't see why it won't work)