Newbie using ADO & VB with mysql - Roderick Thompson - com.mysql.lists.win32

2 messages in com.mysql.lists.win32Newbie using ADO & VB with mysql

From	Sent On	Attachments
Roderick Thompson	08 Jun 2002 10:14
jbon...@sola.com.au	10 Jun 2002 16:24

Subject:	Newbie using ADO & VB with mysql
From:	Roderick Thompson (rode...@cebrasoft.co.uk)
Date:	06/08/2002 10:14:31 AM
List:	com.mysql.lists.win32

Im currently in the process of moving an Access Database over to MySQL (4.0 Alpha) and have been able to convert the SQL statements over without any problem.

Where the problem occurs is in referencing field names where I have selected from more than one table.

For example if I do "SELECT * FROM Table1, Table2", with Access & SQL Server I can read duplicate field names as rs("Table1.ID") and rs("Table2.ID") but this does not seem to work with MySQL. I get an error that it was not able to find the field.

What am I doing wrong ?

Thanks.