dynamic textboxes

May 10, 2007, 09:21 AM

kummy

dynamic textboxes

I have the following records in my table

Slno Field1 Field2
1 A A
1 B B
1 C C
2 D D
2 E E

in one scenario i want to list the records for serial number 1 in a text box and i will edit the values. After editing it i need to update the respective values in the respective table for serial number 1

Field1 Field2
A A
B B
C C

In another scenario i want to list the records for serial number 2 in a text box and i will edit the values. After editing it i need to update the respective values in the respective table for serial number 2

Field1 Field2
D D
E E

is it possible to achieve this? if yes, Can anyone help me in achieving this.

Scott

May 10, 2007, 09:53 AM

kummy

i am not using maintain i am using webfocus7.1.4

May 10, 2007, 10:30 AM

Kamesh

try this code,

TABLE FILE CAR
PRINT
CAR
MODEL
ON TABLE SAVE AS TESTDAT
WHERE RECORDLIMIT EQ 3
-*WHERE MODEL LIKE '%u';
END
-RUN

-HTMLFORM BEGIN
< HTML >
< BODY >
< FORM NAME="FRM" ACTION="TEST2.FEX" >
-SET &CNT=0;
-CONTREAD
-READ TESTDAT &CAR.A16. &MODEL.A24.
-IF &IORETURN NE 0 THEN GOTO ENDIT ELSE GOTO BUILDTEXT;
-BUILDTEXT
< INPUT TYPE="TEXT" NAME="CAR&CNT" VALUE="!IBI.AMP.CAR;" >
< INPUT TYPE="TEXT" NAME="MODEL&CNT" VALUE="!IBI.AMP.MODEL;" >

-SET &CNT=&CNT+1;
-GOTO CONTREAD;
-ENDIT
< /FORM >
< /BODY >
< /HTML >
-HTMLFORM END
-EXIT

In your second fex you can write your update statement and save the new value.

Hope it helps,

WFConsultant

WF 8105M on Win7/Tomcat

May 15, 2007, 10:53 AM

kummy

Thanks a lot kamesh. it was a great help from you