- Sun May 01, 2022 5:10 am
#829903
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.
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.