Hi Derek,
>> I'm sorry Steve, I must have been unclear. I'm talking about
>> remote-views, or cursors that have been made updateable to a base
>> table/SQL server, such as with Paul McNett's "MakeUpdateble.prg" or
>> whatever(I never used the PRG, but have done the cursorsetprop()'s
>> manually in prototyping)... All of these use buffering(table
>> buffering usually makes the most sense).
ah. Understood.
You might enjoy looking at Andy and Marcia's Data Classes, which are
excellent in this respect: they provide and completely manage
updateable cursors of back-end and/or local data, either MSSQL,
Oracle, VFP or any combination thereof, with a data-driven query
model, object interfaces, and full source with all the hooks,
functionality, and most of the bells and whistles you could imagine.
It's what we've been using for on a number of projects, present and
past. These classes are in the public domain...
**--** Steve
Thursday, July 31, 2003, 3:23:22 PM, you wrote:
>> >> 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?
>> Assuming sample data in SET PATH
>>
>> SELECT * from customer WHERE "p" $ Company INTO CURSOR
>> CurTest READWRITE
>> REPLACE ALL title WITH "Alpo"
>> SELECT TOP 5 * from curTest ORDER BY company
>>
>> .... gives me 5 records with "Alpo" for Title
>>
>> So READWRITE cursors are selectable, it's the buffering that
>> interferes:
>>
>> * continuing...
>> SELECT curTest
>> CURSORSETPROP("Buffering",5, "CurTest")
>> REPLACE ALL title WITH "zippo"
>> SELECT TOP 5 * from curTest ORDER BY company
>>
>> .... gives me 5 records still with "Alpo" for Title.
DJK> I'm sorry Steve, I must have been unclear. I'm talking about remote-views, or cursors that have been made updateable to a base table/SQL server, such as with Paul McNett's "MakeUpdateble.prg" or
DJK> whatever(I never used the PRG, but have done the cursorsetprop()'s manually in prototyping)... All of these use buffering(table buffering usually makes the most sense).
©2003 Steven Black |
