Обсуждение: EditGrid

<p><font face="Arial" size="2">I really like the new features in the EditGrid, but I have a few feature</font><br
/><fontface="Arial" size="2">requests.  The first is just a convenience function, really.  It's a very</font><br
/><fontface="Arial" size="2">common idiom on Win32 to click a column header and get a sort on</font><br /><font
face="Arial"size="2">that column.  Similar functionality would be nice in pgAdmin.  I realize</font><br /><font
face="Arial"size="2">that it's not as powerful as the multi-column select that is available,</font><br /><font
face="Arial"size="2">but it would be a nice complement to it.  The other feature is much</font><br /><font face="Arial"
size="2">moreimportant to me.  I often want to view records in very large</font><br /><font face="Arial"
size="2">tables,but I don't want to wait a long time for the entire table to</font><br /><font face="Arial"
size="2">load. I usually don't want to see the entire table anyway.  What </font><br /><font face="Arial"
size="2">wouldbe nice is if the EditGrid could detect that a table will show</font><br /><font face="Arial"
size="2">morethan 1000 rows, and automatically set a filter that shows the</font><br /><font face="Arial"
size="2">first1000 rows.  Then, if you really want to see the whole table, you</font><br /><font face="Arial"
size="2">couldgo and erase the filter.  This way, I can look at a large table in</font><br /><font face="Arial"
size="2">areasonable amount of time without loading every record.</font><p><font face="Arial" size="2">The main reason
Ilike to use the EditGrid to view data is because it</font><br /><font face="Arial" size="2">shows empty strings as '',
whilethe SQL viewer does not.  With the</font><br /><font face="Arial" size="2">SQL viewer I cannot see if a blank
fieldis null or empty.  So alternatively,</font><br /><font face="Arial" size="2">if the SQL viewer displayed empty
stringsas '', that would work for me.</font><p><font face="Courier New" size="2">__</font><br /><font face="Courier
New"size="2">David B. Held</font><br /><font face="Courier New" size="2">Software Engineer/Array Services
Group</font><br/><font face="Courier New" size="2">200 14th Ave. East,  Sartell, MN 56377</font><br /><font
face="CourierNew" size="2">320.534.3637 320.253.7800 800.752.8129</font><br /> 

Dave Held wrote:
> I really like the new features in the EditGrid, but I have a few feature
> requests.  The first is just a convenience function, really.  It's a very
> common idiom on Win32 to click a column header and get a sort on
> that column.  Similar functionality would be nice in pgAdmin.  I realize
> that it's not as powerful as the multi-column select that is available,
> but it would be a nice complement to it.

Since the ordering is done on the server side, we'll probably stay with 
the current solution.

> The other feature is much
> more important to me.  I often want to view records in very large
> tables, but I don't want to wait a long time for the entire table to
> load.  I usually don't want to see the entire table anyway. 

Use the "View filtered data" instead of "View data". We get to know too 
late about the size of the result set to have it conveniently cut down.

Regards,
Andreas