>Greetings all
>How do I direct the location of the cursor in the following sql statement to the c drive
>
> SELECT * FROM apInvMast WHERE apInvMast.invPK = invPKSave INTO CURSOR "c:\curInvMastEdit" nofilter
>
>I get a syntax error on "c:\curInvMastEdit". Will not let me specify the drive. It might have something to do with sortWork, but I can not see how it would work in conjunction with sql
>
>thank, Vince
I suspect that you are not aware that the cursor can be addressed later via its name, or using the dbf() function. Here is some code snippets to give you a few ideas
SELECT * FROM apInvMast WHERE apInvMast.invPK = invPKSave INTO CURSOR curInvMastEdit nofilter
Select yourothertable
append from dbf('curInvMastEdit')
Select 0
..Do something..
Replace field1 with newvalue in curInvMastEdit
..Do some more..
Select curInvMastEdit && To make curInvMastEdit the active work area
..DO more stuff
