Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to retrieve view-names from dbc?

Status
Not open for further replies.
Nifrabar

Nifrabar

Programmer
Mar 16, 2003
1,343
NL
Hi,
I know this is possible but don't know the syntax for it.
I like to extract a list with the names of all views which are in a database.
Anyone who can tell me how to?
KR
-Bart
 
Sort by date Sort by votes
Code: 
open database ...
adbobjects(laViews,"VIEW")

results in an array of viewnames.

Bye, Olaf.
 
Upvote 0 Downvote
Code: 
OPEN DATABASE YOURDB
SET DATABASE TO YOURDB
ADBOBJECTS(laViews,[VIEW])
DISPLAY MEMORY LIKE laViews

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
Microsoft MVP VFP
 
Upvote 0 Downvote
Olaf and Bissov, thanks for fast respond!
-Bart
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

SitesMasstec
  • Question
Copy fields from one table to another
Replies
8
Views
98
Joe Crescenzi
Joe Crescenzi
german12
  • Locked
  • Question
How to sent a search term from VFP to Foxit-Reader 5
Replies
9
Views
392
german12
german12
Dronner
  • Locked
  • Question
How to display photos from Visual Foxpro 6? 2
2
Replies
23
Views
996
sedenter
sedenter
german12
  • Locked
  • Question
Transferring the names of text files to a *.dbf file 1
Replies
5
Views
355
german12
german12
Don Child
  • Locked
  • Question
Are the longer field names in a dbc container accessible from the Repl/Dot Prompt? 3
Replies
12
Views
256
Don Child
Don Child

Part and Inventory Search

Sponsor

Back
Top