Tip Bank

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: 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: 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’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 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 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 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