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:
None 
Category:Connector / ODBC Severity:S3 (Non-critical)
Version:5.1.9 32 bit OS:Windows
Assigned to: Bogdan Degtyariov CPU Architecture:Any
Tags: ADO components, Delphi, Views

[9 Dec 2011 14:17] Chris Marsh 
Description:
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?
Thanks.
[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 
Chris,

Thanks for the update.
Closing the bug.