Multi-Database Joins
I'm having trouble trying to make a multi-database join between two different databases. BT keeps telling me that one (usually the one I put in the "right table" option, even when I switch them around) is not a valid db and so will not let me complete the join. In addition, while it will let me select the two different databases in the left and right tables, it will not generate the drop-down box for me to select the fields that need to be joined.
I have attached an image showing how the drop-down boxes are not generated, and also the error message.
Thanks
I have attached an image showing how the drop-down boxes are not generated, and also the error message.
Thanks
0
-
Shotaro Ito
★ BarTender Hero ★
[quote name='gemma' timestamp='1343172240' post='2942']
I'm having trouble trying to make a multi-database join between two different databases. BT keeps telling me that one (usually the one I put in the "right table" option, even when I switch them around) is not a valid db and so will not let me complete the join. In addition, while it will let me select the two different databases in the left and right tables, it will not generate the drop-down box for me to select the fields that need to be joined.
I have attached an image showing how the drop-down boxes are not generated, and also the error message.
Thanks
[/quote]
Hi Gemma,
It looks BarTender uses full path as database name, but query cannot take that. You need to give Alias to database name.
[url="http://seagullscientific.invisionzone.com/index.php?/topic/258-illegal-database-join/"]See this post[/url]
That happens with BarTender 9.4 and fixed in BarTender 10.0 - sorry for inconvenience caused.
hope that helps.0 -
Thanks very much for the reply.
I have tried creating aliases for each db, but it is still coming up with the same error, see below.0 -
Shotaro Ito
★ BarTender Hero ★
[quote name='gemma' timestamp='1343352903' post='2965']
Thanks very much for the reply.
I have tried creating aliases for each db, but it is still coming up with the same error, see below.
[/quote]
Try remove space from Alias name.
Remove the whole query and try to create the query again - that error dialog's text corrupted. That sometimes happen on BT9.4 or older - that issue was fixed in BT10.0 - sorry for the inconvenience, again.0 -
Thank you for your help. I now have the db join working, but naturally (for me!) I have another problem!
When I enter a prompt item it won't return any records. I have checked and double checked that I am entering the code correctly but it still won't work. The data is available when I look at the databses individually and then when I browse the individual tables in BT itself but not when I select ALL databases.
Any suggestions please?0 -
Hi There,
I also have this issue with my joined databases.
When ALL Data is selected it's OK. But once I put a data in the Query Form, it shows no data is available.
Please help.
0
请先登录再写评论。
评论
5 条评论