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
