Records editing (dbGrid) for Interbase 6.01

I have Interbase 6.01 server, I want to edit a table that contains about 65,000 records. I use Filtered IBTable and dbGrid, every thing works fine in local server, but in the remote clients (In the same LAN) I encounter this error when I go to the last record in dbGrid (Error readign data from connection).
What did you suggest to do, and can I still I use Table instead of stored procedure?

I need to edit the records and insert new records.

btw. I have no points now but I'll give this question 100 points on 25-Sep-2001

I think that problem is in virtual memory. Large filtered datasets loaded into memory. I met this problem before. The error messages may be different, often, running application under Delphi IDE, you can see even something like "can't set debug hook". To solve problem use IBQuery and IBUpdateSQL like Meikl recommended. It's easy, just take a look at help, there is samples how to write Insert, Delete, Update statements.

I think that problem is in virtual memory. Large filtered datasets loaded into memory. I met this problem before. The error messages may be different, often, running application under Delphi IDE, you can see even something like "can't set debug hook". To solve problem use IBQuery and IBUpdateSQL like Meikl recommended. It's easy, just take a look at help, there is samples how to write Insert, Delete, Update statements.

I think that problem is in virtual memory. Large filtered datasets loaded into memory. I met this problem before. The error messages may be different, often, running application under Delphi IDE, you can see even something like "can't set debug hook". To solve problem use IBQuery and IBUpdateSQL like Meikl recommended. It's easy, just take a look at help, there is samples how to write Insert, Delete, Update statements.

Hi Igor, I sent to you a message in igor@novell.kz, did you receive it or not. btw in all my messages that I've sent to you recently, I didn't get the message back to inform me that the address is wrong, so that I suppose that it arrives.

seems your IB runs without UPS, right? I nthis case "Forced Write" options for database must be "True". It prevent from corruption data on power off. But IB work slow (while editing or inserting records) in this mode regarding necessity to write transactions immediatally after it was finished.

If your database already corrupted then you have to try restore it. Try to run "Database Validation". This options appears on popup menu while database doesn't connected. After that, backup your database and then restore it back.

-----
Igor.

PS: In further set sweep interval = 0 to prevent IB from sweeping database automaticaly.

PPS: I can't understand what's wrong with my e-mail. I receive all notifications from EE now, but no one till few days before weekend.

This article explains how to create forms/units independent of other forms/units object names in a delphi project.
Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…

Introduction
I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need.
This article will address some of the concepts when dealing with a multithreaded delphi database…

In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…