Turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings

Change the way SalesLogix Adds/Drops fields via the SalesLogix DB manager

Status: New
by Gold Super Contributor on ‎04-27-2010 12:00 PM

For 13+ years (including today), SalesLogix has used a method of adding/dropping fields (via the db manager) that has involved several steps:

   A – Renames theoriginal table to xtempx_TableName

   B – Create the newtarget table but it has no data

   C – Adds the newfield to the new target table

   D – Copies the databack from the xtempx_ table to the new table

   E – Deletes thextempx_ table

 

This method was employed for several reasons:

  A - the "BDE" (Borland Database Engine)  <- No longer exists as of SalesLogix v6.0

  B - Early SQL server did not support "Alter Table, Alter Column <- It does now as (Oracle does too)

  C - The "SalesLogix Provider did not support the "Alter" command  <- Does as of SalesLogix v6.2.6 (maybe slightly earlier.. but it does not matter)

 

All the reasons to NOT do it the short and sweet way no longer exist.

 

Doing it the "long" way has caused many problems over the years and is a lurking "time bomb".

 

We just tripped into this on a (large) customer site where there are TaskCentre (controlled) SQL Triggers that are used for initiating Tasks/WorkFlows. As soon as a field is added/dropped (via the SalesLogix DB manager) , the trigger is "left behind" on the xtempx_ table.

 

This not only will happen w/TaskCentre managed SQL Triggers but also w/ANY triggers one may have setup against their SalesLogix database. 

Comments
by Bronze Elite Contributor
on ‎04-27-2010 02:52 PM
Really nice. Remind me not to use my favoriate feature of TaskCentre anymore.
by Gold Super Contributor
on ‎04-27-2010 03:15 PM
Just think of all those people who use SQL triggers to do auditing ;-)

We want to hear your cool ideas for enhancing Saleslogix products and services. So add your own ideas or kudo (vote) on the ideas of others here! Watch the most valuable bubble to the top!

I have an idea! How do I get started?

One
Read our submission guidelines.

Two
Search for your idea. If you don't see it, submit a new one!

Three
Provide feedback on the ideas of others by voting with kudos and adding comments.
For more information about using ideas, read this thread.

Four
Track your ideas and those you like. Once you've posted or kudoed and idea, subscribe to be notified via email of the latest updates to the idea. From within the idea, click "Idea Options" which appears above the idea title and choose, "Subscribe to this idea".

Be sure to check back from time to time to see new ideas and status updates!

Here is a quick list of the recent ideas for speedy browsing!
Labels