Subject Re: [IBO] Too many savepoints ...
Author scr0546
Hello Helen,

thanks for your support.
(Besides - your book is great and did help me often :-)
The background, why I discuss the problem in this group:
I had my application running with BDE/FB over 5 years without any
problems with FB. In month's of work I did migration to IBO/FB and
since 3 weeks the new application is running in productive
environment. It must work 100% stable
(who believes ..? but thousands of peoply want to pass the access-
control to a soccer stadion with valid barcodetickets ... in a short
and FB should not be the problem. I like FB and it's stability.
So I will check all your discussion-points from your last message.
Maybe I did something wrong when I migrated from BDE.

- I only use TIBOQueries, created and destroy dynamically
(no components in a Datamodule)
- All Transactions Autocommit = true
(also created dynamically, handling different groups of queries)
- Sometimes I use explicit Transactionhandling
(StartTransaction, Commit)

> You said that your inserts "work". Do you verify that by querying
> from an external tool?

I have checked the inserted records after restarting FB.
The DB-File was not corrupt.

> I smell a long-uncommitted transaction here...
> Consider the possibility that your bulk insert is causing some
> of infinite loop. Don't forget to examine what any Before Insert
> triggers on that table are doing.

Don't think so, there have been thousands of records inserted the
same way. But I'll check the BeforeInsert-Trigger ... there where a
lot of checks and work before inserting records

> -- Instead of pseudocode, show the actual SQL and the actual
client-side code.

It's impossible, because a lot of code.
I think the reason for the crash is not the only procedure when
inserting the records.
Maybe the problem is caused by the ROServer for the dataexchange to
MS-SQL-server (created by another company).

> --You mentioned "Internet connection" - are you trying to run a
> two-tier application across the Internet?
another half a year of work ... migration do Remobjects....

> -- If you are passing blobs, show that as well.
Sometimes I use blobs, but without problems. they were not inserted
in a loop.

> -- Also provide details of the server version and model
WinXP, SS, FB, fbclient.dll

Best regards