[PHP] FoxPro Table Structure
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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] FoxPro Table Structure
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: http://noferblatz.com/dbfsak.php 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 http://noferblatz.com http://quillandmouse.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] FoxPro Table Structure
On Aug 28, 2012, at 11:32 AM, Paul M Foster pa...@quillandmouse.com 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: http://noferblatz.com/dbfsak.php 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 http://noferblatz.com http://quillandmouse.com 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
Re: [PHP] FoxPro Table Structure
Bastien Koert On 2012-08-28, at 11:52 AM, Floyd Resler fres...@adex-intl.com wrote: On Aug 28, 2012, at 11:32 AM, Paul M Foster pa...@quillandmouse.com 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: http://noferblatz.com/dbfsak.php 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 http://noferblatz.com http://quillandmouse.com 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 Bastien -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php