The first thing we need to look at is how we have set up our databases. For simplicity sake we are running two identical databases on two different machines. The reason for running the two identical databases is so that we know ahead of time what our table/file structure will be. We could use 4D Open commands to retrieve the table/file structure if we wished and then use this information in our subsequent 4D Open calls. For our example since we know the table/fields of our database we can save some time by simply using the Table/Field numbers of our local database since they will correspond to our remote database. For example the [Employee] table in our local database will have the same Table number as our remote database since they are identical.
Download Complete Tech Note & Example: Windows | Mac