>>It's different. I think VFP uses the same underlying mechanism for SPT cursors as for remote views. Try to turn off buffering on SPT cursor and you'll get following error "Views require either DB_BUFOPTROW or DB_BUFOPTTABLE".
>>
>>
>
>I just had to look up in help on how to turn off buffering since I have never done it before. I guess I never found the need for it, so I am safe there.
It was just an example to show that SPT cursor is close to a remote view. The row buffering on SPT cursor can bite you, though. Consider following pseudo-code
lnResult = SQLEXEC(lnConn, "SELECT ...", "crsRes")
REPLACE somefield WITH "Some New Value"
SELECT * FROM crsRes ;
INTO CURSOR crsRes2
BROWSE
The cursor crsRes2 will show old value for 'somefield' because change hasn't been commited to the cursor crsRes from a buffer.
--sb--