
The Trouble with Triggers, Part II
et’s talk about when and why we use triggers and the technical details of how to write a trigger. To recap, a trigger is a stored piece of code that

et’s talk about when and why we use triggers and the technical details of how to write a trigger. To recap, a trigger is a stored piece of code that

Here’s a Visual Basic routine that invokes the default browser: Private Declare Function ShellExecute Lib”shell32.dll” Alias “ShellExecuteA” (ByValhwnd As Long, ByVal lpOperation As String,ByVal lpFile As String, ByVal lpParametersAs String,

Normally, from within a Java applet you can create a java.net.URL instance using the “ftp://” protocol handler. But you may need a third-party library to access FTP from a Java

Using the Date functionality in JavaScript, you can post the number of days left until a certain date. Internally, JavaScript stores dates as the number of milliseconds from midnight (GMT)

Although the new VB5 Application Wizard can build a shell application with an Explorer-like interface, it is often desirable to drop a quick Explorer form into your code without the

Question: I am creating my own in-process ActiveX DLL in VB. I want to create an instance of the object in one of my ASP pages. My problem is that

Question: For EVERY filename present on a hard drive, I need to convert the path and filename to a string and then evaluate the string for certain conditions. If those

Question: Hi, I have set up SMTP and I’m trying to send e-mail. It appears to work, and reports no errors, but the mail is not sent to the recipient,

Question: I have numerous data analysis programs written in VB4/5 that I would like to put on a server for server-based data analysis. It would require uploading data files from

When utilizing project management tools, create a timeline template that models your development methodology. Set up the dependencies and defaults within this template. Then you can copy and paste it

Set up a task in your scheduler of choice to run the ANALYZE.EXE programagainst your Visual Source Safe (VSS) database at least once a month.This tool allows VSS to check

Utilizing version control systems is very important, but if no one is backing up your version control database, you are needlessly stepping close to the brink of disaster. Most source

If you develop applications that use components that need to be registered, consider setting up a shortcut to regsvr32 in the “Send To” folder on a user’s machine as part

Macros in C++ are better avoided. They are unsafe, hard to debug, and may bloat your .exe files. C++ offers significantly better alternatives to them: 1. Function-like macros should be

A non-explicit constructor taking a single argument is also a conversion operator, which casts its argument to an object of the constructor’s class. When the compiler has to resolve an

When two or more classes serve as base classes in multiple inheritance, you want to choose a distinct name for each member function in order to avoid name ambiguity: class

Void * can serve as a generic data pointer, yet it suffers from the well-known ailments associated with pointers: it can be NULL or a dangling pointer. Furthermore, it usually

Like ordinary functions, templates can have default type arguments. A good example is STL’s vector. It actually has two arguments–the second one is an allocator class template. Since an allocator

To allow the user to control long operations, use a single CommandButton to control starting and stopping a looping process: Dim Running As BooleanPrivate Sub CmdStartStop_Click() If Running Then ‘

It’s fairly common practice to add buttons to your date and numeric fields to allow users to select and display a popup calendar or calculator. However, to display a calculator

The algorithm shown in the tip, “Swap Values Using Only Two Variables” [“101 Tech Tips for VB Developers, Supplement to the February 1997 issue of VBPJ, page 25], crashes not

Arrays take less memory and are faster than collections. If you don’t need to use a collection’s keyed lookup, easy extensibility, and other features, use an array instead. Related Posts

You can create complex shapes easily if you have a copy of Microsoft PowerPoint, CorelDraw, or any other graphics editor. Using your graphic editor’s drawing tools, draw the shape you

When creating applications, especially on an enterprise scale, don’t create them so that they run start to finish, tying up the user’s PC needlessly. If all you need is two

Question: I’ve developed a database using Microsoft Access, exporting the files to a Paradox 5 format. Now, the application I’ve developed that utilizes this database is currently running on two

Question: I am using the application.onhint example from the Delphi help files to put all hints in my status bar. It works on all but one form. I’m using the

Question: Is there a way to keep users from selecting, cutting, or copying text in HTML within a browser window? Or is there a way to embed text within HTML

Question: As a Web designer, one of my biggest struggles is JavaScript compatibility with previous browser versions (such as IE3, IE4, N2, N3, and N4). Is there a way I

Question: I’m trying to make outer join by the query builder in Delphi 2.0 but the only active option is inner join. I want to use left outer join and

Question: I want to be able to run an EXE file on a button click in one of my Delphi applications. Is it possible to do this? Where do I