Yes, this is the way I adopted:
SQLEXEC(lnActiveConnection,"SELECT object_id('tempdb..#TempQuery')","LocalCursor")
If Isnull(LocalCursor.Exp)
SQLEXEC(lnActiveConnection,"create table #TempQuery ID char(36) PRIMARY KEY)")
Endif
Thank you very much Sergey and Naomi.
Bruno
>
>IF object_id('tempdb..#TempQuery') IS NOT NULL
>
>
>>I've the need to create a TempTable in SQL server, if that TempTable doesn't exist yet.
>>
>>I can create it with:
>>SQLEXEC(lnActiveConnection,"create table #TempQuery ID char(36) PRIMARY KEY)")
>>
>>but I can't verify its existence neither with:
>>SQLEXEC(lnActiveConnection,"EXEC sp_tables @table_name = '#TempQuery';")
>>(the statement return 0 records) nor with:
>>SQLEXEC(lnActiveConnection,"EXEC sp_tables @table_name = '#TempQuery', @table_owner = 'dbo', @table_qualifier = 'tempdb';")
>>(this statement return -1).
>>
>>How to get the information?
>>TIA
>>Bruno Maddalozzo