[Vtigercrm-developers] vtlib and columntype

[David fire]

thanks
David

2009/3/9 Prasad <prasad at vtiger.com>

> 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
>>
>
>
> _______________________________________________
> 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20090309/303c5758/attachment-0003.html