Hit a funny problem while trying to insert records from files in one database to another of the same database container name.
Files are as follow:-
File A
\database\A\fileaname.dbf
\database\A\stdcontainername.dbc/dcx/dct

File B
\database\B\fileaname.dbf
\database\B\stdcontainername.dbc/dcx/dct

Both use the same database container name located in different directories.
I use views to update the fileaname.
The routine goes this way,
1) open fileaname in database\A
2) Add records into this file
3) open fileaname in database\b alias abc
4) Transfer records in fileaname to abc file
After saving, the next time I do the same process, the records that are supposed to be added to file A in step 2 somehow gets added to abc file instead. The adding is done via local views rather than directly on the tables itself.
I've tried to clos database, set database after step 4 to no avail.
Hope someone can shed some light.
Regards
Yau