PS2003 Project Enterprise text

[Nach]

Hello:
I have a code that uses a form to get user-input and copy that value into a
custom field -- > Project Enterprise text 40. If the user enters more than
256 characters I see an unhandled exception error. I figured this was because
the text fields in Project Server Databases have a datatype of varchar(256).
I tried modifying that table MSP_TEXT_FIELDS to use 'text' as a datatype
instead of varchar(256). But I still get this error. What could the reason be
? Any Ideas ?

Thanks
Nach

 

[Jack Dahlgren MVP]

The reason is that text fields have a limit of 256 characters.
You can't get around that by changing the database. It is just the way it
is.
You can use the notes field if you need to have more than 256 characters.

-Jack Dahlgren