SQL _Passing a filename in a variable (AREV Specific) [Revelation On-Line Wiki]

Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

At 29 OCT 1999 06:56:46PM Mark RC Ford wrote:

AREV Specific

Is it possible to use a variable containg the name of a file in a SQL statement? In the example below I am passiing the file name in the variable FILE_VARIABLE

exec SQL SELECT CITY, ST INTO :CITY_PRM, :ST_PRM FROM :FILE_VARIABLE

WHERE ST=CA"

Thanks,

Mark

View this thread on the forum...