Re: DBACCESS and Stored-Procedure

Philippe Juillot wrote: > > Hello ! > > We have a problem with headlines from a stored procedure in DBACCESS. > For example: > > with the statement > > SELECT name, age alter > FROM person > WHERE emp_no < 20;> > we have this headline: 'name' 'alter'. > > with the stored procedure > > CREATE PROCEDURE test(num INTEGER) > RETURNING CHAR(30), INTEGER;> DEFINE n CHAR(30); > DEFINE d INTEGER; > FOREACH > SELECT name, age > INTO n, d > FROM person > WHERE emp_no < num > RETURN n, d WITH RESUME;> END FOREACH; > END PROCEDURE; > > we have always this headline: '(expression)' '(expression)' > > Is it possible to choose the headline, like in the first > Select-statement with a stored procedure ? Not possible. One common work around is to create and populate a temp table with the stored procedure with the expected column names and then to SELECT from the temp table in the main applications/script. Art S. Kagel