Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Improve implicit cursor using like FOR loop of Oracle [CORE2714] #3110

Closed
firebird-automations opened this issue Oct 28, 2009 · 4 comments
Closed

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Montri Patchaiyo (k1)

Duplicates CORE4403

Add to support implicit cursor using like Oracle
for example:
FOR X IN (
SELECT statement
) DO
BEGIN
IF (X.F1 > 0) THEN
INSERT INTO TABLE2 (
F1, F2, F3
) VALUES (
X.F1, X.F2, X.F3);
END

It's good to be reduced a many declaration of local variable.
For example:
AS
DECLARE VARIABLE V1 INTEGER;
DECLARE VARIABLE V2 INTEGER;
DECLARE VARIABLE V3 INTEGER;
...
DECLARE VARIABLE Vn INTEGER;
BEGIN
FOR
SELECT
F1, F2, F3, ..., Fn
FROM
TABLEX
INTO
V1, V2, V3, ..., Vn
DO
...
END

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Link: This issue duplicates CORE4403 [ CORE4403 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

Closed in favor of CORE4403.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Duplicate [ 3 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant