append from (dbf(alimport))

Append from expects a file

Thierry Nivelet http://foxincloud.com/ Give your VFP app a second life in the cloud

Le 11 avr. 2018 à 20:03, Gene Wirchenko genew@telus.net a écrit :

append from (alimport)

Hi Gene,

'append from' appends data from a file on the disk and a cursor is not a file !

Can you try this : APPEND FROM (DBF(m.alimport))

The Foxil

Append from dbf('yourcursor')

Rafael Copquin

El mié., 11 de abr. de 2018 15:02, Gene Wirchenko genew@telus.net escribió:

Hello:

  I have some code where I am importing transactions.  I have a

cursor for these transactions where I validate them. After doing this, I want to add them to the transaction table. I select the transaction alias and then do append from (alimport)

  alimport is an alias variable.  It works for creating the cursor:
   SQLSEL * from cwkt;
   where .f.;
   into cursor (alimport) readwrite nofilter

It works to select the cursor: select (alimport)

  So why does the append not work?  I get error 1 with the text

"File 'c:\cbs2dev\cutlblas_import.dbf' does not exist."

  I figured out how to do this using SQL, but I would still like

to know why the append does not work.

Sincerely,

Gene Wirchenko

[excessive quoting removed by server]