PrJlndni
Member
Good day Masters,
I would like to ask for your expert advice.
I have this code that use to retrieve all the names and its corresponding code ID in the database.
The list record as counted is around 1,266. I wanted to view it using a combo box. Upon running, this error occurs (REPLACE/CONCAT may not result in data > 32000 bytes. (11678)).
Please help. Thank you so much in advance Masters.
Regards,
PrJlndni
I would like to ask for your expert advice.
I have this code that use to retrieve all the names and its corresponding code ID in the database.
The list record as counted is around 1,266. I wanted to view it using a combo box. Upon running, this error occurs (REPLACE/CONCAT may not result in data > 32000 bytes. (11678)).
Code:
DEFINE VARIABLE t-to-user AS CHARACTER FORMAT "x(24)" label "User " view-as combo-box.
define variable userstr as char init "".
FOR EACH TSGInv.employee where TSGInv.employee.user-code NE "000" by TSGInv.employee.emp-name.
ASSIGN userstr = userstr + ',' + string(trim(TSGInv.employee.emp-name),"x(20)") + "|" + TSGInv.employee.user-code.
END.
ASSIGN t-to-user:LIST-ITEMS IN FRAME fr-user = userstr.
Please help. Thank you so much in advance Masters.
Regards,
PrJlndni