DBI and DBF Files
am 20.07.2007 02:30:15 von samuel_zheng------=_NextPart_000_0007_01C7CA43.9D342B90
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi Gurus,
I need your help. I am using active perl 5.8.8, windowsXP second =
edition. I am trying to access an old app by using perl and odbc. I =
created a system DSN in ODBC data source administrator and I tested by =
using crstal report writer. Things are fine. I use DBI (1.58 & dbd-odbc =
is 1.13) through this DSN(odbc) to read an old dBaseIII file, only one =
record can be retrived while there are two in the file. The sql is the =
following:=20
$sql=3D"Select size, color, qty, totship from smtran02 where =
sono=3D'S9190' order by size, color";
$dbh=3DDBI->connect($dsn,$user,$pswrd,$driver,{RaiseError=3D >1}) or die =
"Database connection not made: $DBI::errstr";
$sth =3D $dbh->prepare($sql);
$sth->execute();
do you know any thing about it or any idea how to access an old dBaseIII =
file? Thanks.
Samuel Zheng
------=_NextPart_000_0007_01C7CA43.9D342B90--