WPC 2BVgW?3|Kman 10pt (ASCII) (Port) (FW) aeWA,,}}Wo> PA"^(08Tx,@DT$8(,TTTTTTTTTT0,Ltlt|pd<@pp|dp\hxltdpH,DT(XTHTH0HX,,T,XXTT8@0XLpD@@TTTIYMSRIYMSR.PRS}Wo> PA,,0#o2  W\3|W"^,40\p(88T,4,4\\\\\\\\\\00Xllxtl`x(ThXxhpl`thddd<4 PA,,0#o2 gqsE"^(88T(@@T(8(,TTTTTTTTTT,,Pptth(,s}q}S `> XiA2 @ m "5P^ ,,hD|l 44Dp , $DDDDDDDDDD$$ppp@d\`l\Tll0<`X|hlPlhHXldhd`,$,D @H PAb?F5$,%Fo> PfQZ^hVA(,N}d}V [ PAaeS>(,s}q}S `> XiA_BG5 ,_!G [ PfQ"5P^ (,hD|`$44Dp, $DDDDDDDDDD$$ppp<\T\dXPlh04XXxdhPhXHT`Xt\PX8(8D DD PAb?F5$,%Fo> PfQZ^hVA(,N}d}V [ PAaeS>(,s}q}S `> XiA_BG5 ,_!G [ PfQb?D3 ,3ˁD `> XifQ*CE4@@@@@@@@@@@@ j0_KK~$mZZsZYZsZZssYsZZZYYYsZZYYYYZK DA;~~4~|~>>~>~>?+~>~><>>~??)~>~>|~~>~>~@ ǀÀ~- ~><~>><>>~~'?~><><>>~~*?~||>||><~0 ?!5 Ã8À ǀÄ<À À@À K?A ?A A B !À ÀÀ ǀÄÀ ~>~> ~~>~>>~>>~>~?<>~|>~>~|<>>~  ~~<>~~~<><>~ ~<~~<~~  À  À $À ~>~'~|~ <>)|?+~? ? ~<.? À 0ǀ À 1ǀÀ À2ǀÀ ǀ4ǀÀ  |<~5? ??<<>5? ????<?6? ??<~~<>? ??"  ?,<? O"  ǀCǀ π߀"  ǀÀ π߀"  ǀÀ O_"  GÀ ??"  // ??" ????" ???? ??" ? / O#  ǀG ǀ߀#  ǀǀ ǀπ#  ǀǀ O_#  G ??#?  // ??#??? ?? ??#??? ??? ~/?#?? / G$ ǀG ǀπ$ ǀǀ ǀπ$ ǀǀ BBCBG$ ǀ >~~<>|??$? '/? ?~??$??? ??? ??$??? ??? ?$?? /? G_% ǀGO ǀπ% ǀǀπ Àǀπ% Àǀǀ ÀG% ǀGG /?%?? '/? =??%??? ??? =??%??? ??? ''?%?? '' ÀG_& ǀGǀ Àǀπ& ǀǀÀ Àǀπ& ÀǀÀ GGO& ǀGÀ ?/?&? '/ ???&?? ?? ???&?? ?? ?'?&?? ' OGO'? Àǀ πǀπ'  Àǀ ߀Àπ'  Àǀ GO'  Àǀ ?/?' ?? ' ???'?? ??? ???'? ??? '?'? '? GO'   Àǀ Àπ'   Àǀ Àπ(  ÀÀ߀ CO(  Àǀ /?(? ? '? ??(>? ? ??? ??(<? ?? ??? '? 0 ? '? ÀǀO   ÀǀG ÀÀπ   ÀÀǀ ÀÀπ ? ߀ ÀÀǀ ǀCOs?  ÀÀ ?7?3? ? '? ????π? ?? ?? ??? ? ?? ?? ?'?  ?? ' πÀO   ÀÀÀ πÀπ ߀ ÀÀÀ πÀǀǀ π ÀÀÀ _C  ÀÀÀ ?/?? ??  ???? ?? ? ????ǀ? ?? ?? ?'??? ?? ' ÀO _ ÀÀ Àπ ߀ ÀÀ Àπ π ÀÀ À?  ÀÀ '? ??  ?? ?ǀ ?? ?? ??  ?? ?? '?  ?? ? ÀÀO  _ ÀÀ ÀÀǀ  π ÀÀ߀ ÀÀǀ ? π ÀÀπ ÀÀ ?  ÀÀO //?  ?? ? ??? π ??? ???* ?? ? /'/* ?? / GÀO* _ ÀÀG ǀÀπ+ π ÀÀǀ πÀǀ+ π ÀÀǀ À9 ÀÀG ?'?9?? ' ???9?? ? ???9?? =? ?'/9??  ÀO9O ÀÀÀ  Àǀ9π ÀÀÀ  Àǀ9߀π ÀÀÀ À9 ÀÀÀ /?9??  ??9??  ??9??  '/9??  ÀG9O ÀÀ À Àǀ:߀π ÀÀ À Àǀ9߀π ÀÀ À À9_ ÀÀ' /?9?? ? ???9?? ?? =??9?? ?' %/9?? ?ǀ Àǀ9O ÀÀǀ Àǀ:߀π ÀÀπǀ Àǀ:ππ ÀÀπG À9_ ÀÀO? '?9?? ?? =??9?? ?? %?/9?? ? Àǀ9O ÀÀG Àǀ:߀ǀ ÀÀǀ Àǀ:πǀ ÀÀǀ À9_ ÀÀ ??9?? ? =??9?? ? ???9?? ? ?'9?/  Àǀ9OO ÀÀ Àǀ9πǀ ÀÀÀÀ Àǀ8πǀ ÀÀÀÀ À7O ÀÀ ??6 |<4??  ??5<?? = ???4|<? ' ?'3|$~/ À Àǀ2CG À À/ǀǀ ÀÀ À,ǀ Àǀ ÀBCC+BCǀ   / ?44<>'~|<4 ? ? ? ??<>~~|<? ? ? ? ? 4$$,<<~~<<4$> / ?π À CC CCG π À  ǀǀ À π π À ǀ ÀÀ π  À „BCCCCˆBC ÀO ? ?<<,$<4<<44<,<<4< 44$4$<>>|/ ? ? ?~|<>~? ? ? ?~~<>~>~~? ?  ? ~~|<>~|>>~<>~/ /  À#ǀ À G  ÀDǀ À ǀ  À߀Cǀ ÀÀ ǀ  À_C À ǀ  ?B/' / ?B??   ?B??  ?B'/  À ÀOCǀO À À ÀπCǀ߀ À À ÀǀCǀ À À ÀGC À ? ?C/  ? ?B?<  ? B?< / B'  G ÀCǀG  ǀ ÀCǀπ  ǀ ÀBÄÀ  O ÀG? C  ? ?7~>>$<,<~>><?? ? ?~><$$4$,$,<>~~ ?  ÀǀCCCƒCBB _  ÀÀ  π  ÀÄ ǀ  ÀCBCCBBCCBDž$ O  <4<4,4<<,4,<>~1?  <~6?  <><>|>~9?  ~H/  ÀZ ǀ À ÀZ ǀ À ÀZ À À ÀZ À 7 Z  ? Z ? ? Z  ' Z  ǀ ÀZ À ǀ ÀZ À O ÀZ À ? Z  ? Z  ? Z   Z   Z   Z   Z ?  Z ?  Z ?  Z O  Z π À Z π À Z   Z ?  Y ? ? Y ? ' Z  ǀ Z G ǀ Z ǀ ǀ Z À ǀ Z À / Z  ? Y  ? Y  ? Z  π Z À π RÀ À π IÀ À D‰B@  ? =~>< $4<<44$4  ? 2~><   %~>><><>~~    ~<|<4<4$4$<,<>~ CCÃCƒCBCBCCDŽ Å" ( ÃCÓBCB2 <4<4<4$<4<44<4<~?? <>~D? <>~~>~H? <~>~Y? ÀuO Àvπ Àvǀ ǀu ?u? ?u πvǀ πvÀ vÀ ?v ?v ?v v wÀ wÀ w w v w w w Àw Àb À^ 7V~><<? ?N~><??C~|><?/?~>~|<4$4$ $? ǀ6LjC CC„O ǀ*ǀ ǀÆ ǀOC–BCBCÄ)G? ~>><,<44<<,4$4<>~>>~2/?~|~<>>~8??<>>~A??$$4$4$4$$4<4<>~L'CCYÀcÀjÀyÀxxxyyÀyxxxyyxxxodÀ]ÀW‡B@BCP~>>< ,<$$4<$4$4$<>$E~>><>|~|=~>~<>~7~><4<$,,<>>~>~~ 1CBBCBCCÆ(  ’BCCÆ) 4<4<4<<>~~>~1 <>>~~7 >~@ 'E ǀE ǀE GE< 'E< ?E ? ?E? 'E?? ǀE?? ǀE? ǀE? GE? 'E? ?E? ?E? 'E? ǀE@ ? ǀE~@ ? ǀE<@ ? E<???'??'/??'5~|<4$ ???OOÀÀ1CCBÀÀ'ÀÀOGGOÀÀBCBŒBCC_'??//?'??~|><4<<,4<44<>~???????????~>><>~~????????????<~~>|<>>~~??'??'/?'?<44$,4$$4$<>~#??G_OÀÄCCBBBCBCC„)_À/À3OG_OÀÃA?_'??'????H???????????H?????????????H??'??'/??H??_GÀÀH_ÀÀHÀÀHO__ÀÀH?'??'/???H???????????H?????????????H??'??'/?'?H|??O_GÀÀ?_ÀÀ8ÀÀÀ2ÀGG_G_ÀÀ+ŠB@B'??'????&~><,<<$44<44<>>~~?????????~><>~ ????????????~><>~?'??'/??~<44$<<,,><>~?O_G_ÀÀ ƒCBCC _ÀÃ'ÀÃ+GGOG_À–BCBÄ1O'??'/???<$,4<<4,4<~~8???????????<>>~>~<???????????<><~H??'??'/?\? gOlzxx??x?x?yyyxx?x??w??w/yOxπxwÀ?v4?t|??k~><><??d~<>><,4$? π`CCC ǀZǀ ǀQÀ ǀMÌBC I~|<,$$,<>~~ ?~|><>>~ ?7~<>~~ ?0~|<$4<>>~~' ǀ&CCBÄBCBC- À1 Ã5  ÃCB@B@B2 >~><4<4 $$4,,<4$<4$<4,4,<,4<>~~-~><< <><>~>~%~>< <>>~*~><? $4<<>~1~<<,<,$ $44? CCBCCCÆ5BCBBCBBCà 5Dž 8Ã߀JBC_F~><<4<4<>~?8~>|><>~~!?-~<>>~~$?(~><44$$4$$4$<4<>~~+?!ÃCBCÃBCBCC1OÄ7π <π ÄCBCBCCCCÆJO <44<,<4<<4<<>>~>~~T? <><>~Z? <>~a? &~~m ǀtG ǀtǀ ǀt ?t' ?t? ?t ?t πtÀ OtÀ ?t ?t ?t t ߀tÀ t ?t ?t ?t u u u t? t? u u u߀ u_ u? u? u? uO Àvǀ ÀuO u? n~? ?d~><?? _~<4$4/' À[ CCBCCBGG ÀUǀǀ ÀOǀÀ ÀLÃBƒBBCC ǀ /G~<4<,$<<>~' ?>~<>>~? ?6~><|<<>~? /2~<$4<<>~~# ǀ*CCBCBCBCC*À ǀ-À ǀÃ2À ǀCB@BCÅ:À ?~<><4<4<4$<4<4<><~A ?<>~G ?<>~E~ ?4$ <44<<>><~|~K~? πQǀ πOǀ πTǀÀ _PŠB@BCC ?L~|<~<$,$$<$$<4<<><&~/ ?E~><><>~? ?>~|~<><>~? ?7~>~><4<$44$>~/ 3CCBBCCBCCÃO GÀ )Àǀ ǀÀ ǀÀǀ ǀÀ CÑBCBCGO À ~< 4<$$<<,4<4,<><>~???/ ' ?~>~<>|>~|????? ?? |<>><~~?????? ?? <$4$4$4$<~&~?????' ? CCÃgÀÀOOǀ ÀÀ χÃÃÀÀπ߀πǀ ÀÀ ߄ÀÀπ߀πÀǀ ÀÀ ÀÀOO ÀÀ ????????/ ? ??????????? ?? ???????????>~><<? ??'?????~|<4$? ÀÀÀ__ODžCCBÀ_ ÀÀÀπ߀πÀÀ ÀÀÀπππÃÀ ÀÀÀO_GB†BB CCCO ??? ?~|>~~<$<$4,,4,,<<$><>~$~d'? ????? ~|>~~><>>~<~<?? ??? ?|>~<>><~=?? ?'~|>~< 4$$<4>>d> ÀÀÀÀCCCCBCBBCBCCÀÀÀO ÀÀÃÀÀÀ ÀÀÀÀÀ ÀÀÄ GCCBCB@B@B CCgÀÀÀÀG ~d~|~<4<4$<$$44,$<>|>~?? ?<<>~~???? ?<<>~~????? '$ 4$$<<4<<>>$~?'???? ǀÀGO_À ǀÄÀÀǀ߀π߀À߀ ǀÀÀÀÀǀ߀π߀À߀ ǀÀǀǀG_O_À_ ??'/?/???? ??????????? ??????????? //'/?/????? ǀǀǀǀGO_À_ πǀǀǀ ǀ߀π߀Àπ πǀǀǀÀǀ߀ππÀǀ OOGG_OÀCCC†B@BO ?????????~>>4<$<<4,<4,4<? ?????????|~~><< ><|><>~~? ?????????|~<>|<?<~>~|?? ?????/???~ |~|< <<44$4$4<>8???/__OGOGgCƒ_O ߀߀ππÀǀ Ã߀ǀ ߀߀ππÀπǃǀ߀߀ǀ _OÀCCƒBCB@CCCGGO_G ???7?t~|>~~<<$<4,4<>$~&'?/?????/ ?>~|>><?>~<>>~|???????????? ?<?<~????????????? ?4$4'$4,<,<~>~&~''/??????? CCCGCGǀÀǀǀÀOǀπOOǀ ÃπǀÀǀÀÀÀǀǀπ߀ππǀ ÃǀπǀÀǀÀÀÀǀǀπ߀πǀÀ G_OGÀGÀǀÀGGO_OÀ ???/?'?/???????? ????????????????? ?????????????????? ???'/?????/?ǀ? OOǀǀǀÀǀÀOGOOGO_À À πǀǀǀÀÀÀπǀππ߀ǀǀπÀ À πǀǀǀÀÀÀπǀǀππǀǀπÀ ÀOGGGǀÀOGOOÀ_ ??//?'??????/~.~|?? ?????????????><?? ???????????|>|<?<?? ??///?.~|<?$$?? ǀ_ OǀǀǀǀÀOGCCOBCCOO ǀÀ πǀǀǀÀÃǀÄÀǀ ÀǀÀ πǀǀ ǀÀÀǀÀ ǀÀ OGGG CCCBBCB@BCÀǀGG???/~.~|4|<$< $<4<4$$4<4<$<$>>~~'/?'?? ???~><>>~????? ??|>~<>><~>~????? /?~4><,4,44$4$<> ~|?#''///' ǀÀCCCCCCBC„ǀ_ÀÀGÀǀGÀÀGG ÀDŽÃÀǀ߀ÀÀǀÀǀǀÀÀǀ ÀÀǀÀ߀ÀÀǀÀǀǀÀÀǀ ǀ†BCBB CCÀǀÀÀGÀÀÀǀ ?,<$<><<4~?''?'///' ?<>~|?????? ????>~??????????? /?'?'?''/? ǀǀÀÀǀÀÀǀǀÀÀǀÀÀÀ ǀǀÀÀǀÀ߀ÀÀǀÀÀÀÀÀ ǀǀÀÀÀǀÀ߀ÀÀǀÀÀÄÀ ǀÀÀÀǀÀ_ÀÀGÀÃBCBC???'?''~>&><$<4$<4$<4$<'??????????>~<=????????~<~>~~<><>>=????'~~|>~>~~<><<<$4$ ,<<$<><>>~`~? πOÀÀÀDŽCCCCBCCÀ  À ππÀ߀ÀÀÀ  À߀ ππÀ߀ÀÃÃÀ  ÀπOOÀ_ CBB@BCC À  À_???~$~|><$<$4<<,$4<,<<|>~>~  ???|>~<>~  ??~|>>~|<<<>~  ??~>||4<'$44$4<~~$  ?CCÃ- À  OÄÀ0 À  πÄÀ0 À  ǀÅGÀ 0 À ?/ ?0  ?????? ?0  ??????? ?0  ???'/ 0  /?ǀǀ ǀ0  Gǀǀ ǀ0 À  ǀǀǀ ǀ0 À  ǀ߀GGG ǀ0 À _??? /0  ?????? ?0  ?~|>~????? ?0 ~<>~><???/? 0~ ~>< 44<$$< $$4$'?πOO ǀ0ÅC CCBBCCBCGOππ ǀ# ǀππÀπ ÀπÀOO ÃCCCCBCBBCBBBO??? '~>><4<44<4<$<44<~???? ? ~~>~<>~~%?????~>><><<><>~~*????&~|<,<4<$$4$4$44<>~</ÀÀOCCEGÀ KǀÀǛÃMǀÀgCˆBCBCVG<$<4<><>~]/?<>~>~~a??<>>~~f??<>~nǀ|?|?|?|??|ǀ|O|ǀ?|?|?|ǀ߀|ǀ|?|?|?|'G{?{?{?{ *KKPPP_Pp PppPppPp  pP & p  pP pw  pP  p pPppPpwpwPwpwPP  P    P    P  P  P  PPP PP('P'   P   P   P PwwP PPPPPPPwwPPPP     P        P    P#  'P  )PPPP* P**P** P* * P* * P* PPPP PPPPPPPP    P      P  P     P  P p*(PY'$%PPP+  Q*     PP*    P*  SP+     R, QP- P*   PP*  P+ QPDyPPP*  P* *  P*  *   P*   *  P*  * P* G PG PPP* u*    uP*    t*    tP* t+   tP+ t+   tP+   u+ uPPP* P* *P** P*  *  P*  * P*   PPwPwPPP_ <<d    ,,  Fo> PfQ Page 18 IYM Software Review "3,4 4" y%,dddy   8%҇ }V [ PAd 386/enhanced mode with nine megabytes of extended memory, 3.625 MB configured as a disk cache. Get the picture? Under (admittedly demanding) circumstances, Q+E is a slug, and not ah  a well behaved one. XThe above aside (which is where it belongs; performing a join on unindexed databases is an invitation to idle time), we say unabashedly: we love Q+E. Installed, it occupies 425 ah  kilobytes of disk space, plus about 100K additional for each data filter you choose to install. Since Q+E works with ah  dBASE (II, III, or IV), SQL Server, and ASCII text data, ah  you'll probably use roughly 650K, total. Installation is via a DOSdriven program that asks where to install, which interfaces, whether you want Q+E to be a read only or ah  read/write product, and whether to modify the PATH statement in your AUTOEXEC.BAT file (not necessary). You also have the option of copying sample data in dBASE format ah  for use with the tutorial, which is short but adequately explains most aspects of the program. Documentation is one moderately sized book (its 200 pages split evenly between tutorial and technical information), plus an online help system that employs an interesting twist: It's an alphabetically indexed file that is context sensitive only in that the choices you can view are limited to the currently available menu options.  Figure 1 xxxx Figure 1 !`\ xxrY CEddIYMCHECK4N% Q&E ċXBasically, there are two ways to use Q+E; it's a SQL ah  (Structured Query Language) data search/sort tool, and an effective link between your databases and Windows applica ah ԭtions, with emphasis on Microsoft's Excel spreadsheet. In the ah  first instance, using a well defined series of pull down menus and simple pointandclick actions, you define data queries that execute immediately on screen. You can sort data (to memory; dBASEers, relearn the meaning of the word), select ah  subsets, construct added conditions as the mood strikes you, and save (and recall) your information any time as SQL queries, dBASE files, delimited ASCII text, or to a special ah  user defined mailing label format. With respect to multiple $886oo88!o$selection criteria, the documentation !omakes clear that the order in which !oyou present them may affect your !ooutput. In any case, Q+E automatical ah ԭ!oly writes SQL code to represent all !oyour actions, so it can even serve as !oan effective practical tutorial in that !olanguage. Regardless of what you !oultimately do with your queries in !oterms of saving, printing, etc., you can !oalways ask Q+E to show you the SQL ah  oo88'88phrasing of the current query in effect via the "INFO" command (see figure). XOnce you retrieve the data you're looking for, you can format it by changing column widths, performing several statistically oriented math functions, zooming in on individual fields (great for viewing long memo fields), and shuffling column positions and presentation. Fonts are available both for viewing and printing data according to what you've installed in Windows. You can print the results of a query ah  whenever you like, optionally including column names, record and page numbers, date and time.% }/d o(Y !%ԌAa, xxr  ddQE.WPGX4^ Q&E ĂFHThe second method of using Q+E is as a data manipulation ah  tool. Via Windows's Clipboard, or directly using the DDE ah  (dynamic data exchange) hooks provided to Excel, you can ah  move information between applications' data files (which relationships can be made permanent and not require manually opening both applications). Temporary links to unsaved data queries also can be created. This use of Q+E is ah  not for neophytes, though, so Q+E includes an Excel macro ah  that automates most of these actions by integrating them as easily understood menu choices in Excel. The macro is over ah  70K in length; we sure would like to see what's in it (alas, it's $%% %% A%$protected against snooping). FHOK, so what's the big deal about Q+E? Why are we so ah  excited? Here it is: Q+E can create dBASE files all by itself, ah  so if your database needs are light (or at least usually confined to flat file, rather than relational work), Q+E may ah  be all the database you ever need to buy! You can't write or run custom dBASE applications, but you can exchange data ah  with the huge installed base of dBASE and compatible users ah  whenever you need to. As to the abovecited example of joining nonindexed databases, officials at Pioneer tell us they plan to implement a warning box that will alert users to the impending wait before carrying out such commands. Also, !oexcept for Fox Software's FoxPro, Q+E is the only dBASE ah  !ocompatible product we know of that can display multiple !odatabases simultaneously in interactive mode. Now, here's the !okicker: Q+E is cheap, right? Well, check this out: because of ah  !oa comarketing agreement between Pioneer and Microsoft, if !oyou buy (or recently bought) Excel, you can get Q+E for ah  !o$9.95. !oFHIf you saw something that struck a chord in all that (or !omultiple somethings), buy Q+E. It earns it's check rating, in ah  !ospades. !o FL^ Grammatik IV FL\Grammatik Windows ă FL[Reference Softwareă FHThere are an increasing number of products available for the PC that call themselves spelling checkers, style replicators, or something else bringing up visions of your ninth grade English teachers. (We used this metaphor when we reviewed a similar program, RightWriter, in November of 1989, but we ah  just can't think of a better one.) The Grammatik family of ah  products, with a DOS based version now called Grammatik IV ah  and a Windows variant with the name Grammatik Windows,