the problem is that the declaration of the cursor is stored in a database
> In order to get any column from a table we would use a
> cursor that's rite,
!!!!!Problem - the declaration is stored in a database, so i'm trying sth
like declare cursor cur1 for 'string variable'
> declare cursor CUR1 for
> select sql_query_col from sometable;
> open CUR1
> -- SQL statments
> >-----Original Message-----
> >i have one field in a table which represents an sql
> command and i want to
> >associate the string from it to a cursor. After that open
> the cursor and use
> >it. The problem is that the following appears:
> stored in an other
> >'Operand type clash: varchar is incompatible with cursor'
> >So, how can i extract some sql command from a table and
> execute it, and
> >after that use the rows it returns (i cant use exec as
> well because i cant
> >get the result that way)
> >thank you very much!!