List:       mysql-odbc
Subject:    Re: problem with MySQL ODBC driver
From:       "Veso" <v.valchev () stz ! bulbank ! bg>
Date:       1993-12-12 11:29:19
[Download RAW message or body]

Hello Roger,

Thanks for your reply .
When I run the same query against MS SQL 2000 server everything is OK.
My suspicion is that MyODBC driver behaves different.

Veso

----- Original Message ----- 
From: "Roger Irwin" <irwin@iol.it>
To: "Veso" <v.valchev@stz.bulbank.bg>
Cc: "Myodbc" <myodbc@lists.mysql.com>
Sent: Monday, July 21, 2003 1:42 PM
Subject: Re: problem with MySQL ODBC driver


> I think you will find that your problem is with your data grid, which
> always tries to fill itself!
>
> Veso wrote:
>
> >Hello All,
> >
> >I'm using Borland C++ Builder ver. 6.0, MyODBC 3.51 driver and MySQL
server
> >4.0.13.
> >and ADO Components - TADOConnection,TADOQuery,TDataSource and TDBGrid
from
> >C++ Builder.
> >I set up ADOQuery->CasheSize = 20 and  ADOQuery1->ExecuteOptions <<
> >eoAsyncFetchNonBlocking
> >to read only first 20 records. If the customer want to read next records
> >he/she can use scroll bar.
> >My select statements usually returns from 10000 to 50000 records. I'd
like
> >to receive result records
> >as soon as possible, but MyODBC driver reads all result records into
> >internal buffers.
> >I don't want to use SQL statements like this "SELECT * FROM table LIMIT
> >0,10" for portability reasons.
> >So, my question is : How can I get retrieve data on a small chunks.
> >
> >Thank you in advance for any help,
> >
> >Veso
> >
> >
> >
> >
> >
>
>
>
> -- 
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe:
http://lists.mysql.com/myodbc?unsub=v.valchev@stz.bulbank.bg
>
>
>



-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=mysql-odbc@progressive-comp.com