Re: 4gl Input array question?

Matt Brickley wrote: >> >> 4GL 4.12, SE 5.01, SCO Unix 3.2v4.2 >> >> I have a table with 8 columns. I want to let the user update, delete, >> or insert to a screen array with only 6 of the columns displaying. >> How can I do this when the number of variables in the screen array must >> match the program array? While your screen array has to match your program array, your program array does NOT have to match your table! So, define your program array to hold the six columns the user needs to fiddle with. Then, match your screen array with the program array. During the insert, have a record like table.* structure which is used for the actual insert statement. Populate it partly with your program array. Populate the remaining fields(columns) with, presumably, your audit information (createtime, user, etc). Then, insert away. HTH ----------------------- Rudy Fernandes GIC, Kuwait OL 7.20UC4, 4GL 6.04UC1 -----------------------