Generating Table IDs in T-SQL - Version 2
In an earlier article I demonstrated how to generate SalesLogix IDs in SQL using the CLR. The method I described still does work but I have found a few issues with it since it has been in production. We'll take a look at these and how to solve them in this follow-up article.
Author: Jason Van Pee - 11/14/2011 - Rated: 4.5/5 by 20 users
|
|
Generating Table IDs in T-SQL
Generating SalesLogix IDs outside of SalesLogix can be a challenging concept. Third party applications go through the SalesLogix OLEDB provider and call the "slx_dbids" function to generate an ID for the specified table. The problem with this approach is that I don’t want to go through a third party application to insert records into my SalesLogix database. This article will look at how to generate SalesLogix table ID values using the .NET CLR in a SQL Function and call via T-SQL.
Author: Jason Van Pee - 4/22/2010 - Rated: 4.5/5 by 32 users
|
|
Creating SalesLogix Table ID Values - The Definitive Guide
Knowing how to create valid SalesLogix table ID values is a crucial part of working with SalesLogix. The subject of creating SalesLogix table ID values is common among those new to SalesLogix. Let's face it. There is some knowledge that is required when working with SalesLogix, and creating table IDs is no exception. This article will provide all details needed to start creating ID values to get you inserting new data in SalesLogix in no time.
Author: Ryan Farley - 8/10/2006 - Rated: 4.7/5 by 10 users
|
|
Integrated Logins with the SalesLogix 6.2 Provider
SalesLogix version 6.2 introduced the ability for linking a SalesLogix user account to an account in the Active Directory or domain. This new ability allows a user to bypass the Sales Client login screen and automatically log in if they have successfully authenticated with the Active Directory or domain. These SalesLogix users will likely never know how to handle a SalesLogix login screen since they never even see one. As a SalesLogix developer, it is a great idea to provide this same ability in your own addon applications.
Author: Ryan Farley - 9/24/2004 - Rated: 4.7/5 by 7 users
|
|
Building a SalesLogix Login Screen
Building a login screen for your custom SalesLogix addon application is an important part of building a polished and professional looking addon. This article will look at various types of login screens that you can easily build into your SalesLogix applications. (Updated for 6.2!)
Author: Ryan Farley - 9/15/2004 - Rated: 5.0/5 by 3 users
|
|
Detecting the Version of the Installed SalesLogix OLE DB Provider
As you likely know, the connection string for the SalesLogix OLE DB Provider changes for version 6.2 of SalesLogix. Now your custom applications that use a connection via the provider will need to be changed. But what about applications that need to be able to work with both versions - for example a commercial application? Sure, you could release two different versions of your application, but why? This article will look at how you can make your applications smart enought to determine which version of the SalesLogix Provider is installed.
Author: Ryan Farley - 9/15/2004 - Rated: 5.0/5 by 4 users
|
|
Understanding the SalesLogix 6.2 Connection String
The SalesLogix OLE DB Provider's connection string has changed for version 6.2. These changes are a result of the completely new OLE DB Provider built for SalesLogix 6.2. Taking advantage of all the new things the SalesLogix Provider has to offer starts with understanding the connection string.
Author: Ryan Farley - 9/6/2004 - Rated: 4.9/5 by 7 users
|
|
The Myths and Legends of Prepared Queries
A review of the how and when of using prepared ADO commands with the SalesLogix 6.2 OLEDB Provider (Version 6.2)
Author: Stuart Carnie - 6/11/2004 - Rated: 5.0/5 by 5 users
|
|
SalesLogix 6.1 Procedures
The SalesLogix 6.1 OLEDB provider exposes several procedures that are specific to performing various SalesLogix operations. These procedures are executed via a connection using the SalesLogix Provider and work in the same way that a normal database stored procedure works. Understanding what is available will help you to know how and when to solve problems using these procedures.
Author: Ryan Farley - 1/22/2004 - Rated: 4.8/5 by 4 users
|
|
The ADO.NET Primer
So, you've made the move to .NET? Welcome to the good side of the force, young padawan. Data access in .NET is a great thing. The classes that make up ADO.NET is one of my favorite parts of the .NET Framework. This article will serve as a jump start to getting you going with data access in your C# or VB.NET development.
Author: Ryan Farley - 1/31/2003 - Rated: 5.0/5 by 8 users
|
|
Connecting with the RWPassword From External Applications
This article focuses on how you can programmatically determine, decrypt, and use the SalesLogix RWPassword to gain Read/Write access to SalesLogix data from external applications using C# and VB.NET.
Author: Ryan Farley - 1/14/2003 - Rated: 5.0/5 by 9 users
|
|
Understanding the SalesLogix OLE DB Connection String (For versions 6.1 and prior)
The new OLE DB Provider allows you to access SalesLogix data via ADO or ADO.NET. However, before you can use the provider, it is important to understand how to connect to it. This article will examine the various parts of the SalesLogix OLE DB Provider connection string. Applies to version 6.1 and prior.
Author: Ryan Farley - 11/7/2002 - Rated: 5.0/5 by 8 users
|
|