I am using the below code to get the output in HTMLSTACK. Example: In the maintain form, I‘ve three Editboxes1.Studentid 2.Lastname 3.Firstname. If I enter Studentid and it would automatically display FirstName and Last Name from HTMLSTACK. I’ve done something similar like populate from stack. But not from HTMLSTACK.I tried the below code, but it n’t display the name. I appreciate any one help me on this issue.

_*__________FEX CODE_________________________________________________________
-SET &Sid = &1;
TABLE FILE STUDENT
SUM
SID AS 'hankid'
LAST_NAME AS 'lname'
FIRST_NAME AS 'fname'
BY SID NOPRINT
WHERE SID EQ '&Sid';
ON TABLE PCHOLD FORMAT HTML
END
-*____________MAINTAIN CODEbelow___________________________________________________

MAINTAIN FILE student

$$Declarations
Declare cid / A7;
DECLARE last / A57;



Case Top
Compute hankidoutstk.HTML / A250;


Compute hankidoutstk.LAST_NAME / A57;

Winform Show Form1;
EndCase

Case hankoutfn
Stack clear hankidoutstk;
Exec CurrentStuEnroll PATH "searchstudent" from cid INTO hankidoutstk;
Compute cid='';
EndCase


Case Displaylastname
Compute last=hankidoutstk.LAST_NAME;
EndCase

END

When using the ON TABLE PCHOLD FORMAT HTML statement with your Table, Maintain receives a fully formatted report into stk.HTML/A200. The ONLY thing you can then do with that stack is display it in an HTML Object.

What you want to do is retrieve the stack as data. So, you should have:

-SET &Sid = &1;
TABLE FILE STUDENT
SUM
SID AS 'hankid'
LAST_NAME AS 'lname'
FIRST_NAME AS 'fname'
BY SID NOPRINT
WHERE SID EQ '&Sid';
ON TABLE PCHOLD
END

Do not use a format on the ON TABLE PCHOLD statement. Then in your Maintain you should have

Infer SID into hankidoutstk

and not:
Compute hankidoutstk.HTML / A250;
Compute hankidoutstk.LAST_NAME / A57;

Now, after your EXEC statement, you can use any of the fields in the stack. As a rule, NEVER place a format on a database field. Infer database fields into a stack and compute non-database fields into a stack.

Mark

Thanks Marks, it works perfectly.