KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
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