Subject | Stored procedures |
---|---|
Author | Andre Dostal |
Post date | 2005-04-07T09:06:56Z |
Hi,
I've made my first steps with stored procedures. The documentation
provides some simple examples like:
ALTER PROCEDURE "F_GET_ID"
RETURNS
(
"id" INTEGER
)
AS
BEGIN
"id" = 1234567890;
END
There is no syntax error, but I get no result set. So I read a little
bit more the manual and find "suspend", and now:
ALTER PROCEDURE "F_GET_ID"
RETURNS
(
"id" INTEGER
)
AS
BEGIN
"id" = 1234567890;
suspend; <<--------
END
it works.
My Question: are all examples that I found wrong, or did I some mistakes?
Best regards
André Dostal
I've made my first steps with stored procedures. The documentation
provides some simple examples like:
ALTER PROCEDURE "F_GET_ID"
RETURNS
(
"id" INTEGER
)
AS
BEGIN
"id" = 1234567890;
END
There is no syntax error, but I get no result set. So I read a little
bit more the manual and find "suspend", and now:
ALTER PROCEDURE "F_GET_ID"
RETURNS
(
"id" INTEGER
)
AS
BEGIN
"id" = 1234567890;
suspend; <<--------
END
it works.
My Question: are all examples that I found wrong, or did I some mistakes?
Best regards
André Dostal