The Latest

DevX - Software Development Resource

Netscape Navigator Does Not Support createElement

Question: Does Netscape Navigator 4.5 offer a function similar to Internet Explorer’s createElement? I’d like to add an option to a listbox using client scripting. Answer: Netscape Navigator does not

DevX - Software Development Resource

VB – Copying Directories

Question: is there a way I can programmatically copy directories from one drive to another? Answer: The easiest way to do it is by using the File Scripting objects exposed

DevX - Software Development Resource

Week of the Year

Question: How can i find out the week number of the year in Visual Basic? Answer: This is easy to do using the DateDiff function. The DateDiff function can calculate

DevX - Software Development Resource

Popup Menu

Question: I wish to add my application to the popup menu that you get in Windows 95/98. I am referring to the menu that pops up whenever you click on

DevX - Software Development Resource

Registering Apps as services

Question: I am trying to hide my application from the task manager in Windows NT 4.0. I have tried registering the app as a service, but this appears to have

DevX - Software Development Resource

Floating Window

Question: I have an app that has an MDI form (MDIForm1), one MDIChild form (Form1), and one standard form (Form2). I would like to make Form2 a floating one so

DevX - Software Development Resource

byref variables in ActiveX component events

Question: I am creating an ActiveX DLL and I want to be able to fire events that can be cancelled similiarly to cancelling the Unload event for a form. however,

DevX - Software Development Resource

FoxmedPro vs. Microsoft SQL

Question: I work for a VAR selling a SQL physician pratice management software product. My competition is a program that uses Foxmed Pro. What advantages does each product have, if,

DevX - Software Development Resource

Client/Server

Question: I have a Visual FoxPro 5.0a application running on Windows NT 4.0 workstation on all machines. Most of the stores have at least two workstations using peer-to-peer networking. The

DevX - Software Development Resource

VFP Grid Control

Question: How can I freeze the left-most column in a multicolumn grid? Normally when you scan records to the right side of the grid, you lose the information on the

DevX - Software Development Resource

Deprecating Classes and Methods

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

DevX - Software Development Resource

Retrieving database table names using SQL

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

DevX - Software Development Resource

General Programming

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.

DevX - Software Development Resource

Dates

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?

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