Question: select issuelog.analysts,issuelog.helpdesk,isssuelog.issue.issuelog.customer.issuelog.status.issuelog.logged,issuelog.date FROM issuelogWHERE(((issuelog.date)like “*24/01/99*”))ORDER BY issuelog.helpdesk; How do I get it to search for a series of dates, such as the 24th, 25th, 26th etc., in one query?

Question: Is it possible for a running program to dynamically create/add a menu or add a specific item to an existing menu based on an action by the program user?

Question: I have a statement: “Select * from table order by price DESC” but I want only the top 50 price products, not all the list ordered by price. How

Question: I created a view that does a lot of calculations and references several tables. If I do a select * from linkview everything comes up instantaneosly. However, if I

Question: I have data that is broken into multiple tables depending on the month. For example: 99jan table99feb table These tables are all built the same and are very large

Question: I want to use replication between two SQL servers in which I used Identity properties in some tables. How can I preserve data integrity and maintain my application functionality

Question: I want to run my VB5 app with different parameters, for example, like this: c:Myapp.exe -C to run in a mode I want to call “config-mode.” Is this possible

Question: Where is the install builder (how to make the app standalone)? Answer: PowerBuilder 6+ includes the install shield lite edition, which you can use to build installation scripts for

Question: “Export Data to Excel Through OLE Automation: A 10-Minute Solution” says: “Refer to the section of the description: … Create a function called GetColumns, which accepts two arguments, a

Question: I’m trying just simply to copy rows from one datastore to another. They both have the same Dataobject set. I know that the source datastore has two rows, but

Question: I used your Excle OLE Automation and it works great! Is there any way to capture subtotals? Excel captures only what is in the primary buffer. When I retrieve

Question: My environment is Win95, PB6.5, and Sybase SQL Server 11.0x. The table consists of entity, center, account, name, dollars, and hours. I need to be able to restrict access

Question: I am creating a complex table of images, each with its own rollover effect. The problem I’m experiencing is that after the user clicks on the image, it retains

Question: I am developing a multiuser application in Visual Basic 4.0 and wish to restrict users from editing Open or Locked records. Having successfully set up user security access and

Question: I am involved in a project that requires the client-side embedded scripts to be compatible down to version 3 of Internet Explorer and Netscape Navigator. So far I have

Question: I am trying to use the find function using three char expressions and one date expression. I am using PB 6.5 with Oracle as the database. The following is

Question: Does DeleteRow(0) delete the current row or the row at the bottom of the datawindow? Answer: It deletes the current row.

Question: How can I check if a certain sheet is Open? Answer: PowerBuilder stores a list of all the currently open sheets automatically for you. You can use the GetFirstSheet

It is possible to override the global operators new and delete for a given class. For example, you can use this technique to override the default behavior of operator new

When writing a program, you often need flexibility in where the trace/log output of the program is supposed to go. It could go to standard output, a log file, or

Class std::string can be initialized in five forms: by a C-string, by part of a C-string, by another string object, by a sequence of characters, or by part of another

Those unexplained errors you get when working with Internet Information Server (IIS) using the Microsoft Management Console (MMC) might stem from corruption in the IIS metabase. The IIS metabase stores

Although the Gregorian calendar is used by most of the world, the specific way in which dates are formatted varies from one place to another. In the United States, for

It is illegal to use forward declarations with typedef names, as in: class string; void f(string& s); //illegal, string is a typedef name Even a typename won’t do here: typename

When working with OpenFile common dialogs, set a large value for the MaxFileSize property, which affects the maximum length of the string returned in the FileName property. This is the

You can refer to named functions from anywhere within a JavaScript program by calling them by name. Sometimes it’s useful to be able to do the same for statements. Any

VB6 comes with a Toolbar Wizard that lets you easily create a Toolbar control and the code that responds when users click on its buttons. However, how you install this

A common control, such as a TreeView or a ListView, can use an ImageList control placed on a form different from the current one. This is useful when many forms

Question: Are there any utilities that will convert an .EXE file back to a .CPP file? A friend wrote a little program for me, and I would like to alter

Question: If I write a class in C++, which contains private members, I can make them read-only by providing a get access method and no set access method. If that