Question: I need to write a query that selects the maximus sum for a group from a list like the one below. Type ValueA 100B 200C 300A 300B 100C 342

Question: I have a table, called bugs. I have an insert trigger on the bugs table that generates a unique id, called bug_id. When I perform an insert into bugs,

Question: I’m trying to work on the basics of event handling. I found it easy to set one label and have the scrollbar change the value of the label. I

Question: How do I add a JButton to the cells of a JTable? Answer: Using the Swing JTable class can become a sticky business when you want to customize it

Question: For what uses can the Graphics.create() method be used? Answer: There will be cases where you want to make a copy of a Graphics context and make some alterations

Question: How can you make a canvas nonresizable? The canvas automatically resizes when the frame is resized. Answer: The default layout manager for java.awt.Frame is BorderLayout. BorderLayout will expand the

Question: I am a beginner in SQL and can’t figure out how to do this: I have two tables with three fields in the row of table1 referencing a master

Question: On a Windows NT box with multiple processors, will a multithreaded Java application get split between the processors automatically? Answer: This depends on the version and vendor of theJVM

Question: I have a frame with a few textfields on it. How can I set the focus to the first textfield? Is there something like setFocus? Answer: A component can

Question: How do I program the right mouse button to bring up a window or dialog box when I right-click on a particular button? Answer: All Java AWT components exhibit

Question: What is the correct way to backup a SQL Server database? I’m new to SQL Server and don’t know where to start. Answer: The best place to start would

Question: Is there a way to get memory allocated that is global to the current process? Thread local storage won’t do the trick because you need a global handle to

Question: Can you do operator overloading in Java? If so, how? Answer: Java does not as of yet support operator overloading, and there are no signs that it will ever

Question: In PL/SQL, the following syntax is allowed: SELECT * FROM table WHERE ROWNUM < 25 This would return the first 24 rows of a table. Is there anything equivalent

Question: Is it possible to assign an account to both SQL Server and SQL Executive and be able to log into Windows NT to perform task schedualing? I read in

Question: I’d like to write a little program that determines the type of system one has. It would be able to report, among other things, processor type, system/bios type/ver #,

Question: Is it possible to have more than one font type in a text area? I have tried, but I can only change the whole text area component. Answer: It

Question: Can a script be placed in an external JavaScript file so it doesn’t have to be placed on all 200 pages of our Web site? Answer: Yes, as long

Question: We are trying to develop an intranet application and have traversed many rough roads and dead ends. Our environment is Internet Explorer 4.0 (some IE3), SQL Server 6.5 (soon

Question: I would like to have a page that allows a user to conduct a search. I would like the action of the search to be an ASP page that

When using JavaScript in your Web pages, you should keep in mind that a user’s browser might not support JavaScript. This could either be because the browser is old or

Using JavaScript, you can set up a form such that when the Web page is loaded the cursor is in the text box. This functionality avoids making the user click

Generally, namespaces are open so it is perfectly legal to expand existing namespaces with additional declarations and definitions in several files. The only exception to the rule is namespace std.

You can use JavaScript at the top of an HTML document to detect if a frameset is loaded and if not, load the frameset. If a window’s top property points

If you’re looking for a development environment for JavaScript, JavaScript debuggers are available as a free download from both Microsoft and Netscape. The feature set of the two products is

You should pay attention when using default arguments in virtual functions. The default values in the overriding function have to be identical to the corresponding default values in the base

#including a file more than once during the same compilation session will most likely cause the compiler to issue error messages since definitions and declarations of the file are repeated.

You can use Rnd followed by Randomize to seed Visual Basic’s random number generator. Whenever you use the same seed, Rnd produces the same sequence of random numbers: Rnd -1Randomize

The “Auto-Propercase Text Box at Entry” tip [VBPJ May 1997, page 63] has a simpler solution. The StrConv function can propercase any string. You can achieve the same effect with

While developing a database front end for hand-tool management, I discovered a need to handle both fractional and decimal representations of dimensions in the same text box. This makes it