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

related

>have the erros in database:
>STORE RDB$RELATION_FIELDS faied
>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

same

>problem, for the time being. ;-)
> I look for solutions or idea of the Problem and for this have any
>possiblite:
>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

not

>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
table
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
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com