Re: Column Names return by Stored Procedure

Art S. Kagel wrote: > > Steve Barrett wrote: > > > > Our stored procedures are returning rows and columns as we expect them > > to but all the column names are "(expression)". Anyone know what we are > > doing wrong (or just not doing)? > > Nothing. The results of a stored procedure have no column names for > dbaccess to report so it just says: (expression). You can create an > explicit temp table with the column names you want to display then: > > insert into mytemp > execute procedure fred(); Sorry my mouse slipped. To continue: Then you can select from the temp table for display with appropriate column names. Art S. Kagel