Question: Are there any special consideration when using an Inner Join and two of the same tables, one used as an alias? What is the ANSI SQL-specific syntax for Inner

Question: I would like to know how to take the information entered into a form, by a user, then both e-mail and the submitted results of that form and insert

Microsoft’s Internet Explorer 3.02 and above supports a BGPROPERTIES attribute that when set to “fixed” modifies the behavior of the background image to act as a watermark instead of scrolling

You can programmatically find out how long SQL Server has been running by getting this information from the sysprocesses table. Sysprocesses is a table in the master database that contains

The simplest way to create a timer in Java is to use the static sleep() method on the Thread class. This code shows a main class that has a while

Question: I have an app exposing a connector class that returns a reference to a single internal global object. This app runs continuously and I want to display status info

Question: I am creating a site with a public area and a secure area, which is broken into three parts. To enter security, the user goes to LogIn.htm and enters

Question: I want to activate those small popup windows (the ones that appear when you hold your mouse over a program icon in the Taskbar to tell you what appears

Question: How can I add resources to an EXE or DLL? I am using Delphi 3 at the moment. For example, I want to use a new Cursor (a self

Question: I created the main search screen form SearchScrn (fsNormal) with the ability to create as many new forms on the fly (they are not children of MDI form) as

Question: I have an ASP that records a text of notes created by a user. I save this note in a database along with a date&time stamp. If the client

Question: I want to retrieve the system date and convert it to a text string. I can get the system date (using the Date() function call), but I cannot write

Question: I have two forms on my ASP page. The first form uses the &qout;Post” Method and second uses the &qout;Get” Method. The form using the “Get” method has a

Question: I created an ASP that uses VB script to access an Access 97 database in a test environment. Here is the query used: “select * FROM property WHERE user

In a high-volume application, there’s a good chance that two separate transactions will both run the SELECT statement and acquire read locks before either can acquire the write lock required

Question: I have a mailing list with one record per person, but I want to mail to only one person per household. How can I select just the first record

Question: What is RDBMS? Answer: It’s lingo for “Relational Data Base Management System.”

Question: Do you know any good Web sites or have any tech tips on creating wizard interfaces? Answer: Creating wizard interfaces is straight-forward when you know how. All a wizard

Question: I have a difficult time using PB because I can’t see the code flow. I am an experienced programmer with COBOL, PL/1, and SQL and have taken several PB

Private Type POINTAPI x As Long y As LongEnd TypePrivate Type MSGTYPE hWnd As Long message As Long wParam As Long lParam As Long time As Long pt As POINTAPIEnd

Private Type POINTAPI x As Long y As LongEnd TypePrivate Type MSGTYPE hWnd As Long message As Long wParam As Long lParam As Long time As Long pt As POINTAPIEnd

‘ convert from binary to decimal” NOTE: requires Power2()Function BinToDec(value As String) As Long Dim result As Long, i As Integer, exponent As Integer For i = Len(value) To 1

‘ A clone of VB6’s InstrRev function (including its quirks)’ that works under VB4 and VB5Function InstrRev(StringCheck As String, StringMatch As String, _ Optional Start As Long = -1, Optional

‘ Converts a reference to a file in the standard Windows’ format (e.g. “H:ServerDirFilename.ext”) in the corresponding UNC’ format (e.g. “\ServerNameExportedDirServerDirFileName.txt”)” It turns to be very useful when a program

‘ convert from decimal to binary’ if you pass the Digits argument, the result is truncated’ to that number of digits” NOTE: requires Power2()Function Bin(ByVal value As Long, Optional digits

In T-SQL control statements, you can use the WAITFOR command to delay the execution of a T-SQL batch statement block, stored procedure, or transaction. When you specify the DELAY keyword,

When you use operator typeid, the class type of its argument must be completely defined. This means that a forward declaration of the argument’s base class is insufficient, as in

For humans, the time_t value is unintelligible. The Standard Library defines the struct tm that can represent date and time in a more readable form. The struct tm is declared

In C and C++, time is stored as a positive integer that contains the number of seconds elapsed since January 1st, 1970. The standard type time_t (defined in the header

The C++ Standard Library uses the ANSI C date and time library. Fortunately, the functions and data structures are Y2K compliant, so legacy code that was written nearly 30 years