Bastien Koert

On 2012-08-28, at 11:52 AM, Floyd Resler <> wrote:

> On Aug 28, 2012, at 11:32 AM, Paul M Foster <> wrote:
>> On Tue, Aug 28, 2012 at 10:46:24AM -0400, Floyd Resler wrote:
>>> Is there a way in PHP to get the structure of a FoxPro table (using
>>> ODBC) without having to query the table?  I know I can get it by
>>> getting a row from the table and using odbc_field_type but I'd rather
>>> not have to query an entire table since there is no LIMIT command in
>>> FoxPro.  I've looked and looked and haven't found a solution.
>>> Thanks!  Floyd
>> FoxPro tables have a header which details the structure of the rows
>> which follow it. I've never written PHP code to do what you're asking,
>> but I did write a C program which will detail the header, dump the
>> records, output the table as SQL and a variety of other things,
>> depending on the command line switches. I generally use it *with* PHP,
>> using a system() call, capture the results, and then display them on
>> screen as needed. The code is on SourceForge. See:
>> If you download the code and need help, just let me know. I believe the
>> command line switch you're looking for is -i, as in:
>> dbfsak -i mytable.dbf
>> Paul
>> -- 
>> Paul M. Foster
> Paul,
>    Thanks for the info.  Unfortunately dbfsak won't work for me since I don't 
> have direct access to the ForPro dbf files.  I access them through an 
> odbc-odbc bridge server.
> Thanks!
> Floyd

Could you do a query like

Select * from table where 1=2

That should only return the header row 

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to