Can I convert a field in the SalesLogix account table from being a Date/Time field to being a Date field?

Question:

Can I  convert a field in the SalesLogix account table from being a Date/Time field to being a Date field?

Can I just issue an “Execute SQL” from the Administrator and send to remotes? Assuming that is ok, what tables to I have to update? The first one that comes to mind is the SECTABLEDEF; and I’d have to change the DATETIMETYPE fromUtoD“. Are there any others?

 

It looks like the field definition in SQL itself is the same for both date and date/time so I won’t have to change it there.

Answer:

In the (SQL) db it is always a datetime field. It is how SalesLogix uses it and how the provider looks at it. Sectabledefs controls this.

 

Correct.. just use ExecuteSQL in the admin and send to ALL remotes as well (using ‘U’). Nothing else needs to be touched.

Submit a Comment

Your email address will not be published.

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!