Hi,

> Is there a way to enumerate fields in the result set of a select
> statement in a procedure? I have a table with 20+ fields, and want to
> return them one by one:
>
> for select * from tablename do
> for each field in result_set do
> begin
> resultvariable=field.value;
> suspend;
> end
>
> alternatively,
>
> select * from tablename into :my_array
> for each field in my_array do
> begin
> resultvariable=field.value;
> suspend;
> end
>
>
> Is something like this possible?

No - not at all.

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."