The Latest

DevX - Software Development Resource

Getting the Right Data with SQL Joins

he cornerstone of the relational database system is its multiple tables and the ability to associate those tables with one another so you can combine data from different but related

DevX - Software Development Resource

LED ActiveX control

This LED (Light Emitting Diode) control displays positive long integers, and it is particularly useful for counters. It has a few simple properties that allow you to set the control’s

DevX - Software Development Resource

Home-grown Data Mining in SQL Server

s a database programmer, when you don’t know where the tables and columns you need to do your job are, you’re dead in the water. You can browse through Enterprise

DevX - Software Development Resource

ShutDownComPlusApplication – Shutting-down a COM+ application

‘ Shut-down the COM+ application with the input name’ Note: requires a reference to the COM+ Admin Type Library” Example: ShutDownComPlusApplication(“MyComPlusApp”, “”)Sub ShutDownComPlusApplication(ByVal applicationName As String, _ ByVal serverName As

DevX - Software Development Resource

StartComPlusApplication – Starting a COM+ application

‘ Start the COM+ application with the input name’ Note: requires a reference to the COM+ Admin Type Library” Example: StartComPlusApplication(“MyComPlusApp”, “”)Sub StartComPlusApplication(ByVal applicationName As String, _ ByVal serverName As

DevX - Software Development Resource

Avoid a Common Debugging Mistake

Normally most of designers do this: if(someVariable == someValue){ doSomeActions;} If you type ‘=’ instead of ‘==’, it will not be detected during the compilation. This means you could spend

DevX - Software Development Resource

Review: Put an End to Lifeless Help Apps

he Help sections of your applications are probably never going to be particularly sexy—and rightly so—but that doesn’t mean that you’re stuck forever with a standard, text-heavy, and uninspired user

DevX - Software Development Resource

From Palm OS to Symbian OS: Making the Switch, Part 2

art 1 of this series began a discussion of the differences between PalmOS and Symbian OS. Despite their superficial similarities, programming in Symbian isn’t just like programming a Palm PDA.

DevX - Software Development Resource

IBM Stumping for WebSphere on Windows

T managers once maintained a semblance of control over what types of operating systems were run in the data center, but they may as well relinquish all hope of doing

DevX - Software Development Resource

PrintF – Transforming template strings

‘ This VB6 function returns a string with a set of parameters replaced with ‘ variables, similar to the C function printf().Public Function PrintF(strMask As String, ParamArray Values()) As String

DevX - Software Development Resource

Book Excerpt: Code Generation in Action

ode generation abstracts the design of the code so that multiple outputs can be created from a single model of the application functionality, which means development teams can focus on

DevX - Software Development Resource

Use CopyFromRecordset With ODBC Recordsets

You can create an ODBCDirect recordset for use with the Excel Range objects CopyFromRecordset method by using the DAO.Connection objects OpenRecordset method: Public Function CreateDaoRecordset( _ ByVal sDataSource As String,