in reply to Re: Compound Sql Statement
in thread Compound Sql Statement

I have tried the statements and get an error stating, "Can't call method "execute" on an undefined value". I assembled the sql by looking at examples. I am using an access database.

Replies are listed 'Best First'.
Re^3: Compound Sql Statement
by sgifford (Prior) on Feb 25, 2005 at 15:16 UTC
    Check if your prepare method call fails, and if so, see what the error is:
    my $loadHandle = $dbh->prepare("$sql; $nextsql; $lastsql") or die "Couldn't prepare statement: ",$dbh->errstr,"\n";