General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Switching between databases of same name
Environment versions
Network:
Windows 2000 Server
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only