This is mnoGoSearch's cache of https://lists.gambas-basic.org/pipermail/user/2012-September/041288.html. It is a snapshot of the page as it appeared during last crawling. The current page could have changed in the meantime.

Last modified: Sat, 29 Sep 2012, 09:44:15 CEST    Size: 3575
[Gambas-user] Forbid DataSource to fetch certain fields

[Gambas-user] Forbid DataSource to fetch certain fields

Tobias Boege taboege at ...626...
Sat Sep 29 09:44:15 CEST 2012


On Sat, 29 Sep 2012, Tobias Boege wrote:
> Hi,
> 
> rocko's recent question brought me back to a problem I once had:
> We have a database at school which contains a lot of big blobs (PDFs of
> student papers). It consequently takes an unneccessary amount of time to
> load all the records in there. My question is hence: Can I tell the DataView

read the last word as: DataSource ;-)

> to only load certain fields from the database table? I think of some
> DataSource.Columns property that does:
> 
> sReq = "SELECT " & DataSource.Columns.Join() & " FROM " & ...
> 
> I saw something similar in the DataTable.class source code but I couldn't
> figure out how to get the $aKey there modified. I think you'll know better.
> 
> Can someone please point me in the right direction?
> 
> Regards,
> Tobi




More information about the User mailing list