> >> We've mentioned a several occasions that buffering is now the way to go > >> instead of scatter. > >> > >> But, in the situation where the user is doing a data entry in the > temporary > >> table which has the same structure has the master table, and we then use > a > >> transfer button to move the record from the temporary table into the > master > >> table, isn't the only way to go scatter and gather? > > > >Why not SELECT INTO ARRAY, INSERT FROM ARRAY? > > Why not just scatter and gather? Is it too simple? :) If you are editting information in a Grid, then you'll have to scatter/gather for each row. SELECT/INSERT will work regardless if 1 record or n records.