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
   Infor CRM (Formerly Saleslogix) v 8.1.3 Web Client- Bug with Picklist Enabling on Form Load
 We recently had a client report an issue that occurs in the Infor CRM web client.  The client
Posted on Mar 25, 2015 by Kris Halsrud to Kris Halsrud's Blog
 
   Problems running Crystal Reports in the Infor CRM (formerly Saleslogix) LAN client
We recently had a client that was using the Crystal RDC object in VBScript within the LAN client to run a
Posted on Jan 20, 2015 by Kris Halsrud to Kris Halsrud's Blog
 
   Unable to Insert Opportunities in Infor CRM (formerly Saleslogix) Web Client
 I recently ran into an issue where a client was unable to insert Opportunities when logged in as pa
Posted on Jan 14, 2015 by Kris Halsrud to Kris Halsrud's Blog
 
   Infor CRM (formerly Saleslogix) Web Client - How Time Zones Work
The Infor CRM web client utilizes  a couple of methods to determine and then present what timezones
Posted on Jan 09, 2015 by Kris Halsrud to Kris Halsrud's Blog
 
   Error Attempting to Save an Entity: "E_FAIL(0x80004005)" in the Infor CRM (Saleslogix) Web Client
We recently had a client that was running into an issue when attempting to create one particular entity i
Posted on Sep 30, 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 © 2015 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