Update record with OLE connection : update « Database « Perl

Home
Perl
1.Array
2.CGI
3.Class
4.Data Type
5.Database
6.File
7.GUI
8.Hash
9.Language Basics
10.Network
11.Regular Expression
12.Report
13.Statement
14.String
15.Subroutine
16.System Functions
17.Win32
18.XML
Perl » Database » update 
Update record with OLE connection
   

#!c:/perl/bin

use Win32::OLE;
use Win32::OLE::Const 'Microsoft ActiveX Data Objects';

$table = "addresstable";
$conn = Win32::OLE->new("ADODB.Connection");
$rs   = Win32::OLE->new("ADODB.Recordset");

$conn->Open("address");
$conn->Execute("UPDATE $table SET address='A' WHERE firstname='A'");

print "Content-type: text/html\n\n";
print "Record Updated ...";

$rs->Close;
$conn->Close;

   
    
    
  
Related examples in the same category
1.Update a record in the database
2.Update statement and DBI ODBC connection
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.