Re: sql expression

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



I didn't see that when stored procedure / package has input parameters,
Crystal prompt for value -
When does Crystal prompt for values ?
(should I put a specific sign in the parameter, so Crystal should prompt for
value, such as ":", "&" etc ?)

What i did in sql expression is :
my_package.my_funcion("TABLE1"."COLUMN1", "TABLE2"."COLUMN2")

'TABLE1"."COLUMN1" is a column of one of the tables of the report in
crystal.
my_package is a db package
my_function is a function in the package.

Thanks :)


.