Problem with string parameters 1

[jwaldner]

I have a report that uses a command to run a query. The command has several string parameters. When I enter the parameters at the query prompt, if I do not put single quotes around the strings I get a database error. I have never run into this before. I have used string parameters before with out running int this. Can anyone point me in the right direction?

I get syntax and other errors if Single Quotes are not used.

 

[lbass]

This is simply a rule for queries entered directly as commands. String parameters (only) have to be surrounded by single quotes. If you were instead using the main report record selection area, there would be no need for quotes.

-LB

 

[jwaldner]

the problem is the user of the report will not understand why the quotes are needed. Might there be a way around this?

 

[lbass]

You should be placing the quotes around the parameter inside the command. Then the user just responds to the prompts the usual way. Inside the command, you might have, e.g.:

where table.string = '{?parameter}'

-LB