Subject | Insert rows in a cursor |
---|---|
Author | Frank Bustos Cortés |
Post date | 2002-12-12T17:10:43Z |
Hi all,
I'm newbie using Firebird, but this group has been a great help...
but I have a problem, and I have not found the answer... I need
insert a rows in a cursor, because I have 2 different conditions that
return the same structure. For example:
Cursor 1:
for select Field1,Field2,Field3
from Table1
left join Table2 ...
where Cond1 ...
into :C1,:C2,:C3
do
Cursor 2:
for select Field1,Field2,Field3
from Table1
left join Table3 ...
where Cond2 ...
into :C1,:C2,:C3
do
It's not as simple as to fuse the conditions, because this it's a
general example, but the idea is to unite the result the Cursor 1
with the result the Cursor 2
Thank's for your help, and they excuse my grammar lack
Frank Bustos
Chile
I'm newbie using Firebird, but this group has been a great help...
but I have a problem, and I have not found the answer... I need
insert a rows in a cursor, because I have 2 different conditions that
return the same structure. For example:
Cursor 1:
for select Field1,Field2,Field3
from Table1
left join Table2 ...
where Cond1 ...
into :C1,:C2,:C3
do
Cursor 2:
for select Field1,Field2,Field3
from Table1
left join Table3 ...
where Cond2 ...
into :C1,:C2,:C3
do
It's not as simple as to fuse the conditions, because this it's a
general example, but the idea is to unite the result the Cursor 1
with the result the Cursor 2
Thank's for your help, and they excuse my grammar lack
Frank Bustos
Chile