Two Databases Join?
Hi,
We have two databases with each different structure.
The first database contains address information (company, address, etc) , the second database contains products.
what i would like is to use both databases in bartender but i need somehow to join them. Of course not a problem, but these two databases do not contain the same columns. How can i join two databases when the actual column names differ in types of data?
We are using bartender automation latest version.
-
Legacy Poster
★ BarTender Hero ★
you can't join databases if their isn't a common column, it doesn't need to be the exact same name in each table, just the same piece of data.
0 -
Legacy Poster
★ BarTender Hero ★
Understandable but how would you use then a label which has product information from database 1 and address information from database 2? Bartender forces me to join those databases but they are completely different in data.
0 -
Legacy Poster
★ BarTender Hero ★
i got this one solved by using vb scripting from some other example on the forum. Thanks!
0 -
Legacy Poster
★ BarTender Hero ★
Tom V, can you point me to that example? I'm having a similar problem, needing to use a list of month codes and a separate list of year codes.
Thank you very much!
-Dan
0 -
Legacy Poster
★ BarTender Hero ★
Sent you a PM with more details.
BR Tom
0 -
Legacy Poster
★ BarTender Hero ★
Hi,
I have the same problem, that I have different databases without common columns. How can I avoid the "necessary" joins?
Thanks,
Konrad
0 -
Legacy Poster
★ BarTender Hero ★
You need to have a common column in your database. The only way to make it work when your database has no common column is by using vb scripting to refer to your database OR add a common column in your current databases. Good luck.
0 -
Jiří Hillebrand
★ BarTender Hero ★
Hello,
I have similar problem. I need to have two different database (one special date form, second counter). There is no connection between databases but still when I added both databases, Bartender need to set some connection and I don´t how to set up it.
And still Bartender writes
Could you help please?
0
Vous devez vous connecter pour laisser un commentaire.
Commentaires
8 commentaires