It’s often desirable to replace a class or method with one that provides similar or identical functionality. This could be because the implementation has been improved, or simply because a

Many Web sites publish useful data that you may want to retrieve and post on your own Web pages. The Microsoft Internet Transfer Control (Inet) provides a way for your

Question: I’m a database administrator for a medium-sized company. I would like to be able to retrieve the names of the tables within the company’s database using SQL so that

Question: I want to create a function that will calculate four values. I want to return these four values as an array back to an array in the main procedure.

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. Related Posts New Versions of DACs for RAD

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