Hello,

> I´ve got problems using a cursor.
>
> Syntax is like:
>
> FOR select a.field1, a.field2, b.field3
> from tab1 a, tab2 b
> where a.id = b.id
> and crit1 = '1002'
> and ...
> group by a.field1, a.field2, b.field3
> into :v_field1, v:field2, :v_field3 DO
>
> begin
> insert into new_tab
> (field1, field2, field3)
> values
> (:v_field1, v:field2, :v_field3);
> end
> end
>
> As long as crit1 is given there´s no problem. As soon as I select all
> values this proc doesn´t work anymore and nothing is written into new_tab.

How do you "select all values" without a "crit1"?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com