Appending from a Cursor

Author: Gene Wirchenko

Posted: 2018-04-11 at 13:03:01

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

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/f7584e6e0a95e626446e13b9f8859e6f@mtlp000085

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

©2018 Gene Wirchenko