Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Comparing .dbf stuctures
Message
From
13/11/2001 11:08:41
 
 
To
13/11/2001 09:56:51
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00580858
Message ID:
00580908
Views:
18
Dennis,

Firstly, you can now modfify a message you created as long as no-one has replied to it.

Secondly...
The way I do what you require is by using a data dictionary, this defines the exact structure of all the tables in the database, they are all checked before going into the system (we have had users opening a table in Excel, making a column wider or narrower then saving.. this breaks the CDX link and modifies the table structure - urghh)

If you wanted, you could verify this info against the dbf header but you would need to analyse the structure of the dbf in detail first..

Just a thought, you could have a memo field with the correct header info and compare it with the dbf (but remember there are certain parts of the header which change each time you add a record, there are table lock flags, record counts and maybe more)

It may be worth looking around to see if you can find a definition of a .dbf header.. I'm sure there must be one somewhere in a foxpro advisor article (although I have never seen one)

HTH

Will

>Apologies
>
>AFIELDS(laTemp,ALIAS())
>
>missing from original post
Will Jones
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform