Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Monday, October 16, 2017 
 
Architect How To Articles  

14 articles found

How to Filter a SalesLogix Crystal Report by ID at Runtime
This article describes how to call provide a Crystal Reports parameter to a report at runtime via a script. This example details how to feed the current OpportunityID to a report when a button is clicked.
Author: Mark R. Bailey - 6/6/2007 - Rated: 4.7/5 by 9 users

 
How to Add a Custom Column to the Manage Products Grid
This article discusses how to add a custom column to the SalesLogix Manage Products datagrid. This out of the box area is difficult to customize. Following the steps outlined in this article will help you make an easy task of customizing this area.
Author: Mark Mazzitello - 4/26/2007 - Rated: 5.0/5 by 6 users

 
How to Launch a Contact Process via Script
This article describes the steps to launch a contact process programatically. Sample scripts in both VBScript and legacy basic are included.
Author: Walter Shpuntoff - 8/29/2006 - Rated: 4.8/5 by 5 users

 
How to Push out "Pass Through" SQL to Remotes
Ever wish there was an easier way to get views created in Remotes? Looking to push out a non-SLXOLEDB compliant Transact SQL statement? This article details a VBScript function to do just this.
Author: Gene Underwood - 11/24/2005 - Rated: 5.0/5 by 3 users

 
How to update Data with Updateable RecordSets
In SalesLogix scripting you have the ability to take advantage of ADO Recordsets for updating data. This is a far better route than building SQL statements to perform inserts or updates of data. This article examines using updatable Recordsets to add and update SalesLogix data.
Author: Kris Halsrud - 10/27/2005 - Rated: 5.0/5 by 10 users

 
How to use COALESCE with SalesLogix Queries
Eugenio takes a look at how to use COALESCE in your SalesLogix queries to make the task of building name strings from multiple fields without the need for checking for NULLs.
Author: Eugenio Gil - 9/5/2005 - Rated: 5.0/5 by 6 users

 
How to Save & Read Images in a SalesLogix Database
Using a connection via the SalesLogix OLE DB provider you are able to save files or images in a SalesLogix database. The provider ensures that these saved files or images will synchonize to remote users once saved in the database. This article will look at writing image files to an account table to store a logo image for each account as well as read the image from the database to display on the account detail screen.
Author: Ryan Farley - 5/18/2005 - Rated: 5.0/5 by 7 users

 
How to Use Common Dialogs in SalesLogix
There are many scenarios when doing SalesLogix customizations where you might need to make use of a common dialog, such as the "Open File" or "Save File" dialogs. There are a few different options when it comes to using common dialogs in a SalesLogix environment, some better than others. The purpose of this article is to examine each option and discuss the pros and cons of each.
Author: Ryan Farley - 5/18/2005 - Rated: 5.0/5 by 5 users

 
How to generically invoke the edit form for a SalesLogix datagrid
Many people miss the older (pre version 6) behavior of SalesLogix grid's where the user could double-click on a row to invoke the grid's edit form. The new datagrids to not behave this way because of the new support for inline editing and activating the clicked cell instead of doing something like invoking the edit form. However this is easy enough to change and handle with a generic script that can be included when ever you need this functionality.
Author: Ryan Farley - 3/23/2004 - Rated: 5.0/5 by 12 users

 
How To: Set Mouse Cursor in Legacy Views
So, have you ever wanted to change the cursor to an HourGlass during a long running process in order to provide better feedback to the user? SalesLogix v6.1.1 has this feature for new ActiveX Forms and Controls, but there is not a feature like this for Legacy Views. This article outlines the code needed to do just this.
Author: Todd Hardin - 1/13/2004 - Rated: 5.0/5 by 3 users

 
How to Create a View in a SalesLogix Database that Points a Table in a Different Database on a Different Server
This article shows you how to create a view in your SalesLogix database that looks and acts like a normal SalesLogix table from within SalesLogix applications, but is actually accessing data on another server.
Author: David Nelson - 6/13/2003 - Rated: 5.0/5 by 5 users

 
How To Retrieve a Record Count From an ADO Recordset
It is often necessary to retrieve a record count from an ADO Recordset. Although the Recordset object has a built in RecordCount property, there are some special requirements needed in order to use it. This article explores these requirements as well as a better alternative to counting the records in a Recordset.
Author: Ryan Farley - 1/14/2003 - Rated: 5.0/5 by 13 users

 
How To Update Controls Across Forms
SalesLogix v6 has a great new Forms collection exposed in the Application object. This new collection will solve many problems associated with updating controls across forms. This article will focus on using the Forms collection to do just that.
Author: Ryan Farley - 1/8/2003 - Rated: 5.0/5 by 14 users

 
How to Connect to External Data Using ADO
Welcome to the wonderful world of ADO. With SalesLogix v6, ADO is the new standard for accessing data. Whether you're accessing data from SalesLogix, or from another data source, ADO is the technology you'll use inside of a SalesLogix VBScript. This article will focus on the aspect of accessing external data using ADO. We'll look at three different examples using Access, Excel, and CSV files.
Author: Ryan Farley - 11/27/2002 - Rated: 4.9/5 by 13 users

 


 slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation.
 This site, and all contents herein, are Copyright © 2017 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.

code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 10/16/2017 6:36:20 PM