September 2004 - Posts

• More on CursorLocation with SalesLogix

  In response to my last post, Jeremy Brayton asked an important enough question that I felt warranted another post on the subject. Read more Posted Sep 27 2004, 10:50 AM by Ryan Farley with 2 comment(s) Tags: Development, New Finds, Issues and Bugs, General

• ADO CursorLocation and SalesLogix

  I see the question arise often about CursorLocation with Recordsets in SalesLogix. This question comes up even more now with SalesLogix 6.2 as neglecting to set CursorLocation can have have more noticable results. Read more Posted Sep 27 2004, 09:51 AM by Ryan Farley with 1 comment(s) Tags: Development, New Finds, Issues and Bugs, General

• Prepared Queries and the SalesLogix Provider

  If you have not yet read Stuart Carnie's article on slxdeveloper.com on using prepared queries with the SalesLogix provider than I highly recommend you check it out (See: The Myths and Legends of Prepared Queries). Stuart recently offered some comments to the article which provided some background on the provider in regards to trips to the server as well as other significant changes which result in big performance gains. Read more Posted Sep 22 2004, 12:16 PM by Ryan Farley with no comments Tags: Development, General, slxdeveloper.com

• Truncating All SYSDBA Owned Tables

  Whenever I do an import into SalesLogix I put all my source data into a staging database in SQL Server. This allows you to work with your data in a common place and massage & group data via SQL Views and provides a common place to work with your source data no matter what format it was in (CSV, Excel, Access, AS400, dBase, etc). This SQL statement will allow you to dump the data from yuor staging tables so you can start out clean again. Read more Posted Sep 13 2004, 10:57 AM by Ryan Farley with 3 comment(s) Tags: Development, New Finds, General

• Quick and Dirty Way to Dump a Grid to Excel

  If you're looking for just a quick way to dump it out and don't care if it is pretty or anything, then you can use Excel's CopyFromRecordset method which copies a recordset into a range of cells. Read more Posted Sep 08 2004, 07:17 AM by Ryan Farley with 1 comment(s) Tags: Development, New Finds, General

• Literals Available in Query Builder

  Often you might want to use a literal value when building a group using the Query Builder, such as the userid of the currently logged in user. There are some undocumented literals available in the Query Builder that allow you to do just this. Here's a list of the literals available to you Read more Posted Sep 01 2004, 08:42 AM by Ryan Farley with 8 comment(s) Tags: Development, New Finds, General