Include Variable within "TEXT INTO" (SOLVED)

Posts: 811

Joined: Tue May 06, 2008 04:28 AM

Include Variable within "TEXT INTO" (SOLVED)
Posted: Fri May 18, 2018 06:44 AM

Hi All,

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

Example

cVar := 'Spain'

TEXT INTO cSql

        SELECT * FROM table WHERE country = cVar

ENDTEXT

Kind Regards,

Frances

Fivewin for xHarbour v18.07

xHarbour v1.2.3.x

BCC 7.3 + PellesC8 ( Resource Compiler only)

ADS 10.1 / MariaDB

Crystal Reports 8.5/9.23 DE

xMate v1.15

hmpaquito

Posts: 1515

Joined: Thu Oct 30, 2008 02:37 PM

Re: Include Variable within "TEXT INTO"
Posted: Fri May 18, 2018 07:42 AM

Hi,

Looking at viewtopic.php?f=6&t=29700&start=0

Regards

fraxzi

Posts: 811

Joined: Tue May 06, 2008 04:28 AM

Re: Include Variable within "TEXT INTO"
Posted: Fri May 18, 2018 08:30 AM

hmpaquito wrote:Hi,

Looking at viewtopic.php?f=6&t=29700&start=0

Regards

I tried:

Code (fw): Select all Collapse

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

The result should be:

Code (fw): Select all Collapse

SELECT * FROM table WHERE country = 'Spain'

but I got:

Code (fw): Select all Collapse

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

Kind Regards,

Frances

Fivewin for xHarbour v18.07

xHarbour v1.2.3.x

BCC 7.3 + PellesC8 ( Resource Compiler only)

ADS 10.1 / MariaDB

Crystal Reports 8.5/9.23 DE

xMate v1.15

hmpaquito

Posts: 1515

Joined: Thu Oct 30, 2008 02:37 PM

Re: Include Variable within "TEXT INTO"
Posted: Fri May 18, 2018 09:48 AM

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

Horizon

Posts: 1387

Joined: Fri May 23, 2008 01:33 PM

Re: Include Variable within "TEXT INTO"
Posted: Fri May 18, 2018 10:18 AM

fraxzi wrote:
hmpaquito wrote:Hi,

Looking at viewtopic.php?f=6&t=29700&start=0

Regards

I tried:
Code (fw): Select all Collapse
var := "'Spain'"
TEXT INTO cSQL
        select * from table where country = <<var>>
ENDTEXT
ps. I have not tested.

The result should be:
Code (fw): Select all Collapse
SELECT * FROM table WHERE country = 'Spain'
but I got:
Code (fw): Select all Collapse
SELECT * FROM table WHERE country = <<var>>

Maybe

Code (fw): Select all Collapse

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

Regards,

Hakan ONEMLI

Harbour & MSVC 2022 & FWH 23.06

anserkk

Posts: 1335

Joined: Fri Jun 13, 2008 11:04 AM

Re: Include Variable within "TEXT INTO"
Posted: Fri May 18, 2018 10:59 AM

Did you try this ?

Code (fw): Select all Collapse

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

Regards
Anser

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: Include Variable within "TEXT INTO"
Posted: Fri May 18, 2018 12:51 PM

fraxzi wrote:Hi All,

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

Example
Code (fw): Select all Collapse
cVar := 'Spain'

TEXT INTO cSql

        SELECT * FROM table WHERE country = cVar

ENDTEXT

Code (fw): Select all Collapse

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

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

Regards

G. N. Rao.

Hyderabad, India

FiveTech Support Forums

Continue the discussion