#!/usr/bin/perl
# Fig. 15.21: fig15_21.pl
# Program to delete a record from the database

use warnings;
use strict;
use DBI;
use DBD::ODBC;

my $dbh = DBI->connect( "dbi:ODBC:employeeDB", "", "", 
                        { RaiseError => 1 } );
 
print( "Enter the Employee ID number of the record ",
       "you wish to delete: " ); 
chomp( my $IDdel = <STDIN> );
print( "Delete this record: ($IDdel)? (Y/N) " );
chomp( my $choice = <STDIN> );

if ( $choice eq 'Y' || $choice eq 'y' ) {
   my $query = "DELETE FROM employee " .
               "WHERE EmployeeID = '$IDdel'";
   print( "$query \n\n" );
   $dbh->do( $query ); 
}

my $sth = $dbh->prepare( q{ select * FROM employee } );

$sth->execute();

my @array;

while ( @array = $sth->fetchrow_array() ) {
   write( STDOUT );
}

# Clean up
warn( $DBI::errstr ) if $DBI::err;
$dbh->disconnect();
$sth->finish();

format STDOUT =
@<<<<<<@<<<<<<<<<@<<<<<<<<<<@<<<<<@<<<<<<<<<<<
$array[ 0 ], $array[ 1 ], $array[ 2 ], $array[ 3 ], $array[ 4 ]
.


###########################################################################
#  (C) Copyright 2001 by Deitel & Associates, Inc. and Prentice Hall.     #
#  All Rights Reserved.                                                   #
#                                                                         #
#  DISCLAIMER: The authors and publisher of this book have used their     #
#  best efforts in preparing the book. These efforts include the          #
#  development, research, and testing of the theories and programs        #
#  to determine their effectiveness. The authors and publisher make       #
#  no warranty of any kind, expressed or implied, with regard to these    #
#  programs or to the documentation contained in these books. The authors #
#  and publisher shall not be liable in any event for incidental or       #
#  consequential damages in connection with, or arising out of, the       #
#  furnishing, performance, or use of these programs.                     #
###########################################################################