Update - could not be bound

Last Post 10 Sep 2008 07:19 AM by JASBRYDEN. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
JASBRYDEN
New Member
New Member

--
09 Sep 2008 11:12 AM
Hi

I need help with a code please.

I have two tables.

One that has all the products call "Beltek_products"
the next table has only some of the products call "BTitem"

I want to get all the products from 'Beltek_products" into "BTitem"

This is the code that I have
UPDATE BTITEM
SET BTITEM.ItemNo=dbo.BELTEK_PRODUCTS.ITEMNO,
BTITEM.ACCOUNTINGITEMNO=dbo.BELTEK_PRODUCTS.ITEMNO,
BTITEM.HANDHELDDESC=dbo.BELTEK_PRODUCTS.BELTEK_DESC,
BTITEM.DESCRIPTION=dbo.BELTEK_PRODUCTS.DESCRIPTION,
BTITEM.PRODUCTGROUPNO=dbo.BELTEK_PRODUCTS.PRODUCT_GROUP_NO,
BTITEM.PERCODE=dbo.BELTEK_PRODUCTS.QUANTITYPERPARENT,
BTITEM.DECIMALPLACES='2',
BTITEM.UNITUOM=dbo.BELTEK_PRODUCTS.STOCK_UNIT_OF_MEASURE,
BTITEM.PIECEUOM=dbo.BELTEK_PRODUCTS.STOCK_UNIT_OF_MEASURE,
BTITEM.CHANGEPRICE='T',
BTITEM.TAXABLE1=dbo.BELTEK_PRODUCTS.VAT,
BTITEM.TAXABLE2='F',
BTITEM.TAXABLE3='F',
BTITEM.DEPOSITSTAXABLE='F',
BTITEM.NETPRICEONLY='F',
BTITEM.LINK1CHARGE='F',
BTITEM.LINK2CHARGE='F',
BTITEM.PARTIALQTY='F',
BTITEM.DAYSAVAILABLE='TTTTTTT',
BTITEM.LICENSEREQUIRED='F',
BTITEM.EMPTYPRODUCT='F',
BTITEM.ALLOWFREE='T',
BTITEM.REMITTO='1',
BTITEM.CORPORATE='T',
BTITEM.RETIRED='F',
BTITEM.RETIREDDATE='1900-01-01 00:00:00.000',
BTITEM.WEIGHTFLAG='F',
BTITEM.MultiItem='F',
BTITEM.[SIZE]='CS',
BTITEM.SERIALNO='F',
BTITEM.LOT='F',
BTITEM.DELETED='F',
BTITEM.DATECREATED='2008-05-29 09:49:24.673',
BTITEM.DATEMODIFIED='2008-05-29 09:49:24.673',
BTITEM.[SERVICE]='F',
BTITEM.RANDOMWEIGHTFLAG='F',
BTITEM.USEREWARDPOINTS='F',
BTITEM.SELLPIECESONLY='F',
BTITEM.RETURNONLY='F'
where
from BTITEM
inner join BELTEK_PRODUCTS on BELTEK_PRODUCTS.ITEMNO<>BTITEM.ITEMNO


However it does not seem to work.

Please help
JASBRYDEN
New Member
New Member

--
10 Sep 2008 07:19 AM
Thanks alot man

That work great !!!
You are not authorized to post a reply.

Acceptable Use Policy