[Vtigercrm-developers] Help please.

[Michel JACQUEMES]

Hi Josh,

I have not the answer and I asked for explanation 2 month ago. I don't think
there is any, it is more probably some remaining thing from sugarcrm.

I worked a bit on that when migrating to mssql and found that it has to be
combined with uitype field:

 ("D","I","N")  are numeric, ("C","E","O") are not,
 "V" is numeric if uitype in (5,50,52,53,56,57)
 exceptions : tablename="contactdetails" columname="reportsto" uitype=57 ?
 "T" is numeric if uitype = 70

Not sure it helps, isn't it?

Michel

> -----Message d'origine-----
> De : vtigercrm-developers-bounces at lists.vtigercrm.com [mailto:vtigercrm-
> developers-bounces at lists.vtigercrm.com] De la part de Josh Lee
> Envoyé : mercredi 5 avril 2006 03:51
> À : vtigercrm-developers at lists.vtigercrm.com; vtigercrm-
> contributors at lists.sourceforge.net
> Cc : Jeremy Lowery
> Objet : [Vtigercrm-developers] Help please.
> 
> Anyone wanna give this one a whirl?
> 
> What are quickcreate | quickcreatesequence | info_type for?
> 
> Most especially, what the heck does V~O, V~M, E~O, I~O, C~O, or T~O mean
> on the field table?
> 
> mysql> select distinct typeofdata from field;
> +--------------------------------------------------+
> | typeofdata                                       |
> +--------------------------------------------------+
> | V~M                                              |
> | V~O                                              |
> | I~O                                              |
> | E~O                                              |
> | C~O                                              |
> | T~O                                              |
> | D~O                                              |
> | D~O~OTH~GE~support_start_date~Support Start Date |
> | N~O                                              |
> | D~M                                              |
> | D~O~OTH~GE~sales_start_date~Sales Start Date     |
> | D~O~OTH~GE~start_date~Start Date                 |
> | DT~M~time_start                                  |
> | D~M~OTH~GE~date_start~Start Date & Time          |
> | O~O                                              |
> | T~M                                              |
> | I~M                                              |
> +--------------------------------------------------+
> This just confuses the hell out of me.
> 
> 
> --
> Josh Lee
> Software Engineer
> Zertis Technologies, LLC
> 205.422.5279
> jlee at zertis.net