Skip to Content
0
Sep 25, 2013 at 12:43 PM

Single quotes in SQL query

973 Views

Hi team,

I am using a script in BODS job, and I want to pass table name as a global variable.

I am getting invalid table name error on following lines. I can see in error log that BODS added quotes for table name and column name variables.

Please help

Thanks

$G_ColumnDistinctValues = SQL([$$Repos_DB],'SELECT COUNT(DISTINCT({$G_ColumnName})) FROM '||

'{$G_TableName}');