1

Topic: fb3. for execute statement and as cursor

Dock states that "Operator FOR EXECUTE STATEMENT is used (by analogy to construction FOR
SELECT) for SELECT statements or EXECUTE BLOCK, returning more single line."
For for select are thus admissible  cursors, and for for execute statement for some reason is not present.
Example: it works

for select T.F1, T.F2. T.Fn from TABLE T
as cursor c do
begin
...
end

, And it

for execute statement (' T.F1, T.F2. T.Fn from TABLE T ')
as cursor c do
begin
...
end

Already is not present

Invalid token.
Dynamic SQL Error.
SQL error code =-104.
Token unknown - line x, column 6.
cursor

the question - dock does not finish speaking or a bug?

2

Re: fb3. for execute statement and as cursor

Gray-gray ;
Someone does not finish speaking a word select.

3

Re: fb3. for execute statement and as cursor

I at all will not remember, that ES supported as cursor.

4

Re: fb3. for execute statement and as cursor

Gray-gray ;
And unless and documentation it is written that for execute statement... as cursor should work?
Is not present it is not written, means should not. smile
And if logically to reason type (internal fields) cursor are defined at a stage prepare or compilations  of that it is not possible with dynamic creation SQL

5

Re: fb3. for execute statement and as cursor

Gray-gray ;
My God, what  people invent...

6

Re: fb3. for execute statement and as cursor

kdv wrote:

gray-gray ;
My God, what  people invent...

It is a progress motive power.

7

Re: fb3. for execute statement and as cursor

kdv wrote:

My God what  people invent...

In what ? In desire of identical conveniences let in different it is formal, but thus the extremely similar (identical it is real) usage variants?
Well, to me laziness  variables of a current for  which there and then to go in . And me  that this  comes from other DB. And  the spherical cursor in vacuum it is not provided for a similar context.