This tip is for SQL Server 6.5 and up. When debugging a SELECT query, add an absolute true condition as the first condition of the WHERE clause: SELECT au_lname, au_fnameFROM
Use the GetSafeArrayInfo function to rip the lid off a SAFEARRAY. It allows the caller to identify the number of dimensions and number of elements for each dimension (among other
To use the FileSystemObject, you need to reference the Microsoft Scripting Runtime: Public Function GetExecutableFileVersion(ByVal _ Filename As String) As String Dim FileObj As Scripting.FileSystemObject ‘ Create Object Set FileObj
When you call a stored procedure in SQL Server that performs data manipulation on the database from a Microsoft Transaction Server (MTS) transaction, let MTS handle all the transaction management.
This TickDiff function returns the difference of two calls to GetTickCount or timeGetTime, taking into account things such as VB Related Posts Get All the Available Time ZonesQuickly Get a
Many VB objects have KeyDown, KeyUp, MouseDown, MouseUp, and MouseMove events. They Related Posts Explore the New Updates to Power BI DesktopGoogle Cloud Databases Now Generally AvailableMicrosoft Announces Azure IoT
Oracle and SQL Server treat strings slightly differently Related Posts Intel announces major restructuring amid $1.6B lossSQL JOINsThe Big Data IllusionIBM Bluemix Adds New DevOps ServiceIncrease Your Productivity With These
This tip works with ASP/IIS 4.0 and up. Many companies sell ActiveX objects for uploading files to Active Server Pages. However, you can easily write a bit of VBScript to
If a user doesn Related Posts Top 15 Laptops in 2023: Industry AnalysisVisual Studio 2015 Update 2 Boasts Faster C/C++ PerformanceHow to Increase the Size of an Array in JavaFinding
Use this method whenever you need a tiled background on your forms. All you need is an Image control with its Visible property set to False, and a graphic in
This tip is for SQL Server 7.0 or up. If you Related Posts How to Change the Storage Engine in MySQLSET ARITHABORT ONConverting a String into a DateGlobal Pact Targets
Install and uninstall issues are some of the most common sources of calls to help desks. The following is a tip on an implementation strategy for software updates using InstallShield
t was just about exactly two years ago that DevX changed enough things around that our readers were likely to notice. At that time we were implementing a site-wide navigation
arge collections of diverse images, graphics and video are becoming common, both on the Web and in media asset databases. As the size of the image collections expand, it becomes
hether you think very much about fonts or not, as an application user, you are constantly interacting with and manipulating fonts. Particularly in word processing programs, where it’s common to
ometimes, how you present data is just as important as the data itself. One of the simplest presentation techniques is to sort the data in some meaningful way, but SQL
The Perl language gains popularity daily among programmers from all over the world because of its flexibility, vast sphere of application, and easy source-code availability. The Comprehensive Perl Archive Network
ou create an “owner-draw” ListBox or ComboBox when you want to bypass the control’s automatic item display in order to do something special, such as display an image for each
ll graphical user interfaces, including Windows, make excellent use of the mouse. One way that the mouse can be used is drag-and-drop, the ability to initiate some action by dragging
As developers, we are trained to look at workflows, trends and needs, perform an analysis of our own personal experience, and recognize repetitive actions that could benefit from automation. So
he indisputable appeal of Web services will drive most organizations to evaluate development platforms such as .NET. However, security concerns have always made organizations reluctant to embrace new technologies. Fortunately,
oogle has introduced a Web API service that enables developers to program search engine functionality into their applications. With the Google Web APIs service, a program can query more than
SQL Server triggers are a powerful feature, yet they often take a backseat to stored procedures and user-defined functions?a fate they don’t deserve. A trigger can provide an easy-to-implement solution
The music industry is terrified of the Internet, which it perceives as a loosely controlled world where consumers freely distribute the content in which they have invested millions. The success
JDK 1.4 adds a number of advanced features related to I/O and filesystems. The more advanced I/O features are often non-portable or only partially portable. File locking is one of
cripting languages exist because some programming tasks are both simple and important, and carrying them out with a language that doesn’t tax the mind as much as a system programming
ith the increasing use of distributed systems, users often need to access multiple resources to finish a single business transaction. Traditionally, users have had to sign on to all these
lthough .NET makes some things more complicated, launching external programs is not one of them. In classic VB, you used the Shell function to launch an application when you passed
When was the last time you used the ASP.NET DataGrid control with something other than an ADO.NET provider? Chances are, like many developers, you haven’t. The DataGrid control has such
erhaps the most popular Java open-source tool available today is JUnit. Originally developed by Kent Beck and Eric Gamma for use in Extreme Programming, JUnit has rapidly become a standard