Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote View vs SQL Pass through
Message
 
 
To
01/11/2001 01:37:55
Gerry Schmitz
GHS Automation Inc.
Calgary, Alberta, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00572183
Message ID:
00576051
Views:
73
>
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform