Since 1998, DevX has helped people start businesses, build websites, and provide enterprise technology to people globally. Interviewing the likes of Microsoft’s co-founder, Steve Ballmer, the publication brings comprehensive, reliable, and accessible insights to the Internet.
We often come across situations where we have to rank things/persons based on certain criteria, such as ranking Students based on their scores.Take, for example, a SCORES table with two
A compact way of handling null database fields is as follows: txtText1.text = Format(rs!Field) If rs!Field is null, Format(rs!Field) will resolve to an empty string.Otherwise the value in the recordset
Handle dialogs with one line of code by encapsulating the show method within the form in a public function. This makes the form/dialog reusable and simpler to implement and update.
An alternate, convenient way to view recordsets in debug mode is to persist a recordset to disk using rs.save MyFileUNC.ADTG in the immediate window. Note that the file must be
This tip can be used as a Select Case statement with a MsgBox statement. Because a variable is not used to hold the response, adding one or more handles for
Shipping custom controls with their own set of popup menu items make the controls appear appropriately professional. They add ease of use, functionality and value to the control(s). Here’s how
This piece of code lets you display an item in a list box as that list box’s tooltip. Private Sub lstItems_MouseMove(Button As Integer, Shift As Integer, X As Single, Y
If you are unsuccessful at attempting to bind to an object residing in a Netscape Directory Server and you are using ADSI in VB or VBscript, you are likely using
This is one of the simplest, but most powerful, ways to make a form scrollable. This method automatically disables or enables scrollbars according to the size of the area in
Many programmers use Visual Basic’s Clipboard object to perform Cutting, Copying, Pasting and Undoing code. For example, to copy some text from a textbox, programmers sometimes use the following code:
Sometimes there is a need to group records into two larger categories, regardless of all other groupings. Using the Northwind database for an example, let
‘——————————————————-‘ The CTREEVIEWEDIT Class module” This class lets you use a regular TextBox control to’ edit a treeview node’s label. All you have to do to’ use this class is
Often, properties and methods associated with grid controls don’t provide an absolute (relative to the actual first row and not the first displayed row) row index of current or selected
By using resource file, strings used by controls or message windows can be converted to different language strings in your application. The VB 6 Resource Editor allows the addition of
During the preprocessing phase, you can report errors by using the #error preprocessor directive. For example, suppose you have a program that uses 64-bit integers. This program has to be
Although the library was deprecated for several years, many C++ users still use it in new code instead of using the newer, standard compliant library. What are the differences between
To generate random floating numbers, choose a floating point number, divide it by the largest value of int type and multiply the result by the value of a function that
C++ requires that the size of an array be a constant integral expression. However, the following code refuses to compile: // in const.hextern const int ID_LENGTH; // declaration// in const.cppconst
You can override the default number of digits after the decimal point by calling the precision() member function of an ostream object. The following program first displays six digits after
To create an iterator of a vector, you have to use a vector specialization. In the following examples, I create two vector iterators: one for the specialization vector and another
By default, cout displays integral values as decimal numbers. You can override this setting and have integral values displayed in hexadecimal and octal notations by using the ‘hex’ and ‘oct’
In C++, pointers are strongly-typed. Therefore, you can’t assign a void pointer to any other pointer type without casting it explicitly: int n;void *p = &n;int *pi=static_cast< int* >(p);//C++ requires
C++ guarantees that operator delete checks its argument for null-ness. If the argument is 0, the delete expression has no effect. In other words, deleting a null pointer is a
By default, iostream objects are set to display floating point values in fixed notation. To change this, you apply the ‘scientific’ manipulator to an output stream object: #include using namespace
You can determine the line where the caret is in a multiline TextBox control by sending the control a EM_LINEFROMCHAR message, as follows: Private Declare Function SendMessage Lib “user32” Alias
f you have been following this series of articles, you know the problems with date data entry and the proposed a pop-up calendar solution that allows a user to pick
n a previous 10-Minute Solution, “New PL/SQL Features in Oracle 8i: Part I,” I write that Oracle PL/SQL programmers develop complex code nowadays, utilizing custom and Oracle-supplied packages. It therefore
ith all the hype that servlets, JSPs, EJBs, and distributed J2EE applications have received, the art of creating a basic interactive command line Java application has been lost. Although fancy
ne of the inherent difficulties in backup and contingency planning is that it usually takes only one thing to go wrong to bring down your entire system. To be truly











