Welcome1.gif (9491 bytes)

 
1. When Q&A Won't Run on a New PC
2. How to Post to a Text or Keyword Field
3. Enter 21st Century Dates the Easy Way


When Q&A Won't Run on a New PC
(How to setup Q&A to run in Windows 95/98)

Question: We’ve been trying to install Q&A for DOS on a new Pentium PC running Windows. When we start Q&A, we receive various error messages. Since we have many years invested in Q&A, we must find a solution to this problem. We’ve called tech support at Symantec, Compaq, Microsoft and Intel, but nobody has any idea where the problem is.

Answer: Lately, many Q&A users have experienced some variation of the problem you’ve seen, so let’s cover some old ground concerning installations involving Q&A for DOS on Pentium PCs running Windows 95/98. (For issues involved in installing Q&A for DOS in Windows 2000 see www.pcta-usa.com/win2000.htm or order the May 2000 issue of The Quick Answer. Q&A for Windows will not run in Windows 2000. For issues involved in installing Q&A in Windows ME, see below.

DOS and Windows 3.x programs—as well as most 16-bit programs that claim to be Windows 95/98-compatible—won’t run properly from a hard drive partition that’s larger than 1.88G. (That could be anywhere from 1.8G to 2G depending on how you measure a gigabyte). If the computer manufacturer didn’t supply your PC with a 2G partition, you can use a program called Partition Magic* (800-379-2566, http://www.powerquest.com) to quickly and safely create a 2G partition on any size hard drive without destroying any data already on the hard drive.

*As of October 1998, the Partition Magic 4.0 upgrade can repartition hard drives larger than 8G. The earlier version was limited to hard drives under 8G and could truncate a larger drive.

For an altogether different approach to getting Q&A to run from a "too-large" hard drive partition—a solution that doesn't require repartitioning the hard drive—see Lesspace.com on the Free Downloads page. See also the "Give Me Space" tip on page 10 of the August 1998 Quick Answer.

Most newer PCs come with Windows 95 or 98 preinstalled. The best way to install Q&A on such a system is to restart the PC in MS-DOS mode (one of the options on Windows Start / Shut Down menu), and install Q&A as you normally would. Then, restart Windows (enter Win at the DOS prompt) and create your Desktop Q&A Shortcut.

To create a Q&A Shortcut, click the right mouse button on an empty space on the Windows desktop. A small menu will appear. Click New, then click Shortcut.

For the Command Line, click Browse and navigate to the directory where you installed Q&A. Select the QA.COM file and click Open. Click Next, and type in a name for the shortcut, such as Q&A DOS 5.0. Click Finish.

(Optional: If you're using Lesspace.com, you should use start Q&A with a batch file. You can name it STARTQA.BAT, and it should be in your Q&A program files directory and contain the following commands:

lesspace
c:\qa\qa.com
lesspace /U

This way, Windows will start Lesspace.com, start Q&A, then remove Lesspace.com from memory when you quit Q&A. Substitute your own path to Q&A.)

The Shortcut should appear on the desktop with a default MS-DOS icon. To change this to the Q&A icon, right-click on the icon and select Properties from the pop-up menu. Click on the Program tab, and click on Change Icon. Click Browse, navigate to your Q&A directory. Select then open the QA.ICO file, then click OK.

While you're in your Q&A Shortcut's Properties, make the following changes:

On the Program tab:
Comd Line: C:\QA5\QA.COM
(this should already show your correct path)
Close on exit
(check this box)

On the Memory tab:
Conventional = Auto
Initial Environment = Auto
Expanded Memory = 1024
Extended Memory = 1024
MS-DOS Memory = Auto

On the Misc tab:
No Screen saver
(unchecked)
No Fast Paste
(unchecked)

The Expanded memory is useful to Q&A 4.0 for DOS and crucial to Q&A 5.0 for DOS. If an Expanded memory option doesn’t appear in the Properties / Memory tab on your PC, add the following lines to your CONFIG.SYS file, reboot the machine, and everything should be fine:

DEVICE=C:\WINDOWS\HIMEM.SYS
DEVICE=C:\WINDOWS\EMM386.EXE RAM
DOS=HIGH,UMB

Note: On some Pentium III PCs, the above lines will still not give you Expanded memory. (The manufacturer might even tell you that the PC "doesn't support" Expanded memory.) In this case, see the May and July 2000 issues of The Quick Answer for possible workarounds.

Q&A 5.0 is sensitive to machine type and processor speed (Q&A 4.0 is not) and will have trouble with a Pentium II processor running faster than 180MHz (or a Pentium III) unless you install the Q&A SpeedFix 1.0 patch.

If you’re using Q&A 4.0, you don’t need to be concerned with processor speed. If you have a "plain" Pentium (not a Pentium II or MMX) running at up to 233MHz, both Q&A 4.0 and 5.0 should run just fine on it without having to install the patch.

This question and answer appears in the @Help column (edited by Gordon Meigs and Bill Halpern) of the March 1998 issue of The Quick Answer, revised here to include the Q&A SpeedFix Patch that became available in late July 1998, references to Lesspace.com, the update on PartitionMagic 4.0, creating a Q&A Desktop Shortcut, references to Windows 98 and Windows 2000, and the bit about not being able to get Expanded memory.


Q&A and Windows Me—Still Going!

(From the October 2000 issue of The Quick Answer)

Well, once again we got caught up in the You-Must-Install-This-New-Operating-System frenzy from Microsoft. Actually, the real reason was that Q&A users have been calling and emailing us since the day Windows Me (Millennium Edition) was released with that same old question: "Will Q&A run in it?" We proceeded with the installation with trepidation because Microsoft had announced that with this edition Windows would no longer support DOS or DOS programs. We "sacrificed" two computers—a Compaq notebook and a Compaq desktop. Both had Windows 98 SE installed, so we installed the special upgrade version of Windows Me.

The title makes it obvious that we had some degree of success. How much? It depends on your hardware and point of view. But if I had to chose between Windows Me and Windows 2000 for business use, Windows 2000 would be the hands-down winner. Windows Me, by design, is an operating system for the novice user, with emphasis on home-networking, internet, and picture editing. It attempts to shield you from the complexities of setup and computing but in doing so makes some things very difficult (such as drive mapping) to accomplish. But, enough of that. Here’s the bottom line on what we found:

Q&A Version Notebook          Desktop

Q&A Windows Runs Fine* Runs Fine*

Q&A 4.0 DOS Runs Fine** Runs Fine**

Q&A 5.0 DOS    Runs***         Runs Fine****

* Requires pre-partitioning the installation drive if it’s larger than 2G.

** On drives larger than 2G, requires pre-partitioning of drive for installation or files must be copied over to new computer (not installed) and Lesspace used.

*** Requires Lesspace for drives larger than 2G; you might have problems getting Expanded memory on certain notebooks (such as the Compaq we tested).

**** For running (not installation) requires Lesspace for drives larger than 2G.

With Windows Me you cannot boot to a DOS prompt, but you can open a DOS Window and run DOS programs within it. Windows Me does not use a config.sys unless you have an old driver loaded in your current setup that isn’t supported by Windows Me. This is important! The config.sys is where you place the device drivers to set up Expanded and High memory. So how did we get the system to recognize these memory settings that Q&A needs to run successfully? We didn’t have to do anything.

After installing Windows Me, click on Start / Programs / Accessories / MS DOS prompt. In the DOS window, type mem/c/p and press Enter twice. If you see a line that reports any numbers in Expanded memory, you’re okay. Close the DOS window and use Q&A just like you did in Windows 95/98. Create your Q&A desktop shortcut and set its memory properties as we’ve explained in previous columns. (Search T.J.’s Quick Answer Index Database at www.quickanswer.com on the keyword memory.)

But if that line is missing, you probably have one of the few computers with a BIOS that doesn’t support Expanded memory (like our Compaq notebook). This doesn’t appear to be Windows Me-related. With Q&A for Windows or Q&A 4.0 for DOS this isn’t a problem. But in Q&A 5.0 for DOS, Expanded memory is crucial for printing lengthy reports, entering large amounts of data in expanded fields, fonting documents, and other operations. So, what do you do with such PCs? That question is still under study and we hope to report on it soon.

Testing network connections and overall Q&A speed running in Windows Me has not yet been completed. We hope to let you know on that soon, too.

But like that Energizer bunny, Q&A keeps on going! All preliminary findings show that, with the same caveats as in prior versions of Windows 9x, all versions of Q&A 4.0/5.0 should run fine in Windows Me!

Windows ME and Expanded Memory

(From the November 2000 issue of The Quick Answer)

Question: I believe that Expanded Memory is important to Q&A 5.0’s operation. I just bought a new computer—a Pentium III 800Mhz—and installed Q&A on it. When I tried to set my Q&A shortcut’s properties for the proper memory settings, the Expanded Memory section was blank on the Memory tab and there seems to be no way around it. Q&A reports 0 (zero) K on the Expanded Memory line at the Ctrl-F3 System Information screen. Can you help me?

Answer: Windows ME does not use a Config.sys file, so you cannot implement the High or Expanded Memory drivers at startup. Some new PC’s that come with Windows ME installed show Expanded memory available on startup. Some don’t. All seem to have the proper settings in the Windows registry. The confusing issue is, What makes some machines different from others? Fortunately, we were able to get this answer from Microsoft’s Knowledge Base:

This behavior can occur when an Emmexclude statement is in the [386enh] section of the System.ini file. To resolve this behavior, you must disable the Emmexclude by:

1. Click Start, click Run, and in the Open box, type System.ini and press enter

2. Find the Emmexclude statement in the [386enh] section, and type a semicolon (;) at the very beginning of that line.

3. Save the file and reboot your machine.

Note: An example of an Emmexclude entry is "EMMExclude=C000-CFFF".

Be advised this will work for most computers, but there some (mostly notebooks) that do not provide the physical memory for this use and will not be corrected with this fix. But for most users, Q&A continues on. For more on getting Expanded Memory from PC’s that don’t otherwise support it, see the May 2000 issue, p. 12 and the July 2000 issue, p. 2.


For more on setting up Q&A in Windows 9x, see David Dvorin's article, "Q&A 5 and Win 95: A Cool Combo," Parts 1 and 2, in the October and November 1997 issues of The Quick Answer. Also see Alec Mulvey's comprehensive article, "Installing and Configuring Q&A" (covers 4.0 and 5.0 for DOS) in the February 2000 issue. These back issues can be ordered in printed or Acrobat Reader editions using our Online Order Form.

Note: We have a videotape of Bill Halpern's 1.5 hour presentation at the International Q&A Users Conference 2001where he covers in detail ALL the setup and configuration requirements for successfully installing and running Q&A in all the Windows operating systems from Windows 95/98 through Windows 2000 and Windows ME. This VHS videotape is available as a part of the complete Q&A Users Conference 2001 Tape Set. When the tape set it ready, it will be announced on our Home page

How to Post to a Text or Keyword Field  Q&A 5.0
(How to copy the programming to paste into a Q&A 5.0 database)

Suppose you want to add an entry from a field in Database A to the existing contents of a Text or Keyword field in a Database B record. You can't use Q&A 5.0's XPost command in the usual way because it will overwrite the entire target field in the Database B record with the posted value. You’ll need to perform a trick with XPost and @XLookup to get the job done. Here's an example that shows how to post a color (Red, Blue, Green, etc.) to a Colors Keyword field in an external Customer.dtf record:

< If @Instr(@XLookup( "Customer", Acct No, "Acct No","Colors" ), Color ) = 0 then {

XPost("Customer", Acct No, "Acct No",
@XLookup("Customer", Acct No, "Acct No","Colors")
+ "; " + Color, "Colors");

@Msg(Color + " added to record " + Acct No + " Colors field.") }

Else @Msgbox("Colors field in Account " + Acct No,
"already contains " + Color + ".","Duplicate Keyword not posted.")

This sample program posts the Color field’s value (Blue, for example) in the current record to the Colors Keyword field in the target Customer.dtf record, on a match between the Acct No fields.

If the Customer.dtf record Keyword field already contains Blue, a message advises that the duplicate keyword wasn't posted since the target field already contained it. Otherwise, the Colors Keyword group is retrieved (via @XLookup) from the target record, the new color, preceded by a semicolon and space, is tacked onto the end of it, and the modified group is then posted back to the Keyword field.

The trick here is to place the @XLookup inside the XPost command as the "what to post" parameter. This technique works for Text fields as well. It gives you a way, for example, to keep track of all of a customer's invoice numbers in a single field in the customer record (posted from the invoice records), or all the check numbers paid to a vendor in the vendor's record (posted from the check writing database). (For more examples, see "All About Keyword Fields" in the May 1998 Quick Answer p. 5, and "Track Failed XPosts with a Posting Error Log" in the April 1997 issue, p.5.)

Enter 21st Century Dates the Easy Way
(How to copy the programming to paste into Q&A)

You probably use Date fields, and know that Q&A lets you type just the last two digits of the year. For example, you can enter 12 5 95 and Q&A assumes you mean December 5, 1995. For 21st century dates, though, a two-digit year won’t work. Enter 10 5 01 and Q&A will think you mean October 5, 1901.

If you’d like to type a two-digit year for 21st century dates, you’ll need to program your Date field. Create a test database with the following fields and formatting, and choose date format #14 at the Global Format Options screen:

Date: D
Date Internal: T
Date in 4 years: D

Program the Date field as follows:

> If Date = "" Then CNext;
If @Year(Date) < 1910 Then {
{ Date = @Str(@Year(Date) + 100) + "/"
+ @Str(@Month(Date)) + "/" + @Str(@Dom(Date));
@Msg("Date assumed to be 21st Century") };
Date Internal = @Str(Date);
Date in 4 years = Date + (365.25 * 4)}

Add a record. Type 12 5 01 in the Date field, press Enter, and the date appears as 12-5-2001. Enter 12 10 0 (a one-digit year!) and the date appears as 12-10-2000.

The program assumes the date field is named Date. If your date field is named something else, be sure to to change it accordingly in the program. Also, if your database contains multiple fields with Date labels, Q&A will name the first one Date, and subsequent ones Date1, Date2, and so forth by default. Be sure to use these field names in the program.

(The other two fields show how Q&A stores dates internally and how you can add years to a date. They aren’t required)

The program tells Q&A you want a 21st century date if the year is before 1910. This works if the dates you enter are no earlier than 1910 and no later than 2009. You can change the < 1910 parameter to whatever year you want as your cutoff year. If you make it < 1950, for example, you’ll be able to enter 21st century dates out to 2049 by typing the two-digit year.

Remember, you need a four-digit-year date format for this to work. But with the millennium fast approaching, you should be updating your databases, reports, specs, and so forth, to a four-digit-year date format anyway.

Tom Marcellus
Published in the December 1997 issue of The Quick Answer


 

Comments? Looking for something? Write us at inbox@quickanswer.com
Want to submit an article to The Quick Answer? Write to office@quickanswer.com
Phone -  800-780-5474 or 949-722-9127 / Fax -   949-722-9127
Marble Publications, 1927A Harbor Blvd., Costa Mesa, California 92627
Last modified: December 11, 2006