>I am converting a FPD26 screen that used to popup a browse window in DOS. I have created a listbox to hold the values on the form but the problem I am running into is how to get the listbox to recognize the values. Right now it stuffs the columns using SUBSTR() with the entire contents of the field de_data. Here is my new code:
>
>
>thisform.list1.rowsource = substr(master.de_data,62,20), substr(de_data,2,25), de_profile
>
>two of the colums are a substr of the field. I have tried using a rowsourcetype of 6 - fields to no avail. Anyway to do this?
>
>Here is the original FPD26 code:
>
>BROWSE FIELDS ;
> x2 = substr(de_data,62,20) :H="License#", ;
> x1 = substr(de_data,2,25) :H="Name", ;
> x3 = de_profile :H="System ID" ;
> FREEZE x2 ;
>
>
>TIA!
Tracy,
When converting from FPD or FPW, I think it's a better choice to do what's referred to as a "deep port". This means changing some of the original code to a more object oriented way of doing things. It takes more time, but in the long run, it's well worth it.
BTW, I'd have used a select on the sub-string into an array.
George
Ubi caritas et amor, deus ibi est