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?
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:
hi Jerry I have previously posted about these tables. here is the link:
AccountReceivable AccountReceivableHistory Batch Register C> Hi all ~
Have something to add? Share your thoughts — no account required.
Ask the community — no account required