[Vtigercrm-developers] homepage widget layout error

[lucia digirolamo]

thanks, I deleted the old field and created a new one with your 
correction but problem remains.

I also tried to change the type of field to text ($field->columntype = 
'VARCHAR(255)'; $field->uitype = 1; $field->typeofdata = 'V~O';) and 
layout shows correctly, so it's definitely a problem with the decimal 
type, I'm doing something wrong in creating the 'km percorsi' decimal 
field but I can't understand what.



On 08/05/2015 14:59, Alan Lord wrote:
> On 08/05/15 13:15, lucia digirolamo wrote:
>> $field->columntype = 'DECIMAL(7,2)';
>> $field->uitype = 7;
>> $field->typeofdata = 'I~O~7,2';
>
> Two things I notice immediately:
>
> typeofdata should be N~O~7,2 (I is for Integer)
> If you need negative numbers it should be NN~O7,2
>
> columntype should be 'DECIMAL(9,2)'
>
> MySQL want to see the *total* number of digits and then the precision.
> vtiger wants to see each side of the decimal point.
>
>
>
> _______________________________________________
> http://www.vtiger.com/
>