> Can you send a test database to my private email ??, please
Can't find your e-mail. You can try script below...
/******************************************************************************/
/*** Generated by IBExpert 2006.11.26 08.01.2007 22:12:26
***/
/******************************************************************************/
SET SQL DIALECT 3;
SET NAMES NONE;
CREATE DATABASE 'D:\Test\FBDataBase\Test.fdb'
USER 'SYSDBA' PASSWORD 'xxx'
PAGE_SIZE 4096
DEFAULT CHARACTER SET NONE;
/******************************************************************************/
/*** Generators
***/
/******************************************************************************/
CREATE GENERATOR "Gen_TableId";
SET GENERATOR "Gen_TableId" TO 0;
/******************************************************************************/
/*** Tables
***/
/******************************************************************************/
CREATE TABLE "_Table" (
"Id" INTEGER NOT NULL,
"Name" VARCHAR(100) NOT NULL,
"Description" VARCHAR(1000)
);
/******************************************************************************/
/*** Views
***/
/******************************************************************************/
/* View: "View" */
CREATE VIEW "View"(
"Id",
"Name",
"Description")
AS
SELECT * FROM "_Table"
;
/******************************************************************************/
/*** Primary Keys
***/
/******************************************************************************/
ALTER TABLE "_Table" ADD CONSTRAINT "PK__Table" PRIMARY KEY ("Id");
/******************************************************************************/
/*** Triggers
***/
/******************************************************************************/
SET TERM ^ ;
/******************************************************************************/
/*** Triggers for tables
***/
/******************************************************************************/
/* Trigger: "_Table_BIU0" */
CREATE TRIGGER "_Table_BIU0" FOR "_Table"
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
IF (NEW."Id" IS NULL) THEN
NEW."Id" = GEN_ID("Gen_TableId", 1);
END
^
SET TERM ; ^
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
