The Latest

DevX - Software Development Resource

Creating menu items in a running program

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?

DevX - Software Development Resource

SQL Statement

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

DevX - Software Development Resource

Slow view with lots of calculations

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

DevX - Software Development Resource

Table Name Substitution with a variable

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

DevX - Software Development Resource

SQL 6.5 or 7.0 Identity Problem

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

DevX - Software Development Resource

Execution parameter

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

DevX - Software Development Resource

Power Builder 6.5 Install Builder Tools

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

DevX - Software Development Resource

Export Data to Excel Example Array Arguments

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

DevX - Software Development Resource

Rowscopy function fails

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

DevX - Software Development Resource

Excel Export Group Data

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

DevX - Software Development Resource

Data level security

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

DevX - Software Development Resource

Shifting the Focus in a JavaScript Rollover

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

DevX - Software Development Resource

Record Locking using LockEdits

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

DevX - Software Development Resource

Resources on Compatibility Across Browsers

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

DevX - Software Development Resource

Find() function matching date values

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

DevX - Software Development Resource

DeleteRow(0) in DW

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

DevX - Software Development Resource

How Can I Tell if a Sheet is Open

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

DevX - Software Development Resource

Overload New and Delete in a Class

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

DevX - Software Development Resource

A Basic Output Stream Wrapper Class

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

DevX - Software Development Resource

Various Forms of Initializing std::string

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

DevX - Software Development Resource

Internationalize Your Dates

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

DevX - Software Development Resource

Forward Declarations and Templates

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

DevX - Software Development Resource

Use MaxFileSize With Openfile Common Dialogs

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

DevX - Software Development Resource

Label Loops in JavaScript

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

DevX - Software Development Resource

Install the Toolbar Wizard

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

DevX - Software Development Resource

Don’t Duplicate ImageList Controls

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

DevX - Software Development Resource

Converting

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

DevX - Software Development Resource

Read-only members

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

DevX - Software Development Resource

List NT Users on Domain

Question: How do I list all the users on an NT domain with Visual Basic? Answer: The following code should get you started. Note that you need to add good