[fpc-pascal] "Invalid field size" when using UIB with fpc 2.3.1

Lukas Gradl fpc at ssn.at
Mon Sep 8 16:13:59 CEST 2008


Hi!

Just had to upgrade to fpc 2.3.1 for some reason.
But using fpc 2.3.1 UIB produces an "Invalid field size" error when 
trying to open a UIBDataset.

The same program works when using fpc 2.2.3.

For demonstrating the problem I created the following program:

When trying to open an UIBDataset I get an error: "EDatabaseError : 
Invalid field size : 4828"
Failes with: FPC 2.3.1 svn, UIB latest svn, Firebird 2.0, OS Ubuntu 8.04
Works with: FPC 2.2.3, UIB latest svn, Firebird 2.0, OS Ubuntu 8.04



program Project1;

{$mode Delphi}{$H+}

uses
   Classes, SysUtils, UIB, UIBLib, UIBDataset;

var IDB: TUIBDataBase;
     ITrans: TUIBTransaction;
     IQuery: TUIBDataSet;

begin
   IDB:=TUIBDataBase.Create(nil);
   ITrans:=TUIBTransaction.Create(nil);
   IQuery:=TUIBDataSet.Create(nil);
   IDB.DatabaseName:='DB.fdb';
   IDB.CharacterSet:=csISO8859_1;
   IDB.LibraryName:='libfbclient.so';
   IDB.UserName:='User';
   IDB.PassWord:='Pass';
   ITrans.DataBase:=IDB;
   ITrans.AutoStart:=false;
   ITrans.AutoStop:=false;
   IDB.Connected:=True;
   ITrans.StartTransaction;
   IQuery.DataBase:=IDB;
   IQuery.Transaction:=ITrans;
   IQuery.SQL.Text:='SELECT "DocID" FROM "Docs";';
   try
     IQuery.Open;
   finally
     if IQuery.Active then IQuery.Close;
     if ITrans.InTransaction then ITrans.RollBack;
     IDB.Connected:=False;
   end;
end.

Database-DDL:


CREATE DOMAIN "dm_Key" AS Integer
  DEFAULT 0
  NOT NULL
  CHECK (VALUE>=0)
;
CREATE DOMAIN "dm_TypID" AS Smallint
  DEFAULT 0
  NOT NULL
;

CREATE TABLE "Docs"(
   "DocID" "dm_Key" DEFAULT 0,
   "DocType" "dm_TypID" DEFAULT 0,
   PRIMARY KEY ("DocID")
);


anyone an idea how to proceed? Is this a bug somewhere? In UIB? In fpc? 
In my code?

Regards
Lukas

-- 

--------------------------
software security networks
Lukas Gradl <fpc#ssn.at>
Eduard-Bodem-Gasse 9
A - 6020 Innsbruck
Tel: +43-512-214040-0
Fax: +43-512-214040-21
--------------------------



More information about the fpc-pascal mailing list