Zeoslib Portal

Hello Rogier21 Use MapsTable.Append; MapsTable.FieldByName('ID').AsInteger:= 0 or -1 ; MapsTable.FieldByName('Description').AsString:='test'; MapsTable.Post; or as SQL INSERT INTO maps (id,description) VALUES(0, 'test'); or INSERT INTO maps (description) VALUES('test'); together with the trigger: CR...

Hello Rogier21 I use Firebird with Triggers like you since years and never had problems. I created my tables with triggers like the following CREATE TRIGGER Trg_Sec_User_GenID FOR Users ACTIVE BEFORE INSERT AS begin /* this creats a unique userid at every insert */ if ( (NEW.US_LFDNr is null) OR (NE...

Hello everybody to create a new Database try this code. Put Create string into connection properties. Works fine with Firebird. ZConnection1.Database := 'd:\db1.fdb'; ZConnection1.Protocol := 'firebird-1.5'; ZConnection1.Properties.Add ('CreateNewDatabase=CREATE DATABASE ' + QuotedStr ('d:\db1.fdb')...

Hello cariad, this is one of my SQL scipts to add a field and change the position of this field. SET NAMES ISO8859_1; alter Table ICenter ADD IC_Kenn VARCHAR(24) CHARACTER SET ISO8859_1 DEFAULT '?' NOT NULL; COMMIT WORK; Alter Table ICenter alter IC_Kenn POSITION 5; Commit work; Greetings Peter

Hello pbturner Had the same problem while writing BLOBs grater 18k to Firebird. Postet that probem 2005. No Fix until now. My solution worked for the last two years without problems. Look for Procedure "ReadBlobBufer" in File "ZDbcInterbase6Utils.pas" Insert following two lines b...

Hello charles_zou,

download following file

http://www.galileocomputing.de/dateien/ ... stenID-243

Save in "windows\system32" directory. Should work now.