JR,

>>As presented, your query does *not* have a connection to the backend.

>>It is literally a read-write cursor unless you deliberately use cursorsetprop() to link it back to the backend.

>>If it is the buffering that concerns you, does cursorsetprop("buffering",1,< mycursor > ) help?

>>Or am I missing something?

Oh how I wish you were NOT missing something! You cannot set CURSORSETPROP("buffering", 1, ). When you try, VFP comes back with an error messaage that tells you that you can only use buffering values of 3 or 5... optimistic record or table buffering.

Trust me on this one... what's returned by SQLEXEC() is a view. I dearly wish it wasn't.

Regards,
Thom C.