Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Setting Extended Properties in SQL Server
Message
De
12/01/2010 17:31:38
Bill Drew
Independent Consultant
Chicago, Illinois, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Setting Extended Properties in SQL Server
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01443553
Message ID:
01443553
Vues:
92
Can anyone spot any problems with the following command which I use to add meta data to a SQL Server table?

cdescription = [']+ALLTRIM(adstruct.definition)+[']

colname = [']+ALLTRIM(adstruct.field_name)+[']

lnRet = SQLEXEC(handle28,[execute sp_addExtendedProperty 'Description',];
+cdescription+[,'schema','dbo', 'table', 'recentclaimdet', 'column', ]+colname)

I had it working but now I must have introduced a bug that I can't see. Always returns minus 1.
Handle is a valid handle.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform