Wayne Floyd:
Quote:>> (Stop me before I re-design again)
>> Need the most efficient (fastest loading and general access) design for
>> my VB4 Pro/Jet 2.5 project. I now have one table with a large number of
>> fields. The data is being displayed and modified in 3+ (several on tabs)
>> side-by-side grids. Some fields are calculated, but not displayed.
>> I could break it into several tables, to match the grids, if that would
>> help... but I must be able to sort the whole affair.
Chris Ashton:
Quote:>I'm a little confused as to why you have several grids side-by-side - if
>this is because you need to keep some columns in place while others are
>scrolled, get Apex's True DB Grid (Pro version) which allows you to define
>non-scrolling regions.
Wayne Floyd:
Chris, the fields in this large table lend themselves to
sub-categorization, thus display in separate grids. As these would be
too many to display on screen, they also fit nicely onto tabs. Really
makes a slick interface. I'm using Spread 2.5, which seemed faster and
more easily programmed than the various releases of the Apex standard
products. (Never had the chance to try their pro version.)
Quote:>For each grid have a data control defined as a TableType Recordset, with
>its own set of fields, then in the reposition events use the SEEK method on
>the index of the other data-controls to synchronise them.
So, selecting fields (say, 14) from my large table for a grid would be
more efficient than specifying the entire table as its recordset? Is
there no overhead for extracting specific fields? How about selecting
100 fields (spreadsheet type cells) for another grid... is there a handy
SQL command to get a range of fields? All I've noted were commands to
get several fields by name. Or, if I'm going to keep the table in one
piece, maybe I should just assign clones of the table's recordset to
each grid?
Thanks, Wayne Floyd
by