November 16, 1999

ANSI Join vs. WHERE Clause Join

Question: Is there a technical or logical difference between using an ANSI style join and specifying the join using the WHERE clause? Is there a general preference to either method,

Multiple Linking to a Table

Question: I have a main table where there are three fields: UserID, Postal code main, Postal code sub. I have a second table where there are two fields: Postal code,

Changing the Color of Command Buttons

Question: Is there a way to make command buttons appear in the color I choose, rather than the color selected in Windows > Display Properties > Appearance > 3DObjects? Command

Preventing VFP Shutdown During Logoff

Question: I have a Visual FoxPro 5.0 application that I installed to run as a service on an NT server. Everything works fine except for when the user attempts to

Using PSTs to Enhance Performance

Question: In a site that has multiple servers (some top-of-the-line, others border-line) is it better to use PSTs (personal file folders)? In other words, does it enable Exchange to perform

Importing Gigabytes of Data from a Flat File

Question: I’m currently working on a data warehousing application using SQL Server 7. The problem I have is that I have to import 610,000 records of mainframe data per day

Basic FoxPro SQL

Question: I’m trying to retrieve eight fields from four FoxPro tables via on-the-fly SQL from an ASP page… and I’m not familiar with FoxPro SQL. The following doesn’t work, but

Changing Outlook’s Default E-mail Message

Question: I want to change the format of the default e-mail message (IPM.Note). I have created a new form, but want it used whenever the user selects “New Message.” (I