Query string with quote -- sql server reporting services

Walter
8/11/2005 12:33:02 PM

I want to connect to table of AS400 with a parameter(THE NAME OF TABLE IS
AVP.M002)
The following sentence execute correctly.
SELECT * FROM LIB01."AVP.M002" WHERE CDTAB= '007'

How will be the string with the parameter: Parameters!ParmCDTAB.Value
I was trying with the string , but it doesn't run

="SELECT * FROM LIB01."AVP.M002" WHERE CDTAB= '" &
Parameters!ParmCDTAB.Value &"'"

The problem is ( "AVP.M002") . How I build the string to execute correctly?

Robert Bruckner [MSFT]
8/15/2005 8:17:56 PM

Just try this (duplicate the double quotes):
="SELECT * FROM LIB01.""AVP.M002"" WHERE CDTAB= '" &
Parameters!ParmCDTAB.Value &"'"

-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

sql server reporting services : Query string with quote