• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 303
  • Last Modified:

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

Thanks
Motaz
0
Motaz
Asked:
Motaz
1 Solution
 
darkloserCommented:
listening...
0
 
kretzschmarCommented:
maybe you should use an ibquery-object (for browsing) and
an ibupdatsql-object as update-object(property) of the query
for inserts, modifying and updates
0
 
MotazAuthor Commented:
I also get the same error when I open large query
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
MotazAuthor Commented:
How can I use ibUpdateSQL, and if you know that I'm using Lookup field and Calculated field, can this be done by Query and UpdateSQL?
0
 
ITugayCommented:
Hi Motaz.

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.

----
Igor.
0
 
ITugayCommented:
Hi Motaz.

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.

----
Igor.
0
 
ITugayCommented:
sorry, wrong thread :-)

Hi Motaz.

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.

----
Igor.
0
 
MotazAuthor Commented:
Hi Igor and Meikl,
I convert it to a query and I show only 20 records,
the application will be start operation today, so that keep in touch for unexcpected errors.

btw. We have a problem in Win98 network, so that large data cann't be manipulated in this network.

Motaz
0
 
ITugayCommented:
Hi Motaz,

seems all problems regarding network faults.

----
Igor.
0
 
MotazAuthor Commented:
yes,
Igor, have you MSN Messanger login? if yes then mine is azzzoz@hotmail.com
0
 
ITugayCommented:
Motaz,

I can use only  HTTP. All ports are inavailable. So, I have no any messengers. Sorry.

----
Igor.
0
 
MotazAuthor Commented:
What is your current E-Mail, I sent an E-Mail to you but you didn't reply, it was in : igor@aif.kz
0
 
ITugayCommented:
Hi,
I sent you message via e-mail. Just check sender's address :-)
0
 
MotazAuthor Commented:
I receive it and I reply, did you get the reply
0
 
ITugayCommented:
Hi Motaz,
no messages from you in my mail box.
try my old address igor@novell.kz, there is redirector to my new address.

Igor.
0
 
MotazAuthor Commented:
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.

Motaz
0
 
MotazAuthor Commented:
My Interbase database corrupted whenever the power is off, while there are a process or the database is opened, any experience this?
0
 
ITugayCommented:
Hi Motaz,

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.
0
 
MotazAuthor Commented:
Thanks Igor for all these information, it seems that I'll consult you in many things during the development in this project.

I don't know what is wrong in your E-Mail, I sent to you many times.

Motaz
0
 
MotazAuthor Commented:
Thanks Igor and Miekl, and sorry for late grading, I receive my points just now.
Miekl, I'll post 100 points for you.

Motaz
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now