I recently had a client that was using the SalesLogix LAN client and had upgraded from 6.2 to 7.5.2 During the upgrade a problem arose that exhibited itself by crashing the SalesLogix client with no error messages of any kind. After looking into it I discovered the problem was a custom form they had was issuing a SQL INSERT statement against the database. Specifically they were using a format of:
INSERT INTO MYTABLE VALUES (‘1’,’2’,’3’)
Apparently after 6.2 there was a change to the provider that made it incompatible with this INSERT statement format. The bad thing is that the user is not presented with an error. One would think you would get a error similar to other statements that fail to execute through the provider of “Failed to Parse SQL”. Instead, using this insert format the application simply crashes without any errors.
The fix for this particular problem was pretty straight forward. We simply needed to add the columns to insert into in the INSERT statement, like so:
INSERT INTO MYTABLE (COL1, COL2, COL3) VALUES (‘1’,’2’,’3’)
Again not a big deal but things like this are a prime example of why it is so important to upgrade your system in a test environment first so that breaking changes like this do not rear their head while in production.