[Vtigercrm-developers] vtlib and columntype

[Prasad]

my pleasure.

- Prasad

On 3/10/09, David fire <ddfire at gmail.com> wrote:
>
> 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.
>
>
> _______________________________________________
> 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/303ecba7/attachment-0002.html