Hi David,<br><br>CreatedTime column name points to (tablename: vtiger_crmentity, columnname: createdtime)<br>Since this column already exists in the table, having columntype will not help.<br><br>If I were to add a CustomTime field then I would set<br>
<br>$field->tablename = 'vtiger_mytable';<br>$field->columname = 'customtime';<br>$field->columntype = 'DATETIME';<br><br>To summarize, the columntype could be any valid SQL datatype need not necessary be VARCHAR<br>
<br>Regards,<br>Prasad<br>vtiger Team<br><br><div><span class="gmail_quote">On 3/10/09, <b class="gmail_sendername">David fire</b> <<a href="mailto:ddfire@gmail.com">ddfire@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
in the payslip example for example for CreatedTime field you dont put any columntype.<br>it is varchar(255) ???<br>i should use varchar always or what i should do?<br>Thanks<br>David<br><br><div class="gmail_quote">2009/3/9 Prasad <span dir="ltr"><<a href="mailto:prasad@vtiger.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">prasad@vtiger.com</a>></span><span class="q"><br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi David,<br><br>You can set the columntype to any valid SQL type. <br><br>If the table to which field is bound does not have the column the columntype will be used for creating it.<br>
<br>By default, columntype is set as VARCHAR.<br>
<br>Let me know if this clarified the doubt.<br><br>Regards,<br>Prasad<br>vtiger Team<br><br><div><div><div></div><div><span class="gmail_quote">On 3/9/09, <b class="gmail_sendername">David fire</b> <<a href="mailto:ddfire@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">ddfire@gmail.com</a>> wrote:</span></div>
</div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div></div><div>
hi<br>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.<br>it is correct?<br>Thanks<br clear="all"><span><br>-- <br> (\__/) <br>
(='.'=)This is Bunny. Copy and paste bunny into your <br>
(")_(")signature to help him gain world domination. <br><br>
</span><br></div></div>_______________________________________________<br>
Reach hundreds of potential candidates - <a href="http://jobs.vtiger.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://jobs.vtiger.com</a> <br></blockquote></div><br>
<br>_______________________________________________<br>
Reach hundreds of potential candidates - <a href="http://jobs.vtiger.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://jobs.vtiger.com</a> <br></blockquote></span></div><div><span class="e" id="q_11fec99add6a74db_3"><br>
<br clear="all"><br>-- <br> (\__/) <br>(='.'=)This is Bunny. Copy and paste bunny into your <br>
(")_(")signature to help him gain world domination. <br><br>
</span></div><br>_______________________________________________<br>
Reach hundreds of potential candidates - <a onclick="return top.js.OpenExtLink(window,event,this)" href="http://jobs.vtiger.com" target="_blank">http://jobs.vtiger.com</a> <br></blockquote></div><br>