Question
Artur Deguzman · Jan 18

Q: Need help with "into:CODE, :VALUE"

Hello all,

 

I just started learning SQL and am also new to Cache...

 

I am dealing with a simple SQL query and trying to understand the components of the following expression do:

STRING(city_name, ' - ', city_code) into :CODE, :VALUE 

I understand what the STRING function does. However, I am lost after that:

"into:CODE, :VALUE"

What do these do?

Thanks!

Deguza

0
0 107
Discussion (3)1
Log in or sign up to continue

expression into :var   stores the content of the expression into a local host variable var 

in your case you seem to get from STRING(...) 2 expression stored in to variables CODE  and  VALUE

this construct is typical for embedded SQL