Question: In a project tracking database, one of the columns in a table contains the date in this format: MM/DD/YY. I would like to be able to see a listing

Question: Using the following SQL statement, I could export a select query into a dbf file at c: emp est.dbf INSERT INTO test IN ‘C: emp’ ‘DBASE IV;’ SELECT *

Question: Is Powerbuilder 5.0 year 2000 compatible? Answer: Only PowerBuilder 5.0.4 and 6.0 are year 2000 compliant.

Question: How can I select the whole row (with a bigger blue line) in a listview control? The default selects just the item located in the first column. Answer: That

Question: I want to print a line at the detail band onlyif it’s on the last row of the page; otherwise, itshould not print at all. Answer: To achieve this,

Question: I am getting all kinds of errors on a database table that have something to do with page allocation in the database (error 1109). I would like to drop

Question: How do I set the socket input and output buffer sizes in Java? Answer: You cannot set the socket input and output buffer sizes in Java versions prior to

Question: Is there a way to put the text editing cursor in a specific position, like at the end of the string, in a TextField? Answer: This is the sort

Question: What are the types of features available and its respective characteristics? How does this language help in relational databases? Answer: May I suggest you obtain Joe Celko’s introductory book

Question: SQL Server 6.5 does not allow an index to be placed on the bit datatype. Does this affect performance when doing queries that filter on the bit, or are

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