DBF structure

[capri1966]

Hi. Where i can find the dbf tables structure ?

 

[Mike Lewis]

In the Visual Foxpro Help file, in the topic entitled "Table File Structure".

From the Help file's Contents tab, drill down to Reference / General Reference / File Structures / Table File Structure.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[Chris Miller]

Maybe Mike gave you exactly what you want, maybe you just would like to find out the composition of a table, then COPY STRUCTURE EXTENDDED give you a cursor with the meta data about a given DBF and you can use AFIELDS() of a workarea to get an array, that is described in the AFIELDS help topic, and that can also be used to create a similar table with CREATE TABLE FROM ARRAY, which should not be confused with APPEND FROM ARRAY.

I like the double usage the array can have, because you can for example remove trigger calls , widen or narrow a char field, remove a field (by deleting its array row with ADEL) and then create a modified table.

COPY STRUCTURE without EXTENDED just creates a structural clone table, just empty. And then there is DISPLAY STRUCTURE, which outputs slightly other info about a workarea, including reccount, for example.


Chriss