Please try issuing another fetchrow_array, if the $sth->err is SQL-01S01, just to see. It could be that you can safely 'ignore' this error and use it as a warning.
Jeff ________________________________ From: Yongming Xu [mailto:[EMAIL PROTECTED] Sent: Monday, December 12, 2005 4:41 PM To: Jeff Urlwin Subject: Re: DBD-ODBC-1.13 --FOXPRO fetchrow_array question Jeff, Here is the error spooled on the screen: Z:\pl\dnd>perl odbctest.pl DBD::ODBC::st fetchrow_array failed: [Microsoft][ODBC Visual FoxPro Driver]Error in row (SQL-01S01) [Microsoft][ODBC Visual FoxPro Driver]Error: Column 3 ( convertednotional ) (SQL-22003)(DBD: st_fetch/SQLFetch err=-1) a t odbctest.pl line 61. I attached the test perl DBI script and trace level 9 file for your review. In the test script, I didn't try to issue fatchrow_array after the fail as I posted in my original question. thanks very much for your help. yongming On 12/12/05, Jeff Urlwin <[EMAIL PROTECTED]> wrote: I'm guessing not. I see an error and I'm guessing that it detects the column type is not correct. Can you set DBI->trace to 9 and send me the output? Jeff -----Original Message----- From: yongming [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 06, 2005 9:36 PM To: [EMAIL PROTECTED] Subject: DBD-ODBC-1.13 --FOXPRO fetchrow_array question Hello Jeff, I am using the ODBC DBI to access FOXPRO (visual foxpro 6) tables. Somehow in one table some numberical fields mix numerical data with string like "***,***,***". The fetchrow_array method will fail on that row and I won't be able to fetch the next row with the same select statement. When I try to browse the data using WINSQL with the same ODBC driver, I will get the offending row with those fields filled with "error" togather with the rest of the result set. I am just wondering if the DBD-OBDC module can allow me to do the same thing as the WINSQL does: still return the offending rows and allow me to fetch the next row with the same sql statement. Thank you for your help. Cheers, Yongming -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.13.11/191 - Release Date: 12/2/2005