Arjon M. Policar
Member
Greetings Everyone! I am using Progress 11.3 I have this problem using the browse widget because one of the field that I want to retrieve contains number, and this numbers represent a character value.
This is a simple program that is similar to what I am doing:
Database:
Table: UserInfo
lname = Character
Fname = Character
Sex = Integer (1 = Male,2 = Female)
But I want to use a BROWSE WIDGET to display the output of this. I'm looking forward for your responses, thank you Everyone.
This is a simple program that is similar to what I am doing:
Database:
Table: UserInfo
lname = Character
Fname = Character
Sex = Integer (1 = Male,2 = Female)
Code:
DEFINE VAR t_row AS ROWID.
DEFINE VAR t_sex AS INTEGER INIT 0.
DEFINE VAR t_vsex AS CHAR INIT "".
FOR EACH UserInfo.
ASSIGN t_row = ROWID(forinsert.UserInfo).
RUN xxx.
DISPLAY Fname Lname t_vsex WITH 1 COL.
END.
PROCEDURE xxx:
FIND UserInfo WHERE ROWID(UserInfo) EQ t_row.
IF AVAIL (UserInfo) THEN DO:
ASSIGN t_sex = UserInfo.Sex.
IF t_sex EQ 1 THEN t_vsex = "Male".
IF t_sex EQ 2 THEN t_vsex = "Female".
END.
END PROCEDURE.
But I want to use a BROWSE WIDGET to display the output of this. I'm looking forward for your responses, thank you Everyone.