Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Setting Extended Properties in SQL Server
Message
From
12/01/2010 17:31:38
Bill Drew
Independent Consultant
Chicago, Illinois, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Setting Extended Properties in SQL Server
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01443553
Message ID:
01443553
Views:
93
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.
Next
Reply
Map
View

Click here to load this message in the networking platform