Posts: 3,564
Threads: 36
Joined: Apr 2014
Reputation:
49
the CPF field is text not numeric and the second image doesn't show that field nor anything related to it, so I am totally lost, but, in general, yes you can change the database field type to increment the size of the field.
in the case of numeric values you have to change the user preferences also
Joe
TSolucio
Posts: 1,665
Threads: 644
Joined: Aug 2016
Reputation:
164
01-17-2020, 11:40 AM
(This post was last modified: 01-17-2020, 12:14 PM by rslemer.)
Sorry I didnt clear enough
I used a CPF field image, only as example, to shows the field definition
and second image, I wish to know, is in that table and field, maximumnumlen i need made changes ( value 2 to value 3 )
But i don't understand what changes in user preferences i need to do
Ranieri
eCRM Web
Posts: 3,564
Threads: 36
Joined: Apr 2014
Reputation:
49
you have to change the TypeOfData column, set it to number: N~O~{decimals} and then in the table where the real field is you have to make sure the is at least 3 decimals
this should not lose any information but make backups and test before working on the live version
Joe
TSolucio
Posts: 1,665
Threads: 644
Joined: Aug 2016
Reputation:
164
Exactly
this is my question
in the past I saw everything in this field, now it looks like the size is in another column
has that changed?
Ranieri
eCRM Web
Posts: 3,564
Threads: 36
Joined: Apr 2014
Reputation:
49
no, it hasn't changed, it has always been like this, all the way back from vtiger crm 5.0.x !!
vtiger_field contains meta-information about the field: how to show it on screen, in what table and column the information is saved, if it is present on the screen or not, how it should be saved by corebos...
the REAL contents of the field, the information or value contained lives in each module's table (or wherever the vtiger_field says it lives).
So, if you need to make a field bigger, you have to modify the physical table where the value is, the column in the table where the information is AND update the vtiger_field meta-information accordingly
Joe
TSolucio
Posts: 3,564
Threads: 36
Joined: Apr 2014
Reputation:
49
that means that your field has no length validation
Joe
TSolucio
Posts: 1,665
Threads: 644
Joined: Aug 2016
Reputation:
164
Yes, field accept more than 2 digits, but not save correct value, in this situation
how, when I created a field, with layout editor, setting test a tam size too?
Ranieri
eCRM Web
Posts: 3,564
Threads: 36
Joined: Apr 2014
Reputation:
49
you have to change the column in the database table
Joe
TSolucio