Question: I’m trying to get something like this to work. How can I take the output of a stored procedure and use it in a subquery? create procedure pcore asselect

Question: We use SQL Server 6.5 (7 in a few weeks). I’m looking for a good tool to generate ERDs and overviews of my database tables. Which software can you

Question: My PowerBuilder application is a contact system. It includes a case-based reasoning system that uses customer account numbers to guide users through actions. I need to be able to

Question: How does one change the current working directory of a Java program or a java.lang.Process? The equivalent of the Unix chdir system call seems to be absent. Answer: There

Question: I’m building an application where the user can type several lines of text and save it to disk (as plain text). It would be nice if some words appeared

Question: I have a server application that I want an applet client to connect with. How can the applet determine the address of the originating serverwithout having to hard-code the

Question: Given a reference to an object B that is a subclass of A and overrides method foo(), is there any way I can invoke the base implementation of foo()

Question: I’m doing a select statement within a stored procedure, which returns several columns. I would like to assign a random number to each column, but when I use the

With embedded combinations of loops, conditions, and try / catch statements, it can be difficult to keep track of where each section ends when quickly scanning your Java code, even

When writing javadoc-style comments, use HTML tags to improve the readability of the generated documented. For example: /** * This is the first paragraph. * This is the second paragraph.

If you have two or more classes that need to share some constant value(s), but you want the classes to be independent of each other, define the constant values in

Good design goes hand in hand with the nomenclature it uses for exchanging that design between developers. A key feature to writing good code consists of good naming conventions and

It is an error to call the member function pop() on an empty stack. If you are not sure whether a stack contains any elements, you can use the member

An uninitialized pointer has an indeterminate value. It’s almost impossible to test subsequently whether such a pointer is valid, especially if it is passed as an argument to a function,

When creating menu items and adding them to a menu, you can shorten your code by combining two steps into one. Instead of creating the menu item and adding it

C and C++ make a clear-cut distinction between two types of pointers: data pointers and function pointers. A function pointer embodies several constituents such as the list of arguments, a

A pure virtual function is merely an interface and can be thought of as a way to enforce policy. A pure virtual function should be used when subclasses implement the

You can use affixes to help the compiler figure out the correct type of a hard coded integer. The letter L affixed to a number indicates a long integer and

An elaborated type specifier is a type name preceded by one of the keywords: enum, struct, union, and class. You can use an elaborated type specifier to instantiate an object

Standard C defines the function bsearch, which performs a binary search on an array of elements. The function bsearch is very efficient, but it works only on sorted arrays. You

It is illegal to assign the address of a static class member to a pointer to member. However, you can take the address of a static member function of a

When a container reallocates its elements, their addresses change correspondingly. Consequently, the values of existing iterators are invalidated: #include #include using namespace std;void main() { list payroll; payroll.push_back(5000.00); list::iterator p

You can define a pointer to a class template member. For example, you can use the specialization vector: typedef void (vector< int >::*v_vi_szt) (size_t); // v_vi_szt is used to hide

All STL (Standard Template Library) containers provide the begin()/end() pair of member functions. The member function begin() returns an iterator that points to the first element of the container: vector

Java’s reflection API allows the instantiation of an object using only its String description. A Java application can determine the class of an object from the associated string and then

In Java, the keyword final qualifies a construct (class, variable, or method) that may not be changed or overridden. Qualifying a variable as final ensures that the variable may not

The gc() call on the Java Virtual Machine’s garbage collector is often misunderstood. One of the reasons Java is such an easy language to program in is that it takes

The Vector class in java.util is one of the most frequently used classes in Java development. It almost makes the problem of memory management non-existent, unlike a fixed-size array. However,

A thrown exception is guaranteed to be caught

It’s easy to change the background color of your page, but if you don’t also define the foreground color and link colors, it’s likely that some users will not be