March 2010 - Posts

• Posting changes from a Telerik RadGrid row edit back to a bound SalesLogix entity

  More on the Telerik RadControls for ASP.Net AJAX- they really really rock . The more I work with them the more I really love them. Thanks to some feedback from their support department I have figured out how to perform an automatic update of whatever... Read more Posted Mar 31 2010, 06:59 AM by Kris Halsrud with 1 comment(s) Tags: SalesLogix 7.5.2, SalesLogix Web, Telerik RadControls

• Sysdba fix script for SalesLogix database restores

  When restoring a SalesLogix SQL database backup from one server to another, you must synchronize the database’s sysdba user to the new SQL server’s sysdba user. This can be done using a SQL stored procedure. SalesLogix provides this procedure under their... Read more Posted Mar 30 2010, 09:32 AM by Kris Halsrud with 6 comment(s) Tags: SalesLogix, SQL Server

• Setting a current TreeNode in the Telerik RadTree control

  This first snippet allows you to set a particular Tree Node to be the selected one. In the code I am passing in a specific string value that corresponds to one of the tree’s node value properties. This then returns an instance of the particular Node which then exposes a Selected attribute. Read more Posted Mar 26 2010, 04:51 AM by Kris Halsrud with 1 comment(s) Tags: Telerik RadControls

• Programatically Creating a Temporary Lookup Group for a specific entity in the SalesLogix web client

  In SalesLogix you will often see behavior where after saving a record your are taken to the detail view of the new record and the current group has been set to just the new record. In the LAN client there was a Application.BasicFunction method exposed... Read more Posted Mar 22 2010, 07:29 AM by Kris Halsrud with no comments Tags: Application Architect, SalesLogix 7.5.2, SalesLogix Web

• Creating multiline labels in the SalesLogix web client

  A simple thing that I sometimes get asked is how to control the labels of the web client controls. Well the label text is rendered as HTML so you can add HTML tags directly in line with the text. To create a label that spans multiple lines, you can set... Read more Posted Mar 19 2010, 01:17 PM by Kris Halsrud with 1 comment(s) Tags: SalesLogix 7.5.2, SalesLogix Web

• Creating Pretty Prefixes and Suffixes in the SalesLogix web client

  In the SalesLogix web client you may run across a reason you need to generate a “Pretty Key”. This is what the SalesLogix Ticket Number is. This key is a combination of a Pretty Prefix and a Pretty Suffix. The Prefix is an equivalent to a system’s site code and the Suffix is a numerical equivalent to a primary table ID. To generate these you can simply call the functions in the Sage.SalesLogix.System.dll for each Read more Posted Mar 17 2010, 05:16 AM by Kris Halsrud with 1 comment(s) Tags: SalesLogix 7.5.1, SalesLogix 7.5.2, SalesLogix Web

• Editing tables in SQL 2008

  I recently ran into an issue when trying to edit a SalesLogix table in the SQL Management Studio 2008. I was trying to increase the length of a field while in a table’s design mode. When I went to save my change I received this error: Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can’t be re-created or enabled the option Prevent saving changes that require the table to be re-created. Read more Posted Mar 16 2010, 05:58 AM by Kris Halsrud with 2 comment(s) Tags: SalesLogix, SQL Server

• Adding an assembly reference to code files in the SalesLogix Application Architect

  Often when adding custom code to SalesLogix you need to reference Assemblies that are not included by default in Code Snippets or action items. This problem will often manifest itself with an error when building like “The type or namespace name 'Data'... Read more Posted Mar 15 2010, 01:22 PM by Kris Halsrud with 1 comment(s) Tags: Application Architect, SalesLogix 7.5.2, SalesLogix Web

• Launching a report from a button in the SalesLogix web client

  Starting in SalesLogix 7.5.1, Sage released an undocumented Reporting enhancement that allowed for interacting with the SalesLogix web reporting Server. The SalesLogix 7.5.2 release had this API enhancement built in, however little documentation exists and now standard samples are used in the web client. Hopefully this article will help out those who are trying to figure this out. Read more Posted Mar 12 2010, 06:49 AM by Kris Halsrud with 8 comment(s) Tags: Reporting, SalesLogix 7.5.2, SalesLogix Web

• Hiding Opportunities in the SalesLogix web client

  Occasionally we have clients who do not use the Opportunity components of the SalesLogix web client. They have asked us to remove the Opportunity visibility within the web client. Since this is not a common occurrence, I usually end up having to go back... Read more Posted Mar 10 2010, 05:38 PM by Kris Halsrud with 1 comment(s) Tags: SalesLogix Web

• Using ICriteria and Not to exclude records in SalesLogix

  In SalesLogix you can use the Sage.Platform.Repository.ICriteria class to query the entity model using standard ICriteria. One thing I have been asked in the past is how do you exclude certain conditions? A common example might be show me all of the non... Read more Posted Mar 04 2010, 08:39 AM by Kris Halsrud with 2 comment(s) Tags: IRepository, SalesLogix Web