Hello Everybody !

I'm working with FOXPRO 9 against a maxdb database !
ODBC with SQL-Passthrough

L_cmd="Select .... from ...."
sqlexec(connection,l_cmd,"mycursor)

Now i have a problem with temporary resultcursors in the maxdb

I create a temporary cursor with a complex recursive select and want to use this cursor for another sql-command

l_cmd="create complexcursor as select ..... FOR REUSE"
sqlexec(connection,l_cmd)

l_cmd="update table xxx set yyy = 'A' where tablekey in (select tablekey from complexcursor)"
sqlexec(connection,l_cmd)

error: unkown table complexcursor

The MAxDB-Folks told me that the syntax for creating the complexcursor is ok and normaly it has to be there, but
some programming languages will do some "clearing" before each task ???!!!

Can someone explain me, what foxpro does with a sequence of sqlexecutes
Is there any kind of "clearing" befor passing a new command to the database ??????

Any help welcomed
Best regards
Albert