Multi-Database Joins 关注

0
Avatar
Legacy Poster

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

5 评论

0
Avatar
Shotaro Ito
版主
评论操作 固定链接

[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
Avatar
Legacy Poster
评论操作 固定链接

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
Avatar
Shotaro Ito
版主
评论操作 固定链接

[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
Avatar
Legacy Poster
评论操作 固定链接

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
Avatar
Legacy Poster
评论操作 固定链接

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.

 

请先登录再写评论。