Q1.

TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS XSQLOUT
END
-RUN

the result is

C1 C2 C3
a1 a2 a3
b1 b2 b3
c1 c2 c4


how can i use the XSQLOUT get the [b2]

use this : -SET &TEST1 = ....


Q2. how can get the html value from fex file ?

eg. html
<_select name=test1>
<_option value=1>a<_/option>
<_option value=1>b<_/option>



in fex
-SET &TEST1 = .... get [a]


Thanks,
Yang

This message has been edited. Last edited by: Kerry,

Yang do a search on the forum, there are many examples

thanks JG,

I searched ...i think my key not exact
(get data ,get data from html ...)
i try again...

Thanks,
Yang

can anybody help me?

Please explain what you would like to do a little more clearly.

Do you want to create option values for a select list form object?

One method:

SET HOLDLIST=PRINTONLY

TABLE FILE CAR
PRINT
COMPUTE OPT1/A100 = '<OPTION VALUE="' || COUNTRY || '">' || COUNTRY || '</OPTION>';
BY COUNTRY NOPRINT
ON TABLE SAVE AS S001
END
-RUN

-HTMLFORM BEGIN
<FORM>
<SELECT>
!IBI.FIL.S001;
</SELECT>
</FORM>
-HTMLFORM END

to Francis Mariani
thank your reply

you method is put the data in the html...

my mean is :

the result is

Column1 Column2 Column3
a1 a2 a3
b1 b2 b3
c1 c2 c4


i want get the value [a2] with XSQLOUT

the code like this :-SET &TEST1 = ....


Thanks
Yang

SET HOLDLIST=PRINTONLY
SET HOLDFORMAT=ALPHA

TABLE FILE CAR
SUM
WEIGHT/D6
HEIGHT/D6
BY COUNTRY
ON TABLE HOLD AS XSQLOUT
END
-RUN

-REPEAT ENDREP1 FOR &COUNTER FROM 1 TO &LINES
-READ XSQLOUT &CA.&COUNTER.A10. &CB.&COUNTER.I6.  &CC.&COUNTER.I6.
-ENDREP1

-? &C

???

thanks Francis Mariani

i'm trying...



Thanks,
Yang