Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Verify a TempTable using VFP on SQLServer2000
Message
De
25/02/2008 09:40:45
Bruno Maddalozzo
Informatica Aziendale
Arsie, Italie
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Verify a TempTable using VFP on SQLServer2000
Divers
Thread ID:
01296055
Message ID:
01296055
Vues:
51
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform