I want to build a query at runtime in Fox and pass it back to Sql Server via a cursor adapter or a SqlExec(). In that query I build at runtime I want to join to a temporary table(s) that I created via a stored procedure only a few commands before I execute the query call ( .Fill or SqlExec() ) while on the same connection handle. I get an error that the temp table is not an object.

Can something like this not be done? We are having to keep control of our query construction in the middle tier since we allow user input at runtime as to filters and column selection but based on what columns they choose we may have to build some "calculated cursors" prior to the main query that we join back into for supplying values for columns as opposed to calling functions in the select clause ( we found this a big performance boost in Fox ).

On a side note is calling functions in the select clause in Sql just as costly as in Fox?

Thanks,

MW