Subject Re: [firebird-support] Store Duplicate Value (Visible to Active Transactions) ????
Author Martijn Tonies
Hello Kurt,

>I Have a serious problem in my FB database. Actually i'm using FB 1.5 and
>Delphi 7 and ODBCJDBC Driver.
>Tomorrow, and client with some one machine is comming to support and
>have the erros in database:
>attempt to store duplicate value (visible to active transactions) in unique
>index "RDB$INDEX_15"

Meaning, you're creating two fields with the same name for a certain table.

>Well, i have other 20 clients, with more data moviment and not apresent
>problem, for the time being. ;-)
> I look for solutions or idea of the Problem and for this have any
>1) Energy oscilation;???
>2) I Have a Store procedure and she DROP and CREATE and table (Temporary
>Fisic Table), not a VIEW. I'm execute this procedure from Delphi with:
> Step
> 1) BeginTransaction
> 2) Execute Procedure
> 3) Commit Transaction
> After that other procedure adding data to Create Table. Whel... its
>possible when create a table without none index ou primary Key ocured error

This sounds like a bad idea.

>3) Its possible and procedure to only execute a part: Exemple: Drop and
>Create, and so block a transaction?

You're using DDL. DDL and transactions are somewhat special.

If the format of this table is always the same, why not create a permanent
and add a unique ID column to it. Aquire a unique ID from a generator and
use it to insert/delete your data.

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
My thoughts:
Database development questions? Check the forum!