Defining automatic joins
When I connect to a MS Access database with some defined relations, Active Query Builder creates automatic joins - this works fine.
But how can I define automatic joins in combination with a MySQL database?
Example: The primary key "id" of table "users" should be automatically joined with the field "user_id" of the table "emails" (1:n)...
Is it possible to pre-define these relations programmatically?
Thanks in advance!
If foreign keys are defined in your MySQL database, setting the right syntax provider (MySQLSyntaxProvider) will let Active Query Builder load them automatically. If they aren't defined, you can define them programmatically or using the Metadata Container editor tool: download it (for VCL and Java editions, for .NET edition), run, and load metadata from your database. There you'll be able to create realtions between database objects and save the content to XML file. After that you shouldn't load metadata from your database, but from that XML file.
I can't point you to the right article in our knowledge base describing this functionality because you didn't tell me about what edition of Active Query Builder you are asking.