Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Verify a TempTable using VFP on SQLServer2000
Message
From
25/02/2008 09:40:45
Bruno Maddalozzo
Informatica Aziendale
Arsie, Italy
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Verify a TempTable using VFP on SQLServer2000
Miscellaneous
Thread ID:
01296055
Message ID:
01296055
Views:
50
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
Next
Reply
Map
View

Click here to load this message in the networking platform