to make my project multilingual I use a table (SPRACH_RESOURCE) with 2 primary keys (ID_SPRACH_RESOURCE and ID_LANGUAGE). Now I want to use a second table (LAGERSTATUS) that has 1 join to the LANGUAGE table and 1 parameter to access it. How can I implement this?
here is the SQL command:
"select sp.BEZEICHNUNG from LAGERSTATUS la left join SPRACH_RESOURCE sp on la.ID_SPRACH_RESOURCE=sp.ID_SPRACH_RESOURCE and sp.ID_LANGUAGE='EN'"
I suggest you read about associations in documentation:
https://doc.tmssoftware.com/biz/aurelius/guide/mapping.html#associations-and-lazy-loading
And also this blog post that kind of summarizes it:
I have read the documentation. So you can't access a composite ID with 1 parameter and 1 join. it only works with 2 join.
Aurelius documentation:
Mapping | TMS Aurelius documentation (tmssoftware.com)
[JoinColumn('PATIENT_LASTNAME', [TColumnProp.Required])]
[JoinColumn('PATIENT_FIRSTNAME', [TColumnProp.Required])]
I also tried using a filter. That works, but after that the TDatabaseManager.Updatedatabase function no longer works.
I don't understand what you mean, can you please provide more details?
You can create associations that are joined to another table by one or more fields, and you can join to any field, as long the combination of such fields are unique in the referenced table.
I also don't know what filter are you referring to, and what problems are you getting with UpdateDatabase.