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