| 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: | |
| 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: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.

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.