tMSSqlRow - How to use schema variables in query

[Anonymous]

Hi, 

I have tMSSqlRow component with 2 variables in schema, named UPC and ITEM_NO.

The tMSSqlRow  is holding the output of tMap as follows :

How can I use the schema variables in Query ? i.e. in place of schema.ITEM_NO and schema.UPC ?

Thank you !

[vapukov · Accepted solution]

You must use prepared statements - check on Advanced properties of tMSSQLRow

change parameters to ?

 

and assign properties on Advanced Tab

in You case it will be

... SET ERP_WEST = ? WHERE UPC = ? ...

and parameters
index 1 - updae1.ITEM_NO
index 2 - updae1.UPC 

updae1 - same as on picture, think it update1