Memo Field Truncated after execution UPDATE Statement

I'm facing a strange problem. I create a simple Update Statement in my DataSet. I already checked some forums but I'm not able to find the answer. I'm not using any complecated statements; so no GROUP BY or ORDER BY ...

I'm just updating the content of a page with following statement :

UPDATE PAGE
SET CONTENT = ?
WHERE (PAGE = ?)

Select Statement

SELECT PAGE, TITLE, CONTENT
FROM PAGE
WHERE (PAGE = ?)

When I'm executing this in the TableAdapter Configuration Wizard, everything is going just fine but when I'm updating this via my website my field is truncated until +/- 255 characters (I didn't cound them but I'm assuming this because when I change
the layout of the text It's truncated on a different place. )

I did some debugging & the content is always complete in the coding, but in the update statement it's truncated to 255 characters.

I'm using a FormView to see the PageContent & the Editor from Obout to Edit my text.

Can somebody explain me what I'm doing wrong and how I can solve this?

Re: Memo Field Truncated after execution UPDATE Statement

I don't think that's the issue (the length of the field of the database) A memo field can contain up till 64 000 characters (I'm using +/- 1000) so this should be OK. Limitation of the text box or area isn't negotiable. Somebody other suggestions?

Re: Memo Field Truncated after execution UPDATE Statement

Anneleen Verstreken

Can somebody please help me because the deadline is monday 28th of september and this is a really important issue!

I would like to help but I can't reproduce what you're experiencing! I know that there's a truncating problem when using build in Access (or better said Jet) functions, so you should always retrieve a memo field complete and then do the truncate in VB.NET
or C#. But I never heard of a truncating problem when you insert or update a memo field...

Re: Memo Field Truncated after execution UPDATE Statement

I don't understand what you are trying to say, Star. When I'm debugging my coding the field is everywhere complete (< 255 chars) but when it's going through the UPDATE statement The field is truncated. It's like its acting like a Text field instead of
a Memo field.

Re: Memo Field Truncated after execution UPDATE Statement

In your link they are suggesting when changing the tekst you have to splitt the new tekst in parts from 255 chars & insert all parts into the table.

Their should be a better sollution then this. I don't get it, when I do it in the Access DB direct it's working, when I'm doing it in the Backend (DAL) It's working just fine but when I'm going via my website it's not working anymore. Should I cast the
text? Or do I have to change something in the DAL to ensure that the field is approached as a Memo field instead of a text field.

Re: Memo Field Truncated after execution UPDATE Statement

I found it!! It's such a stupid mistake which takes a lot of effort and is ofcourse the downside of automatically generating systems :-)

I went to the XSD file --> put my cursor onto the UpdateContent Query; clicked with the right mouse button and went to the properties of this statement. When you then select the parameters you can overthere adjust the length (field Size).