Hi all!
I have a problem with a temp table.
I start creating my table:
bdsqlado.execute ("CREATE TABLE #MyTable ...")
There is no error. The sql string has been tested and when it's
executed in the sql query analyzer it really creates the table.
After creating the table, I execute an insert statement:
bdsqlado.execute ("INSERT INTO #MyTable VALUES(...) "
It returns an error like this: "Invalid Object Name #MyTable"
I don't understand what's wrong. If I execute both sql sentences in
the SQL Query Analyzer it works perfectly.
I use the same connection to execute both statements and I don't close
it before the INSERT is executed.
I think it may be something related to dynamic properties of the
connection, but I'm not sure. It's just an idea.
Please I need help.
Thanks a lot,