Hi Derek,
>> 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.
**--** Steve
Thursday, July 31, 2003, 2:30:36 PM, you wrote:
>> Could somebody verify this:
>>
>> Create a table with one column called name c(10)
>> populate with a few rows of data - make data upper case
>> put the data in buffer mode 5
>> replace all name with lower(name)
>>
>> Issue a sql statement and direct the results to an array.
>>
>> Display the contents of the array.
>>
>> Questions:
>>
>> What do you see?
>> What should you see?
DJK> 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.
DJK> 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?
©2003 Steven Black |
