The Latest

DevX - Software Development Resource

The hidden Collect method of the Recordset object

The ADO Recorset object exposes a hidden, undocumented member: the Collect property. This property is functionally similar to the Field’s Value property, but it’s faster because it doesn’t need a

DevX - Software Development Resource

Cursors in Informix

Question: What is the purpose of using the fetch and declare cursor in Informix.4GL?How do you use the scroll cursor, and what are its advantages? Answer: Cursors allow you to

DevX - Software Development Resource

Running Ace Reports from Within 4GL

Question: My ace report/shell script did not wait for user intervention. I have solved that with: script.sh < mytty > mytty But now the screen needs refreshing with a CTRL-R.

DevX - Software Development Resource

Receiving Mail from the Internet

Question: How can I place my Exchange Server on a network with private addresses and have my MX record point to the server even though the server is behind a

DevX - Software Development Resource

Backup Exchange in Windows 2000

Question: I have a Windows 2000 server where I have installed the Exchange Server 5.5 Service Pack 3. I want to do a backup, but the Exchange option is empty

DevX - Software Development Resource

Redirecting E-Mail

Question: How can I redirect mail sent to a particular mailbox to an external address? Answer: Outlook 2000 has the ability, in the Rules Wizard, to redirect mail. You’ll find

DevX - Software Development Resource

Create a Table with Autonumbering

Question: I’ve tried to create a table (for my guestbook) with an auto increment column. Here’s my statement: CREATE TABLE guestbook(id mediumint(8) NOT NULL KEY(PRI) default(0) auto_increment, name varchar(30) NOT

DevX - Software Development Resource

Retrieving Messages After Restore

Question: This weekend I did a restore of my Information store. I had to do a repairmidway through. This morning, a few people have told me they can’t opensome mail

DevX - Software Development Resource

Embedding Applets in XML Documents

I came across this solution while trying to embed an applet in an XSL page I was using to transform my XML source document into HTML.If you want to cut

DevX - Software Development Resource

MinimizeAllWindows – Minimize and restore all windows

Private Declare Function FindWindow Lib “user32” Alias “FindWindowA” (ByVal _ lpClassName As String, ByVal lpWindowName As String) As Long Private Declare Function SendMessage Lib “user32” Alias “SendMessageA” (ByVal _ hwnd

DevX - Software Development Resource

Let the user copy floppy disks

The simplest way to help user copy a floppy disk is display the Copy Disk system dialog. You can do this with a one-line statement: Shell “rundll32.exe diskcopy.dll,DiskCopyRunDll 0,0” Related

DevX - Software Development Resource

MaxSystemColors – The number of screen colors

Private Declare Function GetDesktopWindow Lib “user32” () As LongPrivate Declare Function GetDC Lib “user32” (ByVal hWnd As Long) As LongPrivate Declare Function ReleaseDC Lib “user32” (ByVal hWnd As Long, _

DevX - Software Development Resource

ASP

Question: I’m working with ASP to retrieve records, but I keep getting an “Unexpected Error” near my recordset function. Why? Answer: Pinpointing exactly what’s wrong would be hard without actually

DevX - Software Development Resource

Exchange Server Backups

Question: What is the best Backup Software available that will do a live backup of the Exchange Information Stores? Answer: I haven’t evaluated all of them, but we’ve been satisfied

DevX - Software Development Resource

Current Time in Query

Question: Can I include something in the title line of a query to include the current date/time? Answer: You can use the GETDATE() function to return the current date and

DevX - Software Development Resource

Help Files in Applications

Question: I created a “help” button in a form and coded this button’s click event as: { help } The code { set help to MyHelp.chm }is included in the

DevX - Software Development Resource

ASP and WML

Question: Suppose I wanted to setup the IIS 4.0 to process the WML with ASP codes. Which MIME type should I configure: text/vnd.wap.wml or text/x-wap.wml? What is the difference between

DevX - Software Development Resource

Wireless Transmission of Photos

Question: About how fast can the current wireless systems transmit a medium- to high-resolution digital photo? What’s currently the best way to do it? Will higher baud rates of wireless

DevX - Software Development Resource

Creating an Application Setup Wizard

Question: How do I create an Application Setup Wizard from Visual FoxPro? Answer: VFP ships with a Setup Wizard, which builds three different types of installations: Standalone, Network, and Web.

DevX - Software Development Resource

Send in a Different Account in Outlook

Question: I’ve installed Exchange Server, and I’ve installed Outlook 2000 in the client, which is receiving email from POP3 accounts and three accounts from Exchange Server. How can I choose

DevX - Software Development Resource

Remote Access Via the Internet

Question: We are a small company of some 70 staff, 50 of which are located away from the office (clients site, home, etc.). I am about to migrate from Microsoft

DevX - Software Development Resource

Scheduling a Conference Room with Exchange

Question: How do you set up Outlook 2000 and Exchange 5.5 to use resource scheduling accounts, such as conference rooms? There are several posts about how to do this without

DevX - Software Development Resource

Exchange Mail Storage

Question: I have an attorney client who wants to have all his e-mail stored on his local workstation, not on the Microsoft Exchange 5.5 SP2 Server. In fact, he would

DevX - Software Development Resource

Broadcast Messages to Online Users Only

Question: Is there any way in Outlook/Exchange to send out a message to all users currently logged on (like a network broadcast)? We currently send system announcements (such as for