RE: Error writing to double using ODBC

2005-09-22 Thread Jeff Urlwin
: Tue 9/20/2005 8:11 AM To: dbi-users@perl.org Subject: Error writing to double using ODBC I'm having trouble writing to columns of type DOUBLE using ODBC (to Pervasive.SQL) $dbh = DBI-connect('dbi:ODBC:DEMODATA','','',{RaiseError = 1, PrintError =1}) or die $DBI::errstr; $sth=$dbh-prepare

Error writing to double using ODBC

2005-09-20 Thread Wim Livens
I'm having trouble writing to columns of type DOUBLE using ODBC (to Pervasive.SQL) $dbh = DBI-connect('dbi:ODBC:DEMODATA','','',{RaiseError = 1, PrintError =1}) or die $DBI::errstr; $sth=$dbh-prepare(update mytable set mycolumn=? where id=123) || die $DBI::errstr; $value=3/2;