Page 1 of 2
To much records
Posted: Fri 06 Oct 2006 15:59
by normal
I use a database with more than 15000 records in one Table.
I'm migrating from BDE to MYSQL and replaced TTable with TMYTABLE.
Now application is very slow even when I query for few fields.
TDBLOOKUPLISTBOX, where I show the data, has only 12 rows. Is it possible to limit the datarows and get new data wheen scrolling or searching in TDBLOOKUPLISTBOX?
FetchAll=true because otherwise I get a "Lost connection during query"-error
Posted: Mon 09 Oct 2006 06:38
by Antaeus
Please specify exact version of MyDAC you use.
Posted: Mon 09 Oct 2006 09:06
by normal
I'm using Version 4.30.0.10
Posted: Mon 09 Oct 2006 09:31
by Antaeus
Try to download the last build of MyDAC (4.40.0.19) and test your application in FetchAll=False mode.
Posted: Mon 09 Oct 2006 11:34
by normal
Sorry, bad question. But how to update to new version?
Posted: Mon 09 Oct 2006 11:48
by Antaeus
You can download the last build of MyDAC from registered users area of our site. Please see your registration mail for details.
Posted: Mon 09 Oct 2006 16:10
by normal
Oh,oh,
with the new version I run into errors in rtl70 and dbrtl70.
Delphi Environment shows runtime error.
Returning back to the old version solve the problem.
Posted: Tue 10 Oct 2006 15:06
by Antaeus
Please specify in what kind of application does the problem appear (any application/any application with MyDAC/concrete application) after installing the last build of MyDAC.
Posted: Tue 10 Oct 2006 20:25
by normal
Delphi 7.1 IDE
The problem appears when opening a Datamodul with TMyTables inside Delphi IDE.
Errormessages:
access violation at adress 40006EA8 ... in module 'rtl70.bpl'
and
access violation at adress 40348F92 ... in module 'dbrtl70.bpl'
Closing Deplhi I can see a runtime error 216.
Posted: Wed 11 Oct 2006 06:36
by Antaeus
Please specify if you have any other Core Lab DAC products (ODAC, SDAC, IBDAC) installed on the same IDE.
Posted: Wed 11 Oct 2006 10:42
by normal
No, there are no other Core Lab products
Posted: Wed 11 Oct 2006 12:58
by Antaeus
Possibly MyDAC unintallation was unsuccessful. So, you have some files left from previous version of MyDAC on your hard drive. Try to uninstall MyDAC and remove all the files concerned to it. Then install last build of MyDAC one more time. To remove all vestiges of MyDAC, please follow these instructions:
1) Close IDE
2) Uninstall MyDAC
3) Search for MyAccess.*, DBAccess.*, mydac*.bpl, dac*.bpl etc files at your HDD and delete them
4) Remove from the project directory all files made by compiler and linker
5) Remove from the registry (HKCU\Software\Borland\Delphi\7.0\Known Packages) all the links to MyDAC packages (mydac*.bpl, dac*.bpl)
6) Run IDE and check that it is started without errors
7) Install MyDAC once more
Posted: Wed 11 Oct 2006 15:38
by normal
I uninstalled 4.3 and 4.4. installations but no success with 4.4.
rtl70 and dbrtl70 errors are still there.
4.3 is running.
Posted: Thu 12 Oct 2006 15:16
by Antaeus
Please try to open following files with Delphi with last MyDAC installed and report us in which cases the error appears:
1) VirtualTable demo (VirtualTable.dpr)
2) Lock demo (Lock.dpr)
3) Pictures demo (Pictures.pas) and data module in this demo
4) Data.pas from Pictures demo (do not open the project file itself)
5) your project and data module in it
6) data module of your project (do not open the project file itself)
Also supply us with some information:
1) which version of MyDAC do you use (Trial, Standard or Professional)
2) do you have in the data module of your project any dataset opened in design time
Posted: Thu 12 Oct 2006 17:35
by normal
Version: MyDAC 4.3.0 Delphi 7 Standard
all your demos are runnig without problems.
When I open my data module (lone or with project) at design time, I see the known errors.
I have my own Table class from TMyTable. I testet this component alone in a form and got the same problem. I will test my component.