I need to: load all occurrences from a pre-loaded table (A-Apparel-Type Table)
into an array (A-Array), display all occurrences, and then allow a single array
entry to be selected. When array entry selected, move value of array entry
selected to another field (T-Apparel-Type).
A-Apparel Type-Table (permanent)
Occurrence 1 to 99
A-Apparel-Type Char (15)
(e.g. Blouse, Slacks, Dress, etc)
DECLARE A-Array table(index int identity(1,1), value varchar(50));
Do Until A-Apparel-Type occur (selected?)
or end of A-Array
SELECT * INTO A-Array
FROM A-Apparel-Type Table
Display A-Apparel-Type occur
If A-Apparel-Type occur (selected?)
SET T-Apparel-Type = A-Apparel-Type occur (selected?);
End IF
End Do
Will this work, please?
Davey Boy is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.