Run query Activity

[gustavo_marrufo]

Good morning Folks

I’m attempting to run a SQL query. However, I’m getting this error “New Line is not declared. it may be inaccessible due to it’s protection level”
What am I doing wrong? Can someone please help. Thanks!

[THIRU_NANI (NaNi)]

Hey!

Could you please send me the file…

because of the double quotes you’re getting the error… we have to add 2 double quotes between the starting and ending double quotes…

This will work

Regards,
NaNi

[Felix_Effendi]

Hi @gustavo_marrufo ,
i think u should use “+” instead of “&” on string.

[gustavo_marrufo]

here you go.

SQL Sample.txt (1.7 KB)

[gustavo_marrufo]

@Felix_Effendi I’m gonna try your suggestion . However, where do I place the “+”

will you provide an example of how it should be written

[Felix_Effendi]

hi @gustavo_marrufo ,
Ups my bad. Yes u can use & to concatenate strings.
But just realize that u use NewLine(). It should be Environment.NewLine.
SQL Sample.txt (2.1 KB)
Try this. hope it solves your problem

[gustavo_marrufo]

It worked! Thank you so much. Really appreciate it.

[Felix_Effendi]

ya u’re welcome.