Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remote View vs SQL Pass through
Message
 
À
01/11/2001 01:37:55
Gerry Schmitz
GHS Automation Inc.
Calgary, Alberta, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00572183
Message ID:
00576051
Vues:
72
>
OK, I'll bite ... Why is it "far better to have your underlying columns match the order of the grid columns".
>

So you don't have to get into the explicit'ness of specifying columnsources. I brought it up because John Ryan seems to think that RV's have a distinct advantage @ being swappable with respect to grids. I have done this countless times with SPT. One of the things that makes it easier is if the underlying table columns match the grid columns. Anything else, and I think you are creating more work for yourself.


>(Having implemented "hundreds" of grids, which included: multiple sources per grid, multiple grids per source, related grids, multi-select grids, incremental grids, "calculated" columns, etc. .... and never having gotten hung up about "underlying column order").
>

Don't get me wrong, if somebody knows how to handle the situation, one won't get hung up. My only point is that more work is created in managing the situiaton. That's all..

>
For that matter, one could argue that the "column order" of the SQL Select should "match" the column order(s) of the base table(s) ... although I wouldn't.
<

One could argue that. However, it would be a very weak argument.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform