Subject | RE: [ib-support] Re: Problems with Firebird 1.0 and Dialect 3 |
---|---|
Author | Alan McDonald |
Post date | 2002-09-12T08:30:27Z |
don't put suspend here
Alan
-----Original Message-----
From: Alexander V.Nevsky [mailto:ded@...]
Sent: Thursday, 12 September 2002 18:11
To: ib-support@yahoogroups.com
Subject: [ib-support] Re: Problems with Firebird 1.0 and Dialect 3
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
Yahoo! Groups Sponsor
ADVERTISEMENT
To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
Alan
-----Original Message-----
From: Alexander V.Nevsky [mailto:ded@...]
Sent: Thursday, 12 September 2002 18:11
To: ib-support@yahoogroups.com
Subject: [ib-support] Re: Problems with Firebird 1.0 and Dialect 3
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
Yahoo! Groups Sponsor
ADVERTISEMENT
To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]