parameter hard coded in SQL statement?

[gabster]

IS ti possible to hardcode a parameter name in a SQL statement in CR8?

Something like:

WHERE
Table.Fieldname = {?ParameterName}

Thanks,
Gabi.

 

[alley211]

Maybe I'm wrong in this thought process.

But if you do a record selection of:

Table.Fieldname = {?ParameterName}

it will be a part of your SQL statement.

This way you have a paper trail within Crystal if changes need to be made.

 

[gabster]

I tried this option but CR crashes with no other warnings...

The only thing it sais that "an error log is generated...".

The interesting thing when CR crashes, is that it's very misterious about what caused the crash...

 

[Ibtisam]

To hardcode the parameter in SQL statment you have to write it like this:

Table.FieldName = '{?ParameterName}'

I thing you miss the sigle quote.

 

[gabster]

I tried with single quotes too but in vain. CR crashes.

Thanks...