Oracle Commands and String Parameters 1

[IanWaterman]

I have built a report (CR2013) with a command on Oracle 11.

All working fine with exception of string Parameters.

I can use the parameter builder inside the command function box to add in parameters and they work fine for Numbers and dates. However, when I try to add a string parameter I get an error.

It seems that if I add a where clause such as

Where StringField = {?StringParam}

If string parameter is say EUR, instead of creating SQL

Where StringField = 'EUR'

it creates

Where StringField = "EUR"

which causes an error.
Am I doing something wrong, is there a work around or is this a bug in the Crystal Command/ Oracle interface.

Thank you

Ian

 

[lbass]

Hi Ian,

I'm not familiar with CR2013, but in earlier versions, you need to use single quotes around a single value parameter created in a command, as in '{?string}'. If you are using a multi-value parameter, I think the quotes need to be omitted though.

If this doesn't help, can you show a sample of your command?

-LB

 

[IanWaterman]

Hi LB

Thanks

Changed where clause as you suggested and it works fine. Not just a CR2013 issue I have a client still on Version 9 and had same problem.

and ('{?Currency}' = 'ALL' or CURCODE = '{?Currency}')

Ian