Pass aparameter to SQL expression?

[pgtek]

hi

Can i pass a parameter to an SQL expression

here is what i have
(Select E.bandlabel
FROM ECL_Ranges E where E.testsectionabbr='S' AND
E.eclabbr = 'A' and E.FP_Key = 2)


i want to replace the
E.FP_Key = {?paramter}

is this possible?

if so how to do it

cheers


pgtek

 

[nixy2000]

You could just wrap the SQL inside a stored procedure and pass the parameter to that?

e.g.

create proceedure spnamehere
@parameter as nvarchar(50)
as

Select E.bandlabel
FROM ECL_Ranges E where E.testsectionabbr='S' AND
E.eclabbr = 'A' and E.FP_Key = @parameter

 

[synapsevampire]

Yes, Crystal 9 and 10 support this using the add command and parameters.

Otherwise create a View and use CR parameters, or use a Stored Procedure (database dependent).

If you want better technical support, try posting your environment.

-k