[alisoroush7]

hi guys
i have a table in sql which is like this:

product code weight
1235896 0.5
3256kms 1.5
dk-kmsw 3

and the data type for [product code] is nvarchar
now i want to call the weight by putting the product code in processmaker
the code that i wrote is this:

select [weight] from table where [product code] = @#textVar047

and by this code i get nothing, i have changed the @# to @@, @= but it did not work.

and the [product code] data type is NVARCHAR
how can i do this?

any comment is appreciated.

[ronrich]

Hi alisoroush7,

Pleas try this way

select [weight] from table where [product code] = '@#textVar047'

note that I've added the single quotes

Best,

[alisoroush7]

Hi alisoroush7,

Pleas try this way

select [weight] from table where [product code] = '@#textVar047'

note that I've added the single quotes

Best,

thanks you very much. it worked