Hi,
i have a problem when executing big selects.
i am using mysql in a client - server environment.
the server database is a mysql database, whereas the
clients are MS Access databases, contining forms, queries, reports
and a lot of VBA code. The tables of the mysql database are connected
into the access client database via odbc.
at opening a form, a select is executed:
select <all column names> from <access query name> where
field = value;
and the (inner) access query is a triple join selecting 72
fields from three tables:
select <72 column names>
from ( <tab1> left join <tab2> on <key1> = <key2>)
left join <tab3> on <key1> = <key3>
/* <keyx> is a primary key in <tabx> */
in most cases when this form is loaded, the select return only a few
data records (about 20 to 30) and the result is correct.
however, there are few cases, where the select returns about 200
and more data records. in these cases, the result of the
first execution
of the select is not cerrect, instead there are only a few
datarecords
displayed. but, if the same select is executed another time,
ie leaving and re-entering the form, the select executes correct.
my question is: how can i achieve that the select always executes
properly?
thanks for all hints
rainer
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
