开发者

Microsoft Sync framework issue, Data not synced fully for a SqlDbType.Text field

开发者 https://www.devze.com 2023-04-08 08:55 出处:网络
I have a table with one of itscolumn ADDRESS开发者_运维问答 with datatype Text . When I sync the data from client to sever all other column values sync properly but only first 16 characters get synced

I have a table with one of its column ADDRESS开发者_运维问答 with datatype Text . When I sync the data from client to sever all other column values sync properly but only first 16 characters get synced for ADDRESS column .

I checked in Data access layer of my sync application , Both ApplyInsert and ApplyUpdate command parameters have the size of 1000 for that field.

SAMPLE_TABLEApplyInsertCmd.Parameters.Add("@ASC_ADDRESS", SqlDbType.Text, 1000);

and

SAMPLE_TABLEApplyUpdateCmd.Parameters.Add("@ASC_ADDRESS", SqlDbType.Text, 1000);

In ApplyInsert and ApplyUpdate the parameter specified as

@ASC_ADDRESS Text=NULL

Can anyone see and suggest what i have done wrong ?

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号