Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
I can made a change into field tam size directly in database?
#1
http://corebos.com/documentation/doku.php?id=en:devel:field_structure&s[]=field&s[]=type

I look at this tutorial

I created a field, numeric, with 2 digits, and zero decimals, but I need change it to 3 digits

is possible change directly in database ? without lose any value already input ?

Only I need is change a last number? ( see a attached image )


Attached Files Image(s)
       
Ranieri
eCRM Web
Reply
#2
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
Reply
#3
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
Reply
#4
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
Reply
#5
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
Reply
#6
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
Reply
#7
Sorry, I still don't understood, because is different in my database

in documentation in link http://corebos.com/documentation/doku.php?id=en:adminmanual:lead_conversion&s[]=field&s[]=editor

I can see typeofdata with 4 parameters ( like you say )

and in my actual table only have a two parameters ... exactly last parameter ( size of data ) is not presence


Attached Files Image(s)
       
Ranieri
eCRM Web
Reply
#8
that means that your field has no length validation
Joe
TSolucio
Reply
#9
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
Reply
#10
you have to change the column in the database table
Joe
TSolucio
Reply


Forum Jump:


Users browsing this thread: 4 Guest(s)