Selecting character with Apostrohe

[MaryumS]

I am trying to pass parameters to crystal but it does not accept it if it has an apostrophe..for example selecting an employee list with last name as a parameter..if I wanted to select all the "O'Conners" crystal gives me a sql error b/c it will interpret the first ' as an end quote..does anyone know a work around for this problem.

 

[kenhamady]

Passing from where? faq149-237 Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[MaryumS]

passsing from the crystal report and it sends the parameter to a stored procedure..if you connect a stored procedure to a crystal report it automatically creates the parameters on the report of the parameters in the procedure but it sends the parameters with single quotes so when you send a name or anything else with an apostrophe it interprets it as an end quote.

 

[kenhamady]

I haven't run across that. I will have to check it out. Maybe someone else knows a workaround. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com