Subject | Re: Problems with Firebird 1.0 and Dialect 3 |
---|---|
Author | Alexander V.Nevsky |
Post date | 2002-09-12T08:10:47Z |
Steven, is this procedure definition taken from text editor where
you designed it or extracted from database? Couldn't your tool's
default settings convert it on compilation for dialect 3 to something
like
CREATE PROCEDURE "DELETECONTACTTEMP" (
"EMPLOYEE" CHAR (6))
AS
BEGIN
DELETE FROM "CONTACTTEMP" WHERE "EmpID" = :"EMPLOYEE";
SUSPEND;
END
which results in case sensitivity of identifiers?
Best regards, Alexander V.Nevsky
you designed it or extracted from database? Couldn't your tool's
default settings convert it on compilation for dialect 3 to something
like
CREATE PROCEDURE "DELETECONTACTTEMP" (
"EMPLOYEE" CHAR (6))
AS
BEGIN
DELETE FROM "CONTACTTEMP" WHERE "EmpID" = :"EMPLOYEE";
SUSPEND;
END
which results in case sensitivity of identifiers?
Best regards, Alexander V.Nevsky