Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursorgetprop('Fields')
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00640440
Message ID:
00641256
Views:
18
>CURSORGETPROP('UpdateNameList') returns all fields of a view

Actually, not quite -- it only returns fields where the back end field name doesn't match the front end field name. You can see this if you query against SQL Server's pubs and Northwind databases -- the pubs fields don't show up in UpdateNameList, but the Northwind fields do.

Or at least, the mixed case ones do. Want to take a guess at how long it took to figure out this was the issue? :-)

(Caveat -- no SQL Server on this machine to double-check the above.)
My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform