[Gambas-user] Forbid DataSource to fetch certain fields

[Benoît Minisini]

Le 29/09/2012 09:44, Tobias Boege a écrit :
> 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
>

DataSource can take a SQL request instead of a table. But then you 
cannot modify the records.

-- 
Benoît Minisini