That's maddening as hell. Why in the world should VFP care [i.e., the VFP Dev Team] if a cursor created by SPT is altered? Anyway, the best I can come up with is:
SQLExec(lnHandle, 'select...', 'crsTemp')
select crsTemp.*, 00000000 Field1, space(20) Field2 ;
from crsTemp into cursor crsFinal readwrite
Mark McCasland
Midlothian, TX USA