Stored Procedure w/returned named columns...
Does anyone know how to get a stored procedure to return column names
when executed? When I return a value, dbaccess will show (expression)
as the column name. I'd like to be able to return column names for
readability.
Example of problem:
Create Procedure test() returning char(10), char(10);
return "Hello", "World";
End Procedure;
Now run the following...
execute procedure test();
This should produce in dbaccess:
(expression) Hello
(expression) World