April 27, 2007 at 9:49 am
Hi all,
I got this stored procedure, a simple update.
I am executing it from some .NET code. It doesn't throw errors, parameters are initialized as they're supposed to be, and the query affect 1 row as expected (I investigated about all this stuff running several debug sessions).
Problem is... record is not updated.
I have the feeling that image data type (@File) is messing everything up - (don't like that datatype but I gotta do some mainteinment on an old application).
Hope someone can help!
Cheers,
Giovanni
ALTER
PROCEDURE [dbo].[p_QualityIAAttachments_Update]
(
@AttachmentID
int
,@UpdatedBy nvarchar(25)
,@ContentType nvarchar(50)
,@File image
,@Description nvarchar(200)
)
AS
Update
tbl_QualityIA_Attachments
set
[Updated By]
= @UpdatedBy
,Type = @ContentType
,[File] = @File
,[Description] = @Description
where
AttachmentID
= @AttachmentID
April 27, 2007 at 11:25 am
copied from BOL:
To replace or modify large blocks of text, ntext, or image data, use WRITETEXT or UPDATETEXT instead of the UPDATE statement.
April 27, 2007 at 1:29 pm
Thanks,
now it works!
Cheers,
Giovanni
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply