[Vtigercrm-developers] vtlib and columntype

[Prasad]

Hi David,

CreatedTime column name points to (tablename: vtiger_crmentity, columnname:
createdtime)
Since this column already exists in the table, having columntype will not
help.

If I were to add a CustomTime field then I would set

$field->tablename = 'vtiger_mytable';
$field->columname = 'customtime';
$field->columntype = 'DATETIME';

To summarize, the columntype could be any valid SQL datatype need not
necessary be VARCHAR

Regards,
Prasad
vtiger Team

On 3/10/09, David fire <ddfire at gmail.com> wrote:
>
> in the payslip example for example for CreatedTime field you dont put any
> columntype.
> it is varchar(255) ???
> i should use varchar always or what i should do?
> Thanks
> David
>
> 2009/3/9 Prasad <prasad at vtiger.com>
>
>> Hi David,
>>
>> You can set the columntype to any valid SQL type.
>>
>> If the table to which field is bound does not have the column the
>> columntype will be used for creating it.
>>
>> By default, columntype is set as VARCHAR.
>>
>> Let me know if this clarified the doubt.
>>
>> Regards,
>> Prasad
>> vtiger Team
>>
>> On 3/9/09, David fire <ddfire at gmail.com> wrote:
>>
>>> hi
>>> i read the docs ones and again the only conclucion i get is when making a
>>> new field using vtlib only put columntype when it is varchar.
>>> it is correct?
>>> Thanks
>>>
>>> --
>>> (\__/)
>>> (='.'=)This is Bunny. Copy and paste bunny into your
>>> (")_(")signature to help him gain world domination.
>>>
>>>
>>> _______________________________________________
>>> Reach hundreds of potential candidates - http://jobs.vtiger.com
>>>
>>
>>
>> _______________________________________________
>> Reach hundreds of potential candidates - http://jobs.vtiger.com
>>
>
>
>
> --
> (\__/)
> (='.'=)This is Bunny. Copy and paste bunny into your
> (")_(")signature to help him gain world domination.
>
>
> _______________________________________________
> Reach hundreds of potential candidates - http://jobs.vtiger.com
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20090310/8f88c3ec/attachment-0003.html