Hi !
)-----Original Message-----
)From: Conor McTernan [mailto:[EMAIL PROTECTED]]
)Sent: Monday, August 13, 2001 4:20 AM
)To: [EMAIL PROTECTED]
)Cc: [EMAIL PROTECTED]
)Subject: mysql/lotus approach question(sort of)
)
)
)Hey there,
)
)sorry about the cross post, but whenever i mail the ODBC list, i tend not
)to get any replies.
Last time I asked you to send the complete ODBC trace to simulate the
problem, but it looks in my mail box, I don't see any reply on that.
Any way I downloaded the Lotus approach, but as I don't know any thing about
it, is it possible for you to provide the basic work/setup in order to
reproduce the problem ?
)
)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.
)
Thanks a lot
Venu
--
For technical support contracts, go to https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Woodside, California USA
<___/ www.mysql.com
---------------------------------------------------------------------
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
