My system: Windows 7 + pb12.5 + sqlserver2008
I in data window there is a field called note: bz, of type char (200), after entry to save, to bring up the modified cannot be modified, if the edit properties by the limit of the field=200, changed to limit=0, is free to modify, but there is shown in the figure below modified error:
Where is the master problem?

CodePudding user response:

The

refer to the original poster lqhly response:

my system: Windows 7 + pb12.5 + sqlserver2008
I in data window there is a field called note: bz, of type char (200), after entry to save, to bring up the modified cannot be modified, if the edit properties by the limit of the field=200, changed to limit=0, is free to modify, but there is shown in the figure below modified error:
Where is the master problem?

The data window editsource once, see the bz this field in the data window type and length of this field should be the original short you adjusted to 200

CodePudding user response:

I watched, with editesource edit. Limit=200, and I set is the same, if there is not such a problem, pb8 how pb the upgrade connect appear this kind of low-level mistakes, really depressed!

CodePudding user response:

Problem solve,//- because by dw_1. Retrieve (PZH) data retrieved is full field, so the
//- not in optional insert and modify data in the window, because the insert and modify, and more than
the length of the field//- the length of the field within the database Settings, so will come out the item "XXXX" does not pass the validation testvali
//-- error, the solution: will retrieve the field data after the trim, went to the back of the redundant space data, and then
//-- and write the data back to the data window, then the field can modify,

CodePudding user response:

The field type is Char (200) of less than 200 behind after you input is automatically space up to 200, and then modify the actual is 200 you modify must have more than 200
You can modify the field type varchar

CodePudding user response:

reference 4 floor fengxiaohan211 response:

the field type is Char (200) of less than 200 behind after you input is automatically space up to 200, and then modify the actual is 200 you modify must have more than 200
You can modify the field type varchar

I tried your method, error message as same as the original,

CodePudding user response:

reference 5 floor lqhly reply:

Quote: refer to 4th floor fengxiaohan211 response:

The field type is Char (200) of less than 200 behind after you input is automatically space up to 200, and then modify the actual is 200 you modify must have more than 200
You can modify the field type varchar

I tried your method, error message as same as the original,

You so modified, you can add a data, and then save and retrieve try

Mainly in the original data you already have blank filling, modified type does not remove the Spaces

CodePudding user response:

reference 5 floor lqhly reply:

Quote: refer to 4th floor fengxiaohan211 response:

The field type is Char (200) of less than 200 behind after you input is automatically space up to 200, and then modify the actual is 200 you modify must have more than 200
You can modify the field type varchar

I tried your method, error message as same as the original,

Indeed, as moderator upstairs said you add a try

CodePudding user response:

The difference between char or varchar