Error executing script in FbBatchExecution
------------------------------------------

                 Key: DNET-134
                 URL: http://tracker.firebirdsql.org/browse/DNET-134
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
         Environment: It's from user, trying to find more info.
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura


This script is failing.

/* SQL Manager 2005 Lite for InterBase/Firebird 4.4.0.5 */
/* ---------------------------------------------------- */
/* Host     : localhost                                 */
/* Database : D:\BASE.FDB                               */


/* Definition for the `NEW_TABLE_ID_GEN` generator :  */

CREATE GENERATOR NEW_TABLE_ID_GEN;

SET GENERATOR NEW_TABLE_ID_GEN TO 2;


/* Structure for the `NEW_TABLE` table :  */

CREATE TABLE NEW_TABLE (
  ID INTEGER NOT NULL,
  POPIS VARCHAR(100) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UTF8);


ALTER TABLE NEW_TABLE ADD PRIMARY KEY (ID);



/* Data for the `NEW_TABLE` table  (Records 1 - 2) */

INSERT INTO NEW_TABLE
VALUES (1, 'benzím');

INSERT INTO NEW_TABLE
VALUES (2, 'elektřina');

COMMIT WORK;

/* Definition for the `BI_NEW_TABLE_ID` trigger :  */

SET TERM ^ ;

CREATE TRIGGER BI_NEW_TABLE_ID FOR NEW_TABLE
ACTIVE BEFORE INSERT
POSITION 0
AS
BEGIN
  IF (NEW.ID IS NULL) THEN
      NEW.ID = GEN_ID(NEW_TABLE_ID_GEN, 1);
END^

SET TERM ; ^



-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to