[Gambas-user] Forbid DataSource to fetch certain fields

[Tobias Boege]

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
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