Question: What is the difference between static and dynamic SQL? For that matter, what are they? Answer: Static SQL statements are embedded in the source code of a program. They

Question: I have a client that has a massively disorganized set of linked databases in Elustra on a UNIX server. They want to take everything, convert it to SQL, and

Question: I am using VFP 5.0. When I create an EXE file, how can I get my own icon associated with it? (instead of a Fox head) Answer: First, when

Question: Is there any way to change the ownership of files and directories with scripts or programs? Answer: You can use the SubInAcl.exe file (included in the NT 4.0 Resource

Question: I have been asked to develop a database of imagery from a company’s slide collection that needs to be incorporated into a Web site. Does SQL support binary files?

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