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
   Saleslogix 8.1 Web Access Tab Throws Null Reference Error
 I recently had a client experiencing a problem access the Contact's Web Access tab.  Whene
Posted on Jun 18, 2014 by Kris Halsrud to Kris Halsrud's Blog
 
   Unable to Win Opportunities for Some Records in the Saleslogix web client
We recently ran into a client issue that I have just reported to Swiftpage as a bug (Ticket 8010151686)Th
Posted on May 06, 2014 by Kris Halsrud to Kris Halsrud's Blog
 
   Saleslogix v7.5.4 Web Client - Unable to Drag and Drop files
I recently had a customer who had one user who was unable to use the drag and drop feature of the Saleslo
Posted on Apr 23, 2014 by Kris Halsrud to Kris Halsrud's Blog
 
   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
 
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