4D allows ORDA to be used on another database that has enabled itself to expose itself as a remote datastore. The datastore can be connected to using the Open datastore command.

A compiler warning or error can occur if Object Notation is used to reference a table that does not exist in the Local Datastore. This has a more likely chance of occurring when interacting with a Remote Datastore that does not have the same tables as the Local Datastore.

A workaround to this is to use bracket notation and apply the name as a string instead of a property.

Instead of:

$remoteDS:=Open datastore($connectionObj) $es:=$remoteDS.RemoteTable.all()

Try:

$remoteDS:=Open datastore($connectionObj) $es:=$remoteDS["RemoteTable"].all()

This will allow the syntax check and compiler to not trigger an error and allow the database to be compiled.