471,066 Members | 1,300 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,066 software developers and data experts.

ODBC 3.51 + ADO + MySQL Solaris server -> Unwanted Select * from..

Hey ppl,

I'm experiancing a very weird problem with my current Win32(win2k/XP)

I'm using:

* Delphi 7
* mySQL ODBC 3.51 drivers
* connecting to a Solaris server with MySQL 3.23.36
* Table type MyISAM, Dynamic row format

When I perform the following basic query:

select count(*)
from table
where (field=value)

the following is communicated between client and database server
(sniffed with ethereal):


select count(*)
from table
where (field=value)




Select * from table



This ofcourse is fully unwanted (with 30.000 records and 20 fields in
the table)! When performing the query the following way:

select count(*)
from `table`
where (field=value)

the second unasked query (select * from table) is not performed.

WHY??? My Quess it is something in the ODBC drivers, since the client is
sending the request for the second query, however, when connecting to a
mysql (4) NT server this behavour is not seen.

I've now updated all my queries to use the '`' with table names,
however, i'm sometimes still experiancing this weird behaviour, any
clues would be very very very welcome. Since this screws up my
application pretty badly.

Jul 20 '05 #1
0 1362

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Hal Halloway | last post: by
4 posts views Thread by Audrius | last post: by
2 posts views Thread by David | last post: by
2 posts views Thread by Beda Christoph Hammerschmidt | last post: by
4 posts views Thread by Bob Sanderson | last post: by
1 post views Thread by shan_rish | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.