3/17/2026 5:28:26 AM
|
| |
| 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!
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.
|
|
|
|
Adding database columns
Posted: 10 Sep 08 2:44 PM
|
Is it possible to insert a non-existing column into an existing database table via an execute SQL action in a project/bundle? E.g. "ALTER TABLE table_name
ADD COLUMN column_name column-definition;" This syntax does not work through the Execute SQL function in the administrator.
The Add Action: Create Field only allows a field to be created and copied.
|
|
|
|
Re: Adding database columns
Posted: 10 Sep 08 3:28 PM
|
Why can't you just create the field in your development environment, build the create field in the bundle and apply it? What's necessitating the need for Execute SQL?
Jeff
|
|
|
|
Re: Adding database columns
Posted: 11 Sep 08 8:37 AM
|
John,
Creating fields (or tables) this will break certain things in SalesLogix.. it's the "metedata" (or lack thereof) that will bite (byte you!
Like Jeff says.. bundle it.. it's all in the help file(s). |
|
|
|
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!
|
|
|
|
|
|
|
|