Question: I have a table like this one: Day_Period_Money (daydate date, period number, amount number); Here is an example of some data: daydate period amount01/01/99 1 1001/01/99 2 2001/01/99 3

Question: How do I get a query to return only a certain number of rows? For instance, a search criterion might return 100 rows, but I only want to see

Question: Since there are no pointers in Java why is there aNullPointerException? Answer: It is a bit misleading to say that Java does not have pointers.Reference variables are very similar

Question: I have tried the following code: SELECT distinct title, id from table where …..order by title and it returns: A 001A 002B 003 The result I want is: A

Question: I have a table with five columns. They are “No. of People,” “Tour1,” Tour2,” “Tour3,” and “Tour4.” I want to set up a query that shows me how many

Question: I’d like incorporate an inactivity timeout for an application.When there is no mouse or keyboard activity in the application fora certain period of time, I want to close all

Question: I’ve got an Excel workbook composed by a series of pages (worksheets). One of them is called ‘Wholesales’. I’ve tried to retrieve values even with basic syntax: select *

Question: I am in the process of creating an n-tier database application and am stuck at storing images to the SQL Server database. Any help would be appreciated. Obviously, I

Question: What is the SQL standard for concatenation? Answer: In SQL Server, you can do something like SELECT “Me” + “You” gets you MeYou In Oracle, I believe the symbol

Question: How do I perform a word search in SQL? I want to find all rows containing the word “time” by itself and not any rows containing “time” as part

Question: I have a table that contains numbers defined as varchar. How do I convert from varchar to number? Answer: Try using the CONVERT function. If that is not an

Question: I have written an ActiveX EXE. that handles Batch Reporting requirements on a large amount of data. Even though it is an Out-of-Process “server”, it still seems to execute

Question: I have a class that extends one class and implements an interface.The interface requires a getName() method.At the same time the class I am extending has a getName() functionthat

Question: I am working on a database program that will insert random data into all fields in the database. What the program is supposed to do is look for field

Question: I am creating a data warehouse and need to SELECT and INSERT data across servers using SQL Server 6.5. Is there any way I can code this in my

Question: How can I move the master and msdb database devices to another disk in SQL Server 6.5? Can I mirror them and then unmirror them, swapping to the mirror

Question: How do I create a toolbar button without also creating a menu item? Answer: Add a menu item as normal and then set the toolbar details for the menu

Question: When char data is retrieved, is there a way to display it in a certain way? An example would be a phone number. If the phone number data is

Question: Is there a way to automatically convert the date format from yymmdd to yyyymmdd? Answer: Yes there is. Check out the STYLE argument of the CONVERT function, which displays

Question: I have a number of bitmaps displayed in the Listview control. However the colors are limited and are very different when they are displayed in a graphics program. Is

Question: Can Visual FoxPro be used to develop applications for Windows CE? Answer: No, Visual FoxPro cannot be used to develop applications for Windows CE. However, you could develop VFP

Question: When I try to build an app (.exe) I get the error message “Cannot update the cursor.” All the prg, menu, and forms seem to work (i.e., compile with

Question: I am trying to send e-mail from my PowerBuilder app to an e-mail address that is not in my address book; it’s an Internet e-mail address. I do not

Question: How do I get short names for my toolbar text, but longer text for the toolbar tips? For example, I’d like the toolbar tip to read “Usage Statistics” but

Question: How do I get a message box to appear if users have not saved their work, asking them if they want to save their work? (I am using PowerBuilder

Question: I am doing calculations in reports using SQL and FoxPro 2.6 for Windows. My SQL query works fine, except for one thing. I want to display information in the

Question: When I do a property box on a file/directory, the Security sheet changes from the normal (NT4, SP0) one to a new one. Can you explain this? (I have

The fastest way to clear an array is to ReDim (if the array is dynamic) or Erase it (if the array is Static). However, if you want to clear a

By default, all TreeView controls whose version number is 4.70 or higher display the text of the node under the cursor if the node itself isn’t completely visible. You can

You probably already know that you can highlight the contents of any textbox by adding two lines of code in its GotFocus event: Private Sub Text1_GotFocus() Text1.SelStart = 0 Text1.SelLength