Tech Tip: Datastore does not contain tables without Primary Keys
PRODUCT: 4D | VERSION: 17 | PLATFORM: Mac & Win
Published On: September 20, 2019
The datastore does not contain any properties of tables that do no have a Primary Key, this includes relations.
For example in the the following structure, the "TableNoPK" table will not show up on the datastore:
Calling ds will not show the table without a PK:
This even includes the scenario where there is a link between the tables regardless of One to Many or Many to One:
With the relations above, since "TableNoPK" does nto have a primary key the following two will not work
ds.TableWithPK.Link_1_return
ds.TableWithPK.Link_2