Login / Register  search  syndication  about

          Kris Halsrud's Blog

Kris Halsrud on development and Integration with CRM and Development

SalesLogix Provider Post 6.2 -Problems with Insert Syntax

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.
What's This?
  
Bookmark and Share

About Kris Halsrud

   Kris Halsrud is a Senior Analyst / Developer for Customer FX Corporation.


Related Content
   CRITICAL Issue with Saleslogix v8.1 Web SNC 02- Breaks Compatability with SQL 2008R2
One of the listed fixes in SNC 02 for Saleslogix 8.1 is listed as:14095222 Enhance the SQL generation to
Posted on Apr 17, 2014 by Kris Halsrud to Kris Halsrud's Blog
 
   Bug in the Saleslogix Web LiveGrid Lookup dialog
I recently ran into an issue with the Opportunity Products grid in the Saleslogix web client.  I cli
Posted on Apr 04, 2014 by Kris Halsrud to Kris Halsrud's Blog
 
   Major Problem in Saleslogix v8.1 Cloud Instances
I have been working with a new client who is on the hosted cloud solution for Saleslogix version 8.1.&nbs
Posted on Mar 19, 2014 by Kris Halsrud to Kris Halsrud's Blog
 
   Correct Build Search Path for Saleslogix Web v8.1
Despite what the help file says, the correct value to be in the build search path field under Tools...Bui
Posted on Mar 17, 2014 by Kris Halsrud to Kris Halsrud's Blog
 
   Saleslogix Web Client 8.0 on Firefox v10.x
With all the browser updates it's tough to keep SalesLogix web client running as it should with the m
Posted on Dec 27, 2013 by Mark Duthoy to SalesLogix Support
 
Comments

 

Provider post | Rapidrefillwashington said:

Pingback from  Provider post | Rapidrefillwashington

June 12, 2011 1:43 PM

Leave a Comment

(required)  
(optional)
(required)  
Add
All contents Copyright © 2014 Customer FX Corporation
Customer FX Corporation
2324 University Avenue West, Suite 115
Saint Paul, Minnesota 55114
Tel: 800.728.5783

  Follow @CustomerFX on twitter
Follow the best news, tips, and articles
  Subscribe to Customer FX on youtube
Watch SalesLogix tutorial videos from Customer FX
Login / Register