[thelist] GetRows goofiness (or my own)

[Joel D Canfield]

> 		   Just to clarify... DESCRIPT is a text field 
> (as opposed to varchar)?  If so, you may have to place it 
> last in the query; I've heard of this happening with text 
> fields in SQL Server (or Memo fields in Access), but that was 
> a long time ago...
> 
> SELECT WO_NUM, REQDATE, TYPE, TASK, NOTE, DESCRIPT 

Interesting. The fields above (your updated order) are of types int,
datetime, varchar(64), varchar(100), text, text

So, I've got two text fields. If that's really what's going on (I'll
check) this could be interesting. 

Or, since I'm leaving the company next Tuesday and they're closing by
end of year, maybe I'll forget GetRows and just keep the recordset open
for the ten seconds it takes to MoveNext through it. Ultra low usage on
these tools on a LAN, so I'm just barely interested in optimization.

Thanks

joel