slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Architect Forums - SalesLogix Scripting & Customization
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Scripting & Customization | New Thread

View: Search:

Author

Thread: Alter the size of a database column/Intellisync Outlook Integration Limitations

John Hogan
Posts: 13

Alter the size of a database column/Intellisync Outlook Integration Limitations Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 18 Sep 08 11:42 AM

Is it possible in anyway to safely alter the size of a in a standard SLX database table column. I'd like to alter the size of the TYPE column in the CONTACT table. Running the following via the Execute SQL in Admin just causes my Admin to hang: "ALTER TABLE CONTACT ALTER COLUMN TYPE varchar(128)"

I'm attempting to use fields that available through the Intellisync Outlook Integration (TYPE is one of them) and I need larger sized fields. To the best of my knowledge, it is not possible to add additional custom fields into the interface.

Thanks.

[Reply][Quote]

Marc Johnson
Posts: 252

Re: Alter the size of a database column/Intellisync Outlook Integration Limitations Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 18 Sep 08 12:28 PM

John,

Which version of SLX? With 7.x+ you can add custom columns to stock data tables.

Marc

[Reply][Quote]

Mike Spragg
Posts: 1226

Re: Alter the size of a database column/Intellisync Outlook Integration Limitations Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 19 Sep 08 4:02 AM

You should be able to open Architect/Admin and DBManager and alter the size anyway.

How large is the database - as this command does work - but will take some time if there are a large number of rows.

[Reply][Quote]

John Hogan
Posts: 13

Re: Alter the size of a database column/Intellisync Outlook Integration Limitations Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 29 Sep 08 11:12 AM

Version 7.0. However, I still cannot add a custom field, or any additonal column for that matter, to the Field Mapping for Contacts in Intellisync for SalesLogix Configuration.

[Reply][Quote]

John Hogan
Posts: 13

Re: Alter the size of a database column/Intellisync Outlook Integration Limitations Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 29 Sep 08 11:14 AM

Thanks. However, in the DBManager I am not able to modify the size of any database fields. They are displayed as read only.

[Reply][Quote]

Mike Spragg
Posts: 1226

Re: Alter the size of a database column/Intellisync Outlook Integration Limitations Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 29 Sep 08 11:25 AM

Ah yes, there's a trick to get that to work - update sectabledefs set userdef = 'T' where tablename = 'Contact' (do NOT do all tables!) - then switch it back to 'F' when done.

[Reply][Quote]

John Hogan
Posts: 13

Re: Alter the size of a database column/Intellisync Outlook Integration Limitations Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 01 Oct 08 10:00 AM

Great, thanks! However is it possible (or advisable?) to change the field type through the Database manager? I would like to change the field SPOUSEBIRTHDAY on the CONTACT to a VARCHAR.

[Reply][Quote]

John Hogan
Posts: 13

Re: Alter the size of a database column/Intellisync Outlook Integration Limitations Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 01 Oct 08 10:00 AM

Great, thanks! However is it possible (or advisable?) to change the field type through the Database manager? I would like to change the field SPOUSEBIRTHDAY on the CONTACT table to a VARCHAR.

[Reply][Quote]

Mike Spragg
Posts: 1226

Re: Alter the size of a database column/Intellisync Outlook Integration Limitations Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 01 Oct 08 10:45 AM

I wouldn't - it's used on the detail tab for Contact. Create a new one - and hide the old one.

[Reply][Quote]

Bob (RJ)Ledger
Posts: 1103

Re: Alter the size of a database column/Intellisync Outlook Integration Limitations Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 01 Oct 08 4:06 PM

Agree with MikeS.

It's OK to extend a field (ex: change a varchar 8 to a varchar 32, etc) .. but not a good idea to change one from.. say a datetime to a varchar.. You will just break things and have serious issues on hot fixes, SP's upgrades, etc.

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 8/25/2025 12:56:08 PM