How to execute Non Query Double Quote

Help
1

Hi,

I need to perform query like this:

insert into t_redeem (redeem_id, redeemed_reward, redeemed_point, qty_redeem, “current_user”, created_on)

How can I do it on the non query activity? the current_user column need to be put quote (" ") otherwise it will be error.

Thank you.

2

Hi @AlfonGio Can you try with “current_user” as ‘current_user’ (means that instead of double quote use single quote)

1 Like
3

Hi @Arpit_Kesharwani, yes I have tried and still error

image
image729×278 10.8 KB

4

Try with “” current_user""

5

image
image952×101 8.82 KB

Still got this error

6

Hi, what is the database server you are using?
If it is sql server then try using in place parameters, will be easier for you:
INSERT INTO Persons (Name, City) VALUES (@Name, @City)

7

Hi @bcorrea, I am using PostgreSQL and the table is an existing table so unfortunately I can’t change the column name.

Here is the script directly from the pgAdmin:
INSERT INTO public.t_redeem(redeem_id, redeemed_reward, redeemed_point, qty_redeem, “current_user”, current_status, created_on)

How can I put the " " in the Non Query Activity?

image
image1171×281 18.2 KB

8

@AlfonGio Can you just click on OK and check if the Error goes off. Sometimes since there are multiple lines used, It marks it as an Invalid expression. Try it and let us know

9

just use triple quotes around that column.

10

you try can like below:

"INSERT INTO public.t_redeem(redeem_id, redeemed_reward, redeemed_point, qty_redeem, " & char(34) & "current_user" & char(34) & ", current_status, created_on)"