Michael, Your example doesn't show where the lcSourceAlias and lcDestinationAlias get set. Are they perchance getting set from the tablenames, so they are the same? You can't have two work areas with the same alias.
Dan Covill On 05/22/12 12:25, Michael Savage wrote: > Here is a snippet of code I've tried. > *-lcSourceDatabase its tables are stored in the same directory. > *- > lcSource=ADDBS(JUSTpath(lcSourceDatabase)) + lcAlias+'.dbf' > I then trap for it to exist, in case the databases are different and > don't hold the same tables. > if file(lcSource) > USE (lcSource) in 0 ALIAS lcSourceAlias NODATA > endif > > *- I do the same thing with the destination tables > lcDestination=ADDBS(JUSTpath(lcDestinationDataBase)) + lcAlias+'.dbf' > IF !FILE(lcDestination) > use (lcDestination) in 0 ALIAS lcDestinationAlias NODATA > ENDIF > > > In the destination code, it blows up when I try to open the destination > table. (Error mentioned above.) _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** 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.
