Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Rick C. Hodgin
  Where is Rick C. Hodgin?
 Indianapolis
 Indiana - United States
 Rick C. Hodgin
 To: Eddie Ruiz
  Where is Eddie Ruiz?
 Hawthorne
 United States
 Eddie Ruiz
 Tags
Subject: RE: How to figure the fields in a dbf
Thread ID: 373782 Message ID: 373783 # Views: 79 # Ratings: 2
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Wednesday, March 27, 2013 12:52:29 AM         
   


> Hi, is there a way to find out how many fields a dbf have? Normally i do use inv.dbf then i click on browse and count the fields like that but it takes time. Is there a easier way to do this with a command on vfp9 command prompt?
>
> Thanks



There are functions which return that information. FCOUNT() indicates how many fields there are. You can also use AFIELDS() to get not only the return count (number of fields), but also far more detailed information about each field.

I don't know of an easy way to do it through a dialogue or file selection box, however.

Best regards,
Rick C. Hodgin

ENTIRE THREAD

How to figure the fields in a dbf Posted by Luis DeGante @ 3/27/2013 12:44:56 AM
RE: How to figure the fields in a dbf Posted by Rick Hodgin @ 3/27/2013 12:52:29 AM
RE: How to figure the fields in a dbf Posted by Tamar Granor @ 3/27/2013 9:41:36 PM