Question: When using PowerBuilder as a front end for doing SQL queries, I get the following pop-up message when I look for someone with a single quote in their name

Question: I am currently writing a generic system where user object names are stored in a database and instantiated upon request. This is currently working beautifully, but I fall short

Question: What is the standard rule on access specifiers associated with superclasses? Old C++ compilers would not allow protected superclasses. But, the book I’ve read about OOAD allows it. Example:

Question: Is there a compatibility problem between users with Exchange 4.0 as their home server and users with Exchange 5.5 as their home server? As a user who has Exchange

Question: What does “Today – @sub” equate to in Oracle and what does it mean? Answer: It doesn’t look like anything in Informix, and I couldn’t find any reference on

‘ Convert a number into its textual equivalent.’ ‘ Pass True in the second argument if you want a null string when ‘ zero is passed.’ This is a recursive

‘ The Soundex code of an alphabetical string” you can use Soundex code for phonetic searches’ Beware: this isn’t bullet-proof!” UPDATE: this version corrects a bug in the original routine’

‘ Strip all extended ASCII characters’ (that is, all characters whose ASCII code is > 127)’Function StripExtendedASCII(source As String) As String Dim index As Long Dim bytes() As Byte ‘

‘ Return the next occurrence of a whole wordFunction InstrWord(start, Text, search, compareMethod) As Long Dim index As Long Dim charcode As Integer ‘ assume the search fails InstrWord =

‘ Replace a whole wordFunction ReplaceWord(Source As String, Find As String, ReplaceStr As String, _ Optional ByVal Start As Long = 1, Optional Count As Long = -1, _ Optional

If you execute a SQL statement in a stored procedure after your use the RAISERROR command, you will clear @@ERROR. This is true even if you use a RETURN and

Beginners are sometimes stymied when they get error messages on code that works perfectly elsewhere. For example, this code produces the error message, “Cannot use parentheses when calling a Sub”:

I often go to a site, scroll to the bottom, and see when it was last modified. If it says “March 1, 1825” then I am usually not so confident

Question: I want to create a three-tier application that has a browser front end and a Visual Basic middle-tier. How do I access my VB code from ASP? Should I

Question: We have an ASP page that displays product information from a database. We also have a button to download/view a related PDF file that should only appear on the

Question: I have data (text + CR + LF) stored in SQL Server 6.5 as a TEXT data type. When I want to display the data on an ASP page,

import java.util.*;import java.io.*;class Class1 { static Vector split(String string,String delimiter) { //StringTokenizer that works with empty strings boolean wasDelimiter=true; String token=null; Vector vector=new Vector(); if(string!=null) for(StringTokenizer stringTokenizer=new StringTokenizer(string,delimiter,true);stringTokenizer.hasMoreTokens();) { if((token=stringTokenizer.nextToken()).equals(delimiter))

The JComboBox API provides a programmer with very little directcontrol over how list items are displayed. This is because, in trueobject-oriented fashion, a JComboBox object knows or cares very littleabout

This tip is probably cosmetic, but it could result in great convenience. Doing a [import java.package.*] would allow usage of [public] classes in theaforementioned package without the usual required verbosity.

At times you want to output the numeric values in specific format, for example, you may want to display monetary value with two decimal points, or scientific data with five

I have been working on Java Servlets and HTML for quite a long time and have always had a problem keeping HTML code separate from Java code, but now I’ve

If you usually load many controls into your VB project during development, you often have controls loaded that aren’t used any more by the time the project’s finished. If the

You often have to test for multiple conditions when enabling a confirmation button or other control that commits user input. Instead of using complex If…ElseIf statements or inline If functions,

You’ve noticed how some apps display forms and toolboxes in the same location and size as when you last closed them. Here’s some simple code that gives your VB app

Most of us have a routine we call to autohighlight the entire contents of a textbox when it receives focus. And most of us type the name of the textbox

Use this fast function to test for the occurrence of nonalphanumeric characters in a string: Private Declare Function StrSpn Lib “SHLWAPI” Alias _ “StrSpnW” (ByVal psz As Long, ByVal pszSet

Sometimes you need to display information longer than the biggest textbox or label control you can have onscreen. I’ve written a routine that displays a textbox’s or label’s contents in