>Hello,
>I have an application where I populate a cursor. The cursor has the same structure as c:\transact.dbf. What I want to do is append the contents of my cursor onto the end of the c:\transact.dbf. I looked into the insert into query but it seemed like all I could use was memvar. I am confused!!
>
>Thanks!!!
>
>MAC
As far as the structure is same I'd simply do an 'append from' :
lcFile = locfile('c:\transact.dbf')
use (m.lcFile)
append from dbf('myCursor')
In VFP8 you might as well do an insert into as :
Insert into (m.lcFile) select * from ....
In earlier versions memvar is not the only supported. It supports memvar, name, array (array might hold multiple rows).
Cetin