Fill BODS variables from a sql database

[thomas_altnickel99]

HI,

i have an sql datastore called "EM_DATASERVICES". There i have the database "EM_DATASERVICES_DEV".

I have created the table "SELECTION_EXPRESSION_RESULT".  There i have the colums "Variable" and "Expression".

I have loaded this table to BODS. Now i will update the variable in BODS with the value from column "Expression".

I create a script in the workflow:

$G_WERKS = sql('EM_DATASERVICES','SELECT Expression FROM SELECTION_EXPRESSION_RESULT WHERE Variable = ''$G_WERKS''');

And i got this error:

[Script:Script530]
(Ln 1) : Syntax error : near <'> found <;> expecting <')', ','>

What did i wrong?

Thanks TA

[Julian_Riegel]

Hi,

use curly brackets to query such as 

$G_WERKS = sql('EM_DATASERVICES','SELECT Expression FROM SELECTION_EXPRESSION_RESULT WHERE Variable = {$G_WERKS}');