🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.delphi.database.dotnet
Article #70

IBScrip and Firebird - Problem

#70
From: Hanno Blackert
Date: Wed, 21 Dec 2005 14:50
43 lines
2098 bytes
I have just stated to switch an application from Delphi 5 to a Winform 
application with Delphi 2006. My first experience to create a Firebird 
(V1.5) database by executing an IBScript, as worked fine with Delphi 5, was 
disappointing.

I did succeed in creating a database using the params:

Database.Params.Add ('USER ''SYSDBA''');

Database.Params.Add ('PASSWORD ''masterkey''');

Database.Params.Add ('PAGE_SIZE 4096');



Then I connect to that database and I execute a script that I have reduced 
to a single instruction:

(Line 1) CREATE DOMAIN BLATTNUMMER AS

(Line 2) VARCHAR(10);

When I issue IBSCRIPT.ExecutreScript, the program hangs.

When I combine the two lines into one line

CREATE DOMAIN BLATTNUMMER AS VARCHAR(10);

I get an exception:

STORE RDB$FIELDS failed. Atempt to store duplicate value (visible to active

transactions) in unique index "RDB$INDEX_2".

which does not make sense to me with a new created database.

Do I have to specifiy "Firebird" somewhere? The Firebird server is running. 
Does Delphi2006 eventually try to attach another server that cannot cope 
with the script?

I'd appreciate somebody's help.

Hanno
Technical Details
Message-ID: <43a96b69$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!newsfeed.hal-mli.net!feeder1.hal-mli.net!news-out.newsfeeds.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Thread: 1effe6,8586ae4e481d8be6,start
X-Google-Attributes: gid1effe6,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Hanno Blackert" <Hanno.Blackert@aucos.de>
Newsgroups: borland.public.delphi.database.dotnet
Subject: IBScrip and Firebird - Problem
Date: Wed, 21 Dec 2005 15:50:44 +0100
Lines: 45
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 62.225.64.2
Message-ID: <43a96b69$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1135176553 62.225.64.2 (21 Dec 2005 06:49:13 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!newsfeed.hal-mli.net!feeder1.hal-mli.net!news-out.newsfeeds.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail