Help for this page

Select Code to Download


  1. or download this
    $q="SELECT order_bill_n, srok_date FROM orders WHERE ALLTRIM(UPPER(ord
    +er_bill_n)) LIKE '%22134%'  order by order_bill_n desc ";
                            
        $sthfox=$dbhfox->prepare($q, { ado_cursortype => 'adOpenForwardOnl
    +y' }) or die "Can't prepare statement: $DBI::errstr";
        $sthfox->execute() or die "Can't execute statement: $DBI::errstr";
    
  2. or download this
    OLE exception from "Microsoft OLE DB Provider for Visual FoxPro":\r
    [error] \r
    ...
    Win32::OLE(0.1704) error 0x80004005: "Unspecified error"\r
    in METHOD/PROPERTYGET "Open" at D:/usr/local/bin/perl/site/lib/DBD/ADO
    +.pm line 1136\r
    DBD::ADO::st execute failed: Can't Open Recordset for 'SELECT order_bi
    +ll_n, srok_date FROM orders WHERE ALLTRIM(UPPER(order_bill_n)) LIKE '
    +%22134%'  order by order_bill_n desc '\r