Two connections with the same table

[Benjami]

Hello,

I have the A table with two fields connected to the the B table.

When I clic in "show all records", receive this error:

"MySQL server said: Not unique table/alias: 'B'"

When I delete the second connection from A table to B table, works again.

(Or when I copy the SQL sentence viewed with the debug option enabled and manually edit deleting the second LEFT JOIN")

The B table only have one primary key that I use in the connections.

Any help would be apreciated.

Thanks!

Best regards,

Benjami

 

[Benjami]

Hello again,

My question is the same that in http://www.dadabik.org/forum/read.php?f=1&i=2363&t=2363

Is solved in the 3.0 or 3.1beta?

Thanks again

Benjami

 

[Debbie S]

Benjami

This is resolved in 3.1 Beta.

One note ... when linking to another table, ensure your primary key in the sub-table is not named the same as the primary key in the main table. For example:

main_table ... primary key = mainID
linked_table ... primary key = linkID


Debbie
(Latest version of DaDaBIK when this message was posted: 3.1 Beta)

 

[Benjami Villoslada]

I've installed 3.1 Beta and now woks fine, thanks!!

Regards

Benjami