Include Variable within "TEXT INTO" (SOLVED)

[fraxzi]

Hi All,

Is there a way to include/inject variable within TEXT INTO?

Example

Code: Select all

cVar := 'Spain'

TEXT INTO cSql

        SELECT * FROM table WHERE country = cVar

ENDTEXT

 

[hmpaquito]

Hi,

Looking at http://forums.fivetechsupport.com/viewt ... 00&start=0

Regards

[fraxzi]

Hi,

Looking at http://forums.fivetechsupport.com/viewt ... 00&start=0

Regards

I tried:

Code: Select all

var := "'Spain'"
TEXT INTO cSQL
        select * from table where country = <<var>>
ENDTEXT
 

The result should be:

Code: Select all

SELECT * FROM table WHERE country = 'Spain'
 

but I got:

Code: Select all

SELECT * FROM table WHERE country = <<var>>
 

[hmpaquito]

Please, you should thoroughly review the link that I showed here.

[Horizon]

Hi,

Looking at http://forums.fivetechsupport.com/viewt ... 00&start=0

Regards

I tried:

Code: Select all

var := "'Spain'"
TEXT INTO cSQL
        select * from table where country = <<var>>
ENDTEXT
 

ps. I have not tested.

The result should be:

Code: Select all

SELECT * FROM table WHERE country = 'Spain'
 

but I got:

Code: Select all

SELECT * FROM table WHERE country = <<var>>
 

Maybe

Code: Select all

var := "'Spain'"
TEXT INTO cSQL
        select * from table where country = $1
ENDTEXT
cSQL:= Expand( cSQL, Var )

 

[anserkk]

Did you try this ?

Code: Select all

TEXT INTO cSql
  SELECT Column1 
  FROM myTable
  WHERE Column2 = ? 
ENDTEXT
nMyVar:=1
cSql := FW_AdoApplyParams( cSql, { nMyVar } )

Regards
Anser

[nageswaragunupudi]

Hi All,

Is there a way to include/inject variable within TEXT INTO?

Example

Code: Select all

cVar := 'Spain'

TEXT INTO cSql

        SELECT * FROM table WHERE country = cVar

ENDTEXT

 

Code: Select all

PRIVATE cVar := "'Spain'"  // do not declare cVar as local

TEXT INTO cSql
 SELECT * FROM table WHERE country = &cVar
ENDTEXT