Page 1 of 1

Does virtual table has a max number of record ?

Posted: Fri 23 Feb 2007 12:58
by Edison Garcia
there are any kind of maximal number of record using virtual table?
I try to use it, with the followind configuration:
1 field string / 2 fields float / 2 fields currency and 1 lookup field string
Inside a loop, I starte doing insert / moving values to the fields and post.
My surprise was that, withaprox 200 records, the virtual table, inside the loop, becomes empty and stars to receive neu records till the endo of the loop ( about 150 records). With no msgs, even fro inside IDE (Delphi 7).
To come to the conclusion that it is what was hapening, I put a counter inside the loop and found that only the last 150 records were in the table at end.
Thank you Edison Garcia

Posted: Fri 23 Feb 2007 15:43
by Antaeus
No, TVirtualTable does not have any limitations on row count. Row count in TVirualTable is only limited by size of the system virtual memory.
Please send me a complete small sample at evgeniyD*crlab*com to demonstrate the problem. Also supply me with exact version of MyDAC. You can see it in the About sheet of TMyConnection Editor.