When you access other databases, you are working with the actual data, not a copy. Not only can you view information from other databases, but you can modify and add information, depending on the access rights you have. For example, from R:BASE, you can add a row of data to a Paradox database.
In order for different database programs to communicate with each other, they use a standard Structured Query Language, or SQL. This language allows R:BASE to work with data in foreign databases. R:BASE does not actually perform actions itself, but sends the equivalent SQL command to the foreign database. The foreign database receives the command and performs the action on its own data. The foreign database controls the data validation, not R:BASE. For example, you are working in R:BASE and connect to a foreign database. If you add a row of data to a foreign table, R:BASE sends an SQL INSERT command to the foreign database, which then validates the data and adds the row to its table. You should be familiar with the access rights and constraints associated with the attached tables in their host systems.
ODBC Topics:
Connecting Data Sources and Tables
Disconnecting Data Sources and Tables
See also:
