October 2004 - Posts

• DataGrid Edit Events Madness

  OK. It's been a long crappy day. I've been working with the DataGrid's “edit” events, such as OnEditing, OnEditingRow, OnEdited, and OnEditedRow with inline editing. I have a few fields on the grid that are editable and others that are not. Here's what sucks. Read more Posted Oct 27 2004, 04:45 PM by Ryan Farley with 3 comment(s) Tags: Development, General, Issues and Bugs, New Finds, Rants

• VBA Picklist Item Missing

  Timmus Agersea from Customer Systems Inc shares a tip about a missing picklist item in SalesLogix related to script tasks in Contact Processes (posted in the SalesLogix Business Partner newsgroups). Thanks Timmus. Read more Posted Oct 26 2004, 09:25 AM by Ryan Farley with no comments Tags: Development, General, Issues and Bugs, New Finds

• Exporting a DataGrid to a CSV File

  Along the same lines as my posts on exporting a SalesLogix DataGrid (well, exporting the Recordset behind the grid) to Excel, Michael Cessna from SalesLogix shared this quick bit of code for dumping a Recordset to a CSV file (posted in the SalesLogix Business Partner newsgroups) Read more Posted Oct 25 2004, 10:59 AM by Ryan Farley with 3 comment(s) Tags: Development, General, New Finds

• Opening a MainView Dynamically

  I came accross a new SalesLogix related blog today from someone named Bjorn who has a post related to a post I made about launching MainViews. Read more Posted Oct 22 2004, 09:55 PM by Ryan Farley with 1 comment(s) Tags: Development, General, New Finds

• Accessing MainView Tabs at Runtime

  MainView plugins have a TabsPane which essentially contains a collection of Forms, displayed as tabs, for the MainView. There are times when it is necessary to access the tabs programatically to be able to manipulate controls on the Form or set properties from other things that happen on the MainView. Fortunately, this is an easy task. Read more Posted Oct 21 2004, 08:58 AM by Ryan Farley with 2 comment(s) Tags: Development, General, New Finds

• Enabling Encryption with the SalesLogix Provider

  To enable data encryption between the client and server components of the SalesLogix OLEDB Provider, you must edit the encryption type in the SlxLocalServers.xml file (found in the SalesLogix directory)... Read more Posted Oct 19 2004, 10:41 PM by Ryan Farley with 2 comment(s) Tags: General, New Finds

• Fixing the Orphaned SYSDBA SQL User

  Ok, I see in my logs constantly google searches for “ fixing the sysdba user “ that lead to this blog. This is a common thing I find in my logs, but strangely enough, I've never posted anything about fixing the sysdba user. So, drumroll... sp_change_users_login... Read more Posted Oct 14 2004, 08:43 PM by Ryan Farley with 2 comment(s) Tags: Database, General, SalesLogix

• Dump Grid Data to Excel - Revisited

  In a previous post, Quick & Dirty Way to Dump a Grid to Excel, I outlined a quick and easy way to get your data from a SalesLogix Grid into Excel. I've been asked a few questions related to how to modify that to work differently, but the most common is how to remove unwanted columns and add a header row. Read more Posted Oct 13 2004, 05:47 PM by Ryan Farley with 3 comment(s) Tags: Development, General, New Finds