RE: File Fields In Array

You could use SQL and use a lateral if you are only having to read the
data? Set it up as a view to keep from having to retype it with 40 fields

create table qtemp/monthly (month1 numeric(11,2), month2 numeric(11,
2), month3 numeric(11,2))

insert into qtemp/monthly values(100,200,300)

select mo.* from monthly, lateral ( values (1, month1), (2, month2), (3,
month3)) as mo (month, total)

Then fetch it into a DS Array.


message: 2

date: Fri, 12 Mar 2021 16:58:55 +0000
from: "(WalzCraft) Jerry Forss" <JForss@xxxxxxxxxxxxx>
subject: RE: File Fields In Array

RDi doesn't like the SamePos.
I'm on 7.3 tr6.