Hey there,
sorry about the cross post, but whenever i mail the ODBC list, i tend not
to get any replies.
I posted a couple of weeks ago with this problem, basicially I am using
lotus approach to access a mysql database through myodbc.
it seems that i can only ever return approx 200 or so records in a
worksheet in approach. I thought at first that it may be a problem with a
buffer size? or some sort of return limit, but it now seems to be
connected to the joining of tables.
e.g. i want to return all records in the campaign table, these records
then have data in a tele and daa entry tables, which i want to return as
well, for some reason it will only return the first 200 records. if i use
another worksheet, only returning data from my Campaign tabel, it will
return all the records.
So what I am asking is, is anyone aware of any issues with MyODBC where by
there is a limit to the number of records returned across joins? And if so
is there a work around. Failing that, does anyone have any ideas on what
the problem might be. I'm guessing not many people have experience of
Approach, but i inderstand thats it is pretty similar to Access.
Regards
Conor
---------------------------------------------------------------------
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
