Philip L. Borkholder wrote:
> I'm with Anthony on this one.
> -Philip
"Me too". At least you know what you are getting. Uncommitted changes
could be in any state, especially new records which have been added
while buffered. You don't want to include them in a query..
Stuart
>
> Testi, Anthony L (UseTemp) wrote:
>
>> I do not understand, why is that a shortfall? If the data is
>> buffered, it
>> means that the user/program has not decided if the changes are
>> 'worthy' of
>> being really saved. Why would I want a SQL to return 'not approved'
>> data?
>> Seems like it works exactly as it should, at least in my little world.
>> Anthony
>>
>> -----Original Message-----
>> From: Derek J. Kalweit [mailto:dkalweit (AT) sensiblesoftware D.O.T com]
>> I'm surprised someone with your experience didn't know about this--
>> one of
>> VFP's biggest shortfalls-- SQL SELECT commands do not work with buffered
>> data! A SQL Select will ALWAYS read from disk. This means if you have
>> views,
>> or updateable cursors, you can't use SQL commands to read the data
>> from them
>> for any purpose. Bummer, eh?
>>
>>
>>
>>
>
>
>
[excessive quoting removed by server]
©2003 Stuart Dunkeld |
