4 Replies Latest reply: Apr 13, 2012 6:11 AM by xiaodengzi1673

# how to use a viarable to receive a field value

run the following script ,I get xx.qvd;

what's wrong with it ?

test:

select 2 as a,4 as b;

Concatenate

select 3 as a,5 as b;

let xx=max(FieldValue( 'a', 1 ));

let yy=max(FieldValue( 'b', 1 ));

if xx<yy then

store test into yy.qvd;

ELSE

store test into xx.qvd;

ENDIF;

• ###### how to use a viarable to receive a field value

Hi,

You should not use max for assigning to the variables.

Change it like this

let xx=FieldValue( 'a', 1 );

let yy=FieldValue( 'b', 1 );

• ###### how to use a viarable to receive a field value

Hi,

If you need max and minimum value you need to do like this.

test:

LOAD 2 as a,4 as b AutoGenerate 1;

Concatenate

Load 3 as a,5 as b AutoGenerate 1;

tempMax:

Load Max(a) as Maxa,Max(b) as Maxb Resident test;

let xx=FieldValue( 'Maxa', 1 );

let yy=FieldValue( 'Maxb', 1 );

Drop table tempMax;

if xx<yy then

store test into yy.qvd;

ELSE

store test into xx.qvd;

ENDIF;

Celambarasan

• ###### how to use a viarable to receive a field value

Thanks all

• ###### how to use a viarable to receive a field value

Also, you may need to call your variables with \$...

test:

select 2 as a,4 as b;

Concatenate

select 3 as a,5 as b;

let xx=max(FieldValue( 'a', 1 ));

let yy=max(FieldValue( 'b', 1 ));

if \$(xx)<\$(yy) then

store test into yy.qvd;

ELSE

store test into xx.qvd;

ENDIF;

Hope this helps,

Jason