Hi ,
I'am trying to create a query with dynamic columns:

ALTER PROCEDURE "DBA"."DynamicTest"( in col varchar(50) )

BEGIN

declare @str varchar(1000);
set @str='select '+col+' from tblB;
execute immediate @str;

END

But iam getting an error:
You attempted to execute a SELECT statement in a context where a
result set is not permitted.
What am i doing wrong ?

Janis

Ok, i figure it out myself, I forgot to put the result into a
temptable BUT i dont want my query in a temporary table , I just want
a stored procedure where I can put dynamic columnnames and get the
results by calling the stored proc.

janis wrote:
What version of SQL Anywhere are you using? Starting at v901, the
execute immediate command includes a "WITH RESULT SET" clause that
sounds like it will suit your needs.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Please reply only to the newsgroup

Documentation : Exercise your WRITE @DocCommentXchange: DCX.sybase.com
SQL Anywhere Patches and EBFs : http://downloads.sybase.com/swd/base.do
-> Choose SQL Anywhere
-> Optionally set filter to "Display ALL platforms IN ALL MONTHS"