Check thread Forum: Visual FoxPro Category: Coding, syntax & commands Title: Re: Compare Structures of 2 Tables Tip Thread #579912

>I need to check the structure of a dbf so that a user can open a table if the structures is correct.
>
>The current code uses 2 criteria, the existence of a specific logical field and the total no of fields.
>
>In practice this works fine excepting that the table needs to be opened to perform the validation.
>
>lValidTable = .F. && Return value
>
>IF ASCAN(laTemp,[PROJECT_2]) > 0 AND ALEN(laTemp,1) = 20 && Check for logical field & total fields
> lValidTable = .T. && Return value
>ENDI
>
>If there any better way of doing this validation through examining the .dbf header file for example?
>
>TIA
>
>Dennis