Bug #63695 Cannot select from views using ADO components in Delphi
Submitted: 9 Dec 2011 14:17 Modified: 9 Jan 2012 4:51
Reporter: Chris Marsh Email Updates:
Status: Not a Bug Impact on me:
Category:Connector / ODBC Severity:S3 (Non-critical)
Version:5.1.9 32 bit OS:Microsoft Windows
Assigned to: Bogdan Degtyariov CPU Architecture:Any
Tags: ADO components, Delphi, Views

[9 Dec 2011 14:17] Chris Marsh
Using the ADO components in Delphi XE you are unable to run a SELECT statement over views. The syntax for the SELECT statement works fine in MySQL and using previous drivers there are no problems.

How to repeat:
Create a simple form in Delphi XE
add an ADOConnection and an ADOQuery
Connect to the database
Select a view using the ADOQuery i.e. SELECT * FROM [View]
[13 Dec 2011 11:15] Bogdan Degtyariov
Hi Chris,

Unfortunately, we do not use Delphi for development purposes and therefore repeating this bug is not an easy task for us. Can you generate an ODBC trace and attach it to this bug report, so we could check what went wrong?
[3 Jan 2012 10:52] Chris Marsh
This problem as now been resolved by changing the option (in the connection string) from 3145731 to 3. This allows views to be selected.
[9 Jan 2012 4:51] Bogdan Degtyariov

Thanks for the update.
Closing the bug.