Problem: The goal is to do a simple INSERT
query using the DBI and sqlite. Everything works
as expected when a *single* insert query is submitted.
However, when a *compound* query is submitted (using
BEGIN TRANSACTION syntax) the attempted operation
does not work.
Request: Does anyone have a working barebones snippet of
code that shows how to do a compound query using the latest
development release of sqlite and perl DBI?
### This code no worky as expected ...
### anyone have a working alternative?
### begin_: init perl
use strict;
use warnings;
use DBI;
### begin_: init vars
my $dbh;
my $oStt;
my $oData;
my $sQry000;
my $sDbsUrl = "test.db";
### p__: compound INSERT query
$sQry000 =
q^
BEGIN TRANSACTION;
INSERT INTO user ('fname','lname')
VALUES ('mickey','mouse');
INSERT INTO user ('fname','lname')
VALUES ('donald','duck');
COMMIT;
^;
### p__: run the query
$dbh = DBI->connect( "dbi:SQLite:$sDbsUrl" )
|| die "Cannot connect: $DBI::errstr";
$oStt = $dbh->prepare($sQry000);
$oStt->execute();
=oQDlNWYsBHI5JXZ2VGIulGIlJXYgQkUPxEIlhGdgY2bgMXZ5VGIlhGV