Help for this page

Select Code to Download


  1. or download this
    $lsth = $dbh2->do("INSERT INTO dbo.ICITEM(ITEMNO,AUDTDATE,AUDTTIME,AUD
    +TUSER,AUDTORG,ALTSET,\"DESC\",DATELASTMN,INACTIVE,ITEMBRKID,FMTITEMNO
    +,CATEGORY,CNTLACCT,STOCKITEM,STOCKUNIT,DEFPRICLST,UNITWGT,PICKINGSEQ,
    +SERIALNO,COMMODIM,DATEINACTV,SEGMENT1,SEGMENT2,SEGMENT3,SEGMENT4,SEGM
    +ENT5,SEGMENT6,SEGMENT7,SEGMENT8,SEGMENT9,SEGMENT10,COMMENT1,COMMENT2,
    +COMMENT3,COMMENT4,ALLOWONWEB,KITTING,\"VALUES\",DEFKITNO,SELLABLE,WEI
    +GHTUNIT,SERIALMASK,NEXTSERFMT,SUSEEXPDAY,SEXPDAYS,SDIFQTYOK,SVALUES,S
    +WARYCODE,SCONTCODE,SCONTRECE,SWARYSOLD,SWARYREG,LOTITEM,LOTMASK,NEXTL
    +OTFMT,LUSEEXPDAY,LEXPDAYS,LUSEQRNDAY,LQRNDAYS,LDIFQTYOK,LVALUES,LWARY
    +CODE,LCONTCODE,LCONTRECE,LWARYSOLD) VALUES('$vendpartno', '$gmtyear$g
    +mtmon$gmtmday', '$gmthour$gmtmin$gmtsec$gmtfsec', '$audtuser', '$audt
    +org', '0', '$itemdesc', '$gmtyear$gmtmon$gmtmday', '0', '$itemtypeid'
    +, '$vendpartno', '$categorycode', '$controlacct', '1', '$itemunit', '
    +$pricelist', '$itemwgt', '1', '0', '', '0', '$vendpartno', '', '', ''
    +, '', '', '', '', '', '', '$comment1', '$comment2', '$comment3', '$co
    +mment4', '1', '0', '2', '', '1', '', '', '', '0', '0', '0', '0', '', 
    +'', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '', '',
    + '0', '0')") or &bail($dbh2->errstr);