execute query fails with variables

0
I am using studio pro version 8.8.1. I can insert and update records using MSSQL. When I use the table name as variable I am getting the following error: Caused by: com.mendix.modules.microflowengine.MicroflowException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'DepositsAgg_Ratio_OM'.     at SmartStreams.BrowseDataDisplay (JavaAction : 'Execute query') The table name is recognized correctly (see in bold characters above. This is the query: 'SELECT TOP 100 MemberID as Column1        ,MONTH1 as Column2        ,MONTH2 as Column3        ,MONTH3 as Column4 from '''+$Job_DataStorage/TableName+''' '   Thanks, Costin
asked
0 answers