I just ran this code, which worked with the expected results:

use DBDI;
my $conn = DBDI::DriverManager.getConnection("dbdi:SQLite3:test.db", "",
"");
my $stm = $conn.createStatement();
my $rs = $stm.executeUpdate("CREATE TABLE foo (bar, baz)");
my $stm = $conn.prepareStatement("INSERT INTO foo (bar, baz) VALUES (?,
?)");
$stm.setColumn(1, 123);
$stm.setColumn(2, "Thingy");
$stm.executeUpdate();

Merry Christmas,
Simon

Reply via email to