Pular para o conteúdo principal

Postagens

Mostrando postagens de abril, 2015

VB6 x MySQL - SELECT from two databases - Just one connection - (pt-BR: SELECT em dois bancos)

English : Considering that your databases are both on the same server/instance, yes, you can get fields from two or more databases. Remember:  -for this example you are using MyODBC 3.51 like me (MySQL 32bits, so, MyODBC 32bits); -your data source name is "store" and was properly set up; -Reference: Microsoft ActiveX Data Objects 2.5 library Português : SELECT em dois bancos (desde que estejam no mesmo servidor e instância do MySQL) Considere: -Para este exemplo, estou usando o MyODBC 3.51 (MySQL de 32 bits, ODBC de 32bits) -Referenciar: Microsoft ActiveX Data Objects 2.5 library __________________________ Raw/didactic code (please, read this twice) Private Sub getItemDescription(code as string) Dim sql As String sql = "SELECT dbStore.itens.description from dbCentral.itens, dbStore.itens " _     + "WHERE dbStore.itens.BarCode = dbCentral.itens.BarCode " _     + "AND dbStore.itens.BarCode = '" & code &  "';&