1. Home
  2. Point-Of-Sale Software
  3. Updating the item.picturename column

Updating the item.picturename column

Hi all ~

I'm trying to update the picturename column:

UPDATE ITEM SET ITEM.PictureName=IMAGES$.PICTURE

--ITEM.ExtendedDescription=SHEET1$.Ext_Discription FROM DBO.IMAGES$,ITEM WHERE ITEM.ITEMLOOKUPCODE=IMAGES$.UPC

I recevied the folowing error: Server: Msg 8114, Level 16, State 5, Line 1 Error converting data type nvarchar to float.

But both columns, ITEM.PictureName=IMAGES$.PICTURE, are nvarchar data types.

Any ideas?

Reply to
Jerry
Loading thread data ...

hi Jerry, if you think that you are tyring to update the picture i.e. BMP or JPG then it is not correct you need to update the path of the picture or file name of the picture to Picturename field. as picture will stores in file system not in database. and this is the reason you are geting error.

"Jerry" wrote:

Reply to
Akber Alwani

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.