I have a situation where ElevateDB is not displaying an error message on the users computer.  When I run the application on my system with their data, I receive the error in Delphi IDE.

I am running the ElevateDB Server as a service.  The error is in regards to a bad index in a table.  When I reindexed the table as was well.

The problem is that the error does not show up on the users system.

What do I need to do?

Thank you,
Lee Mc Cauley

Lee

>I have a situation where ElevateDB is not displaying an error message on the users computer. When I run the application on my system with their data, I receive the error in Delphi IDE.
>
>I am running the ElevateDB Server as a service. The error is in regards to a bad index in a table. When I reindexed the table as was well.
>
>The problem is that the error does not show up on the users system.
>
>What do I need to do?

With the information you've given so far about all I can say is "change your program"

The fact that you get an error in the IDE and your user doesn't when running the program could be that the program has exception handling built in. What happens when you run the program with their data outside the IDE?

What is the error? What operation causes it?

Roy Lambert

Roy Lambert wrote:

Lee

>I have a situation where ElevateDB is not displaying an error message on the users computer. When I run the application on my system with their data, I receive the error in Delphi IDE.
>
>I am running the ElevateDB Server as a service. The error is in regards to a bad index in a table. When I reindexed the table as was well.
>
>The problem is that the error does not show up on the users system.
>
>What do I need to do?

With the information you've given so far about all I can say is "change your program"

The fact that you get an error in the IDE and your user doesn't when running the program could be that the program has exception handling built in. What happens when you run the program with their data outside the IDE?

What is the error? What operation causes it?

Roy Lambert

Roy:
Thank you for your help. I do not believe that I have exception handling built into my application.  The application seems to raise other exceptions.  It seems that when an exception occurs on an Elevatedb table, the exception is not raised.
The exception occurs on Post.  The exception is that a duplicate key has occurred on an index.  After I reindexed the table it was fine.

Lee Mc Cauley

Lee

>Thank you for your help. I do not believe that I have exception handling built into my application. The application seems to raise other exceptions. It seems that when an exception occurs on an Elevatedb table, the exception is not raised.
>The exception occurs on Post. The exception is that a duplicate key has occurred on an index. After I reindexed the table it was fine.

Again: What happens when you run the program with their data outside the IDE?

What you've posted now also raises another question - How does your user know they have a duplicate key error if there's no exception raised?

Also is this using an EDBTable or an EDBQuery?

Roy Lambert