HI Karen
For some reason my Append did not work, it couldn't be me!
I made sure that I had 4 different rows but only 1 row appended.
I think a antonum column is causing the problem
thanks
Marc
----- Original Message -----
From: [EMAIL PROTECTED]
To: RBASE-L Mailing List
Sent: Tuesday, October 28, 2008 10:34 AM
Subject: [RBASE-L] - Re: Import & Export note field
Marc:
Yeah, that "can't be in the destination table" will get you all the time!
What I do is to create a temp table that looks like the destination table with
just those columns of data that I need to compare. So within the sub-select,
reference this copy of the table instead.
Karen
Hi Razzak
Thanks, I tried the Insert method but get an error about
you can't have the destination table in the where clause
or something like that. Also, I am hitting a snag on
Loading a table from a file.
No big deal, when I get more time to sit down and work
through this I should be able to get it to work.
My time is limited because I have to finish dealing with
putting out a fire, literally!
Thanks again
Marc