Well, this is the code
TextReader content = ResourceReader.GetResourceContent(this.GetType(),
"dbbarebone.", contentResourceName); // this just reads the script
FbScript sc = new FbScript(content);
sc.Parse();
// Send commands in batch mode
FbBatchExecution fbe = new FbBatchExecution(conn as FbConnection);
foreach (string cmd in sc.Results)
{
fbe.SqlStatements.Add(cmd);
}
fbe.Execute(); // here it fails
And the DDL is:
CREATE TABLE binarydata (
iobjid BIGINT NOT NULL,
bdata BLOB sub_type 0 segment size 4096);
ALTER TABLE binaryrevisiondata ADD CONSTRAINT PK_binarydata PRIMARY KEY
(iobjid);
CREATE TABLE data(
iobjid BIGINT NOT NULL,
isize BIGINT,
fid1 BIGINT,
fid2 BIGINT,
fid3 BIGINT,
fid4 BIGINT,
fid5 SMALLINT,
shash VARCHAR(30),
fid6 BIGINT,
stype VARCHAR (100) CHARACTER SET NONE COLLATE NONE);
ALTER TABLE data ADD CONSTRAINT PK_data PRIMARY KEY (iobjid);
----- Original Message -----
From: "Jiri Cincura" <[EMAIL PROTECTED]>
To: "For users and developers of the Firebird .NET providers"
<firebird-net-provider@lists.sourceforge.net>
Sent: Monday, August 21, 2006 9:24 AM
Subject: Re: [Firebird-net-provider] Problems with FbBatchExecution
> On 21.8.2006 8:55 pablosantosluac wrote:
>> Hi,
>>
>> I'm trying the latest provider with Firebird 2.0 RC4, and I got an
>> IndexOutOfRangeException trying to create some tables. Exactly the same
>> code
>> was working with Firebird 1.5.3...
>>
>> Any idea?
>
> Any example of code you're using?
>
>
> --
> Jiri {x2} Cincura
> http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job
> easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
