Bug #45993 Delphi Select 'hello' not recognized via MyODBC
Submitted: 7 Jul 2009 8:22 Modified: 10 Aug 2009 6:24
Reporter: Santoso Sugondo Email Updates:
Status: Duplicate Impact on me:
None 
Category:Connector / ODBC Severity:S2 (Serious)
Version:5.1 OS:Windows (XP SP2)
Assigned to: CPU Architecture:Any
Tags: Delphi, Select quot

[7 Jul 2009 8:22] Santoso Sugondo
Description:
What I Did:
I have a table :
  create table a (somestring varchar(50));
  insert into a values('one');
  insert into a values('two');
  insert into a values('three');
I use Delphi 5, component TQuery and input the SQL statement :
  Select 'helo' as value from a

I expected:
the component TQuery hold a field value that consist :
  helo
  helo
  helo

What happened :
Component TQuery doesn't have any data at all, even the field "value" is not recognized in the TQuery component.

Note: In MyODBC 2.5 or MyODBC 3.51 this bugs never happend and it works normally, but in MyODBC 5.1 this surely happen
Please Help Me....

How to repeat:
In addition, I also try : 
  Select 'helo' 
in Delphi and the result is the same is null.

Suggested fix:
MyODBC could show the field that not connect to the database.
[7 Jul 2009 8:55] Tonci Grgin
Santos, this is a duplicate of Bug#44935, right?
[7 Aug 2009 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[10 Aug 2009 6:24] Tonci Grgin
This is a duplicate of Bug#44935.