CISMSG ACTIVITY CENTER 컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴 � Messages Catalogs WorkSheets Reports Exit 같겠컴컴컴컴컴컴컴컴컴컴컴컴컴염같같같같같같같같같같같같같같같같같같같같같같같같 같개 View ALL 낡같같같같같같같같같같같같같같같같같같같같같같같같 같걘컴컴컴컴컴컴컴컴컴컴컴컴컴눗같같같같같같같같같같같같같같같같같같같같같같같같 같개 Convert New CIS Messages 낡같같같같같같같같같같같같같같같같같같같같같같같같 같개 View Last Import 낡같같같같같같같같같같같같같같같같같같같같같같같같 같걘컴컴컴컴컴컴컴컴컴컴컴컴컴눗같같같같같같같같같같같같같같같같같같같같같같같같 같개 Query Message Database 쿔S ACTIVITY CENTER 袴袴袴袴敲같같같같같같같같같같 같개 View Query Results 냐컴컴컴컴컴컴컴컴컴컴컴컴커 별같같같같같같같같같� 같걋컴컴컴컴컴컴컴컴컴컴컴컴컴�e & Squirrel Software � 별같같같같같같같같같� 같같같같같같같같같갰 � � 별같같같같같같같같같� 같같같같같같같같같갰 � CompuServ Message Handler Program � 별같같같같같같같같같� 같같같같같같같같같갰 � � 별같같같같같같같같같� 같같같같같같같같같갰 � (C) 1992-93 � 별같같같같같같같같같� 같같같같같같같같같갰 읕컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴� 별같같같같같같같같같� 같같같같같같같같같걷袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴暠같같같같같같같같같같 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 View All Stored Messages 컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴 A Paradox CIS Message Handling Application Code accumulated by: Mark T. Houpt BAT-Systems Consulting 429 North Sandusky Avenue Upper Sandusky, OH 43351 CIS: 70142,2720 Paradox Engine Utilities by: James Cap Walker 820 Bundaberg Lane Rural Hall, NC 27045 CIS: 70007,4651 An application to showcase PAL coding techniques! (1) Welcome to the Paradox CIS Activity Center-Message Handler. This application provides users of TapCis and other CIS navigation programs with a tool to store CIS message and catalog files. The program is comprised of source code taken from the PDOXDOS Libraries, Paradox Informant articles and the QUE book PARADOX 4 DEVELOPER'S GUIDE (CopyRight 1992 by Que Corporation). The program is intended as a means to view the work and programming approach of a number of Paradox contributors in a single application. The following individuals contributed code to this application. I'm very grateful for their efforts. What I know about PAL programming, I learned from example code found in the CIS PDOXDOS libs. James Cap Walker: This application is really his idea. He created the Paradox Engine utilities that made it possible, sent me a Paradox workshop application to view the files, allowed me to work with his application and encouraged me to put this together for the benefit of those learning PAL code. Micael J. Hyatt: Provided the neat message handling routines found through out the application. Dan Paolini: Handles all my errors with his Error-handling routines. The code was originally presented in the PARADOX INFORMANT. Brian Bushey: Brian provided a GREAT replacement for using the readme.com file for viewing reports to the screen. Desmond Nolan: Desmond's SysInfoProc and Clock routines are included here from his example security application found in the PDOX libs. Look for SECUR.EXE. It's worth the download. Has a really nice Help system among many other good code examples. Tony Goodman: Tony Goodman of Ensemble (makers of Command Center, Visage and other Paradox products) is responsible for the code that produces the button bar in the view screen in this application. The code was originally presented in the PARADOX INFORMANT. Dana Greaves and Jennifer Lindsay: Authors of PARADOX 4.0 DEVELOPER'S GUIDE. I used a number of their routines in this application. Their book got me going in Paradox v4.0 when all the new stuff looked a bit over-whelming! John R. Nelson: Provides the backup program which utilizes the DOS backup program and passes the proper parameters to the command. Look at the BACKUPMANAGER proc. Angelo Laudon: Programmer of the excellent WBSLIB Paradox add-on product. I use WBSLIB in about all my applications. So I asked Angelo if I could include the code for a routine here as an excuse for ME to brag on his product. WBSLIB was used to produce the Menu code for this application. Dan Ehrmann: Kallista Inc. Dan permitted inclusion of the code used to print the current record. It is taken from Kallista's superb DESKTOP PLUS add-on for Paradox. Kallista's Paradox editor, PAL-EDIT was used in the preparation of the source code for this program. Kallista also makes an excellent data import-export product for Paradox called CONDUIT. (2) Ted Rosenberger: How many hours have we saved using PAINTPAL to create dialog boxes. I know I used it for my dialog boxes in this application. I suspect others have also. OTHERS: No doubt there is some code in here for which I have failed to give proper attribution. My thanks to the authors. Please don't call your attorney, just send me an Email message and I'll make sure your name is included in the credits. If there are any BAD code examples in this application, they are no doubt MY work. The other purpose of this application is to encourage others to make changes to make it better and to share their solutions with all of us!!! The ScriptView Program was used to format scripts in this application prior to distribution. For those who recieved this application via the Mail, the install program, PC-Install, is by 20/20 Software makers of the Nimbus Report Writer for Paradox. USE OF THE CODE Use of the code found in this application for other purposes is under the control of the individual authors of the code. Please contact these authors by CIS or other means to ask consent to use the code. That it just what I did. In every case, I was given permission. A person who posts code to the CIS libs is generally delighted to find their code was useful to someone else. Most simply request their code be used for non-Commercial purposes. In short, don't try to sell their work as your own. WARRANTY The authors of the code contained in the CISMSG program, BAT-Systems Consulting and Mark T. Houpt make no warranties whatsoever as to the merchantability or fitness of the code for any particular purpose. YOU assume full responsibility and liability for the use of the code and the authors and those set forth above shall in no event be liable for any damage or loss of profit or any commercial damage, including but not limited to special, incidental, consequential or other claims. In short, I spent 10 years as a Juvenile Court Director and have no burning ambition to return to the Court under any circumstances. Use this code at your own risk or just plain don't use it. INSTALLATION To install the program from the version downloaded from the forum, simply create a directory, copy the zipped file to the directory and unzip the file. In order to read in TapCis or other CIS navigation program MSG and CAT files you will also need to download the Paradox Engine utilities created by Cap Walker. They can be found in Library 7 of the PDOXDOS forum in files called DLS.ZIP and CISTAT.ZIP. Unzip this file in the same directory as the program file or in a directory on your path. To start the program, start Paradox, switch to your install directory and run the script called CIS. The first time the program is invoked, it will build the libraries and then start the program. (3) BUILDING LIBRARIES As the libraries are being built, a the screen show the progress of the operation as indicated below: 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 같같같같같같같같같�袴袴袴袴袴袴 Library Builder 袴袴袴袴袴袴뺐같같같같같같같같같 같같같같같같같같같� 旼컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴� 별같같같같같같같같같 같같같같같같같같같� � Library: Paradox � 별같같같같같같같같같 같같같같같같같같같� � Script: CisLibSc � 별같같같같같같같같같 같같같같같같같같같� � Proc: YesNoWaitProc.u � 별같같같같같같같같같 같같같같같같같같같� � Percent: 35% Completed � 별같같같같같같같같같 같같같같같같같같같� � Complete: ���������� � 별같같같같같같같같같 같같같같같같같같같� 읕컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴� 별같같같같같같같같같 같같같같같같같같같훤袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴섟같같같같같같같같같 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 A script called "Makelib.sc" is used to invoke the library builder. Should you make changes to the source code, invoke this script to register your changes. RUNNING THE PROGRAM To start the program run the CIS script. The first time the program is started the program libraries will be built. You'll then be presented with a SetUp screen. 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 같같같같같같같같�袴袴袴袴袴袴袴� Program SetUp 袴袴袴袴袴袴袴袴뺐같같같같같같같� 같같같같같같같같� 旼컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴커 별같같같같같같같� 같같같같같같같같� � 旼컴컴컴컴컴컴컴컴컴컴컴컴컴컴커 � 별같같같같같같같� 같같같같같같같같� � � CIS Navigation Program � � 별같같같같같같같� 같같같같같같같같� � � ( ) TapCis � � 별같같같같같같같� 같같같같같같같같� � � (�) OzCIS � � 별같같같같같같같� 같같같같같같같같� � � � � 별같같같같같같같� 같같같같같같같같� � 읕컴컴컴컴컴컴컴컴컴컴컴컴컴컴켸 � 별같같같같같같같� 같같같같같같같같� � Location of MSG and CAT Files � 별같같같같같같같� 같같같같같같같같� � D:\OZCIS\CISDATA � 별같같같같같같같� 같같같같같같같같� � � 별같같같같같같같� 같같같같같같같같� � Ok � Cancel � � 별같같같같같같같� 같같같같같같같같� � 賽賽賽 賽賽賽賽 � 별같같같같같같같� 같같같같같같같같� 읕컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴켸 별같같같같같같같� 같같같같같같같같훤袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴暠같같같같같같같같 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 Use this screen to tell the program where you store your MSG and CAT files. (This option is also available from the Systems Menu.) The Main Menu will then appear. 컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴 � Messages Catalogs WorkSheets Reports Exit 컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴 Message or MSG files are handled under the Message menu item. Catalog or CAT files are handled under the Catalogs menu item. (4) MESSAGES In order to read in message files from TapCisOr OzCIS, choose the "Convert New CIS Messages" item from the message drop down menu. If you configured your program to look for tour message files in another directory (other than the directory where CISMSG is installed), you will see the following screen: 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 같같같걸袴袴袴袴袴袴袴袴袴袴袴袴� Files to Import 袴袴袴袴袴袴袴袴袴袴袴袴敲같같 같같같갰旼컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴커 별같� 같같같갰� Files Available Files Chosen � 별같� 같같같갰� LOTUSWP.MSG Add Item > � PDOXDOS.MSG � 별같� 같같같갰� MSBASIC.MSG � 賽賽賽賽賽賽賽� PCVENE.MSG � 별같� 같같같갰� NAVCIS.MSG � Add All >> � PDOXWIN.MSG � 별같� 같같같갰� PCVENA.MSG � 賽賽賽賽賽賽賽� RACING.MSG � 별같� 같같같갰� PCVENB.MSG � < Remove Item � � 별같� 같같같갰� PCVEND.MSG � 賽賽賽賽賽賽賽� � 별같� 같같같갰� PCVENE.MSG � << Remove All � � 별같� 같같같갰� PDOXDOS.MSG � 賽賽賽賽賽賽賽� � 별같� 같같같갰� PDOXWIN.MSG � OK � � 별같� 같같같갰� RACING.MSG � 賽賽賽賽賽賽賽� � 별같� 같같같갰� SYMAPPS.MSG � Cancel � � 별같� 같같같갰� WINSHARE.MSG � 賽賽賽賽賽賽賽� � 별같� 같같같갰� ZENO.MSG Help � � 별같� 같같같갰� 賽賽賽賽賽賽賽� � 별같� 같같같갰읕컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴켸 별같� 같같같걷袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴暠같같 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 Use the spacebar to select individual files (or double-slick with the mouse). Your Selection will be moved to the right hand side for processing. To choose all messages just click on the Add ALL >> button or use the Alt-A key combination. Choose OK when done. The program will shell out to DOS and run Cap's CISTATS program. If you use OzCIS and additional screen is presented before the final message as the program goes out and "FIXES" OzCIS message memos on import: 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 같같같같旼컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴커같같같같 같같같같� Fixing OzCIS Message Entries 낡같같같� 같같같같� 34 of 53 낡같같같� 같같같같� 낡같같같� 같같같같� 栢栢栢栢栢栢栢栢栢栢栢栢栢栢栢栢같같같같같같같같같 낡같같같� 같같같같� 0 25 50 75 100 낡같같같� 같같같같� Percent Complete 낡같같같� 같같같같읕컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴켸같같같같 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 A message will appear telling you your new messages are available for viewing. If you want to view the most recently imported messages, choose the "View Last Import" option. The following screen appears: PLEASE SEE NEXT PAGE... (5) 컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴 � Table Exit 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 � 旼컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴� 같 � � 0 ABOUT S0 ABOUT CISMSG 5/16/93 11:00 � 같 � � All about the authors of CISMSG 0 #0 � 같 � � To : All Record 1 � 같 � � From: Mark T. Houpt 70142,2720 of 1 � 같 � � � 같 � � The following individuals contributed code to this application. I'm � 같 � � very grateful for their efforts. What I know about PAL programming, � 같 � � � 같 � 읕컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴� 같 旼컴컴컴컴컴컴컴컴컴컴컴컴컴컴� Last ->Message 컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴� 쿟he following individuals contributed code to this application. I'm very � 쿲rateful for their efforts. What I know about PAL programming, I learned � 쿯rom example code found in the CIS PDOXDOS libs. � � � 쿕ames Cap Walker: This application is really his idea. He created the � 쿛aradox Engine utilities that made it possible, sent me a Paradox workshop � 쿪pplication to view the files, allowed me to play with his application and � 쿮ncouraged me to put this together for the benefit of those learning PAL � 쿬ode. � 읕컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴켸 旼컴컴커旼컴컴커旼컴컴커旼컴컴커旼컴컴커旼컴컴커旼컴컴커旼컴컴커旼컴컴커旼컴컴커 � HELP 납 SORT 납 FIND 납 << 납 < 납 > 납 >> 납PRINT 납SYSTEM납 QUIT � 읕컴컴켸읕컴컴켸읕컴컴켸읕컴컴켸읕컴컴켸읕컴컴켸읕컴컴켸읕컴컴켸읕컴컴켸읕컴컴켸 The top box in the screen contains forum message information as to the subject, message number, forum, section etc. The middle box is the message box. It is an open memo field in fieldview. You can double click in the message box and scroll through the messages. By then clicking back in the top box area, you can use the buttons at the bottom of the screen to move through the records. If you choose the PRINT option, the current record will be sent to the printer. The Memo window can be maximized to enlarge the viewing area by clicking on the maximize do-hicky at teh top right corner of the memo window. Once maximized, it can be restored to its normal size by clicking on the do-hicky again. There are menu options available to move you from the top window to the memo window. These are found under the TABLE menu option. Or you can select the window with a mouse click. 컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴 � Table Exit �袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴� Last->Message 袴袴袴袴袴袴袴袴袴袴袴袴袴袴[ ]敲 튍lan, � � 튒o you know what the holdup is on your new book "Paradox 4.0 Programmer's � 튖uide: PAL By Example"? I received the Bantam order forms in April, ordered � 틊he book in the first week of May, and now they say that it is still on � 튯ackorder until the third week in June? � � � � � � � � � � � � � � � (6) If you choose to print the current record, a dialog box appears for you to choose the report format. Coices include a report formated for a laser jet and formated for a dot-matreix printer. Should you create other reports, they appear in the dialog box for you to choose. 컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴 � Table Exit 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 � 旼컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴� 같 � � 0 ABOUT S0 About CISMSG 5/17/93 19:25:13 � 같 � � About CISMSG 0 #0 � 같 � � To : ALL Reccord 1 � 같 � � From: Mark T. H�袴袴袴袴袴� Custom Reports 袴袴袴袴袴敲 of 4705 � 같 � � � � � 같 � � See the CISM� 1 - Message Report for Dot-Matrix � complete � 같 � � documentation of� 2 - Message Report for Laser-Jet � � 같 � 읕컴컴컴컴컴컴컴컴� R - Standard Report 봬컴컴컴컴컴컴컴켸 같 旼컴컴컴컴컴컴컴컴컴� 봬컴컴컴컴컴컴컴컴컴� � See the CISMSG.� 튾plete � 쿭ocumentation of th� � � � � � � � � � � � The following i� 튷cation. � 쿔'm very grateful f� OK � Cancel � � � 쿾rogramming, I lear� 賽賽賽賽 賽賽賽賽 튒OXDOS � 쿹ibs. 훤袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴暠 � � � 읕컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴켸 旼컴컴커旼컴컴커旼컴컴커旼컴컴커旼컴컴커旼컴컴커旼컴컴커旼컴컴커旼컴컴커旼컴컴커 � HELP 납 SORT 납 FIND 납 << 납 < 납 > 납 >> 납PRINT 납SYSTEM납 QUIT � 읕컴컴켸읕컴컴켸읕컴컴켸읕컴컴켸읕컴컴켸읕컴컴켸읕컴컴켸읕컴컴켸읕컴컴켸읕컴컴켸 Choosing SORT allows you to pick the sort order for the table. Upon installation, the view screen is set up in a sort order of FORUM-SECTION-START MSG-DATE-TIME. You may wish to create additional sorts. The FIND option brings up the ZOOM box. The ABOUT option brings up the About box and the Quit option returns you to the Main menu. Other Message menu choices allow you to view ALL stored messages. (It looks and works just the same) and to query the database for a selected set of records for viewing. If you choose to query the database for a selected record set, you may choose all forums, a particular forum, all messages, todays messages or messages based upon a particular date range. Upon invoking the "Query Message Database" option, the following drop down menu appears: PLEASE SEE NEXT PAGE... (7) 컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴 � Messages Catalogs WorkSheets Reports Exit 같겠컴컴컴컴컴컴컴컴컴컴컴컴컴컴커같같같같같같같같같같같같같같같같같같같같같같같 같개 View ALL Messages 낡같같같같같같같같같같같같같같같같같같같같같같� 같걘컴컴컴컴컴컴컴컴컴컴컴컴컴컴캑같같같같같같같같같같같같같같같같같같같같같같같 같개 Convert New CIS Messages 낡같같같같같같같같같같같같같같같같같같같같같같� 같개 View Last Import 낡같같같같같같같같같같같같같같같같같같같같같같� 같걘컴컴컴컴컴컴컴컴컴컴컴컴컴컴캑같같같같같같같같같같같같같같같같같같같같같같같 같개 Query Message Database  쿌CTIVITY CENTER 袴袴袴袴敲같같같같같같같같같같 같개 旼컴컴컴컴컴컴컴컴컴컴컴컴커냐컴컴컴컴컴컴컴컴컴컴컴� 별같같같같같같같같같� 같걋캐 Query By Forum Only 넨 Squirrel Software � 별같같같같같같같같같� 같같개 Query By Section Only � � 별같같같같같같같같같� 같같개 Query Section By Subject 쿘essage Handler Program � 별같같같같같같같같같� 같같걋컴컴컴컴컴컴컴컴컴컴컴컴컴� � 별같같같같같같같같같� 같같같같같같같같같갰 � (C) 1992-93 � 별같같같같같같같같같� 같같같같같같같같같갰 읕컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴� 별같같같같같같같같같� 같같같같같같같같같걷袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴暠같같같같같같같같같같 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 You may query the message database to obtain ALL messages for a particular forum by choosing the "Query by Forum Only" option. To get all messages for a particular section within a forum, choose the "Query By Section Only" option. To gether selected threads within a Section choose "Query Section by Subject". We'll discuss the FORUM option first. Upon choosing this option, you'll be presented by a question: 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 같같같같같같같같걸袴袴袴袴袴袴袴袴袴 UPDATE 袴袴袴袴袴袴袴袴袴뺐같같같같같같같같 같같같같같같같같갰 旼컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴커 별같같같같같같같같 같같같같같같같같갰 � Do you wish to Update your Forum List? � 별같같같같같같같같 같같같같같같같같갰 읕컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴켸 별같같같같같같같같 같같같같같같같같갰 별같같같같같같같같 같같같같같같같같갰 Yes � No � 별같같같같같같같같 같같같같같같같같갰 賽賽賽� 賽賽賽� 별같같같같같같같같 같같같같같같같같걷袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴섟같같같같같같같같 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 If this is the first time you are running this process, PLEASE choose YES! The program will then process a query and build a list of your forums for use later. The following screen appears as the query is processing. 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 같같같같같같같같같같같같걸袴袴袴袴袴 FORUMS 袴袴袴袴敲같같같같같같같같같같같같같 같같같같같같같같같같같같갰 旼컴컴컴컴컴컴컴컴컴컴컴� 별같같같같같같같같같같같같� 같같같같같같같같같같같같갰 � Gathering Forum Names � 별같같같같같같같같같같같같� 같같같같같같같같같같같같갰 � Please Wait... � 별같같같같같같같같같같같같� 같같같같같같같같같같같같갰 읕컴컴컴컴컴컴컴컴컴컴컴� 별같같같같같같같같같같같같� 같같같같같같같같같같같같걷袴袴袴袴袴袴袴袴袴袴袴袴袴暠같같같같같같같같같같같같같 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 (8) When the program has gathered all the forum names for which you have messages, it will present you with the following dialog box: 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 같같같같같같같걸袴袴袴袴袴袴� Forum Query Dialog 袴袴袴袴袴袴袴뺐같같같같같같같� 같같같같같같같갰 별같같같같같같같� 같같같같같같같갰 旼컴컴컴컴컴컴컴� ( ) All 별같같같같같같같� 같같같같같같같갰 � Pick Forum � (�) Todays 별같같같같같같같� 같같같같같같같갰 쳐컴컴컴컴컴컴컴� 별같같같같같같같� 같같같같같같같갰 � � 旼컴컴컴컴컴컴컴커 별같같같같같같같� 같같같같같같같갰 쿌LL � � Date Range � 별같같같같같같같� 같같같같같같같갰 쿌BOUT 넹 읕컴컴컴컴컴컴컴켸 별같같같같같같같� 같같같같같같같갰 쿍DEVTOOL 낢 Start Date 별같같같같같같같� 같같같같같같같갰 쿍PASCAL 낢 栢栢栢栢栢栢 별같같같같같같같� 같같같같같같같갰 쿎AIDEV 낢 End Date 별같같같같같같같� 같같같같같같같갰 쿎LARION 낢 栢栢栢栢栢栢 별같같같같같같같� 같같같같같같같갰 쿎LIPPER 낢 별같같같같같같같� 같같같같같같같갰 쿎ONSULT 낢 별같같같같같같같� 같같같같같같같갰 쿏BASE 넵 Ok � Cancel � 별같같같같같같같� 같같같같같같같갰 � � 賽賽賽 賽賽賽賽賽 별같같같같같같같� 같같같같같같같갰 읕컴컴컴컴컴컴컴� 별같같같같같같같� 같같같같같같같걷袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴暠같같같같같같같같 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 From the Scrolling forum name list you can choose a particular forum or choose the default ALL forums. Tab next and choose the ALL if you want messages irrespective of the date of the message or leave the default of TODAYS if you only want today's messages. You can also enter a date range. If you enter a date range it will be used instead of the ALL or TODAYS setting. By entering just a START date all entries on or after that date will be made available. By entering just an END date all entries to that date will be included. Entering both a START date and END date will result in all entries in that range being presented. A message will appear upon completion of the query and the "View Query Results" option can be chosen from the message menu to view your messages. The process for getting all messages by a section within a forum is similar. Again, you'll be asked whether to update your Forum and Message lists. Choose YES the first time, and choose YES anytime after you've addes messages for new Forum sections. The process of building the forum and Section databases takes a bit so please be patient. (Thats why we put in the YES NO question, so the process does not need to be done on all occasions. The following dialog screen then appears: PLEASE SEE NEXT PAGE... (9) 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 같같�袴袴袴袴袴袴袴袴袴袴袴袴 Forums and Sections 袴袴袴袴袴袴袴袴袴袴袴袴敲같같 같같붚컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴옌같같 같같볐 Forums Sections 낳같같 같같볐旼컴컴컴컴컴컴컴컴컴컴컴컴컴컴� 旼컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴� 낳같같 같같볐� NAVCIS � � Addins/Training � 낳같같 같같볐� PCCONTAC 교 � Forms/Handling Data �� 낳같같 같같볐� PCVENA 교 � Forum Header Anncmnt 교 낳같같 같같볐� PCVENB 교 � Forum Header Announcement 교 낳같같 같같볐� PCVENC 교 � Generic Info 교 낳같같 같같볐� PCVEND �� � Networks/Interop 교 낳같같 같같볐� PCVENE 교 � New Users/Misc 교 낳같같 같같볐� PDOXDOS � � PAL - Learning � 낳같같 같같볐읕컴컴컴컴컴컴컴컴컴컴컴컴컴컴� 읕컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴� 낳같같 같같볐 Date Set 낳같같 같같볐 ( ) ALL Dates Start Date: 栢栢栢栢栢栢 End Date: 栢栢栢栢栢栢 낳같같 같같볐 (�) Today 낳같같 같같볐 낳같같 같같볐 OK � Help � Cancel � 낳같같 같같볐 賽賽賽賽 賽賽賽 賽賽賽賽 낳같같 같같봉컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴暮같같 같같훤袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴暠같같 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 The list on the left contains the names of all Forums for which you have stored messages in your CISMSG program. The right hand side containd a listing of all Forum-Section names. Simply scroll the left hand list and choose your forum. Tab to the right hand list (or use the mouse) and choose the Section. Again, you can get ALL messages stored for this section, just Today's messages, or messages in a date range. If you chose the "Query Section By Subject" option, an additional dialog box appears listing the subject available in your chosen Section for the dates you have indicated: 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 같같같같같같같같같같�袴袴袴袴袴袴袴 Subjects 袴袴袴袴袴袴袴뺐같같같같같같같같같� 같같같같같같같같같같� 별같같같같같같같같같� 같같같같같같같같같같� #230807-Linked MultiTable Forms 별같같같같같같같같같� 같같같같같같같같같같� #230852-# Bug 별같같같같같같같같같� 같같같같같같같같같같� #231152-# Bug 별같같같같같같같같같� 같같같같같같같같같같� #231162-UEs & COPYTOARRAY 별같같같같같같같같같� 같같같같같같같같같같� #231196-# Bug 별같같같같같같같같같� 같같같같같같같같같같� #231199-edit and print a record 별같같같같같같같같같� 같같같같같같같같같같� #231228-Group Lock w/ No Detail? 별같같같같같같같같같� 같같같같같같같같같같� #231262-GP errors 별같같같같같같같같같� 같같같같같같같같같같� #231275-# Bug 별같같같같같같같같같� 같같같같같같같같같같� 별같같같같같같같같같� 같같같같같같같같같같� OK � Help � Cancel 별같같같같같같같같같� 같같같같같같같같같같� 賽賽 賽賽賽 賽賽賽 별같같같같같같같같같� 같같같같같같같같같같훤袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴暠같같같같같같같같같같 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 Help screens, such as the one shown below, are available in dialog boxes as in the example above and in the view screen: (See Next Page) (10) 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 같같�袴袴袴袴袴袴袴袴袴袴袴袴 Forums and Sections 袴袴袴袴袴袴袴袴袴袴袴袴敲같같 같같붚컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴옌같같 같같볐 Forums Sections 낳같같 같같볐旼컴컴컴컴컴컴컴컴컴컴컴컴컴컴� 旼컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴� 낳같같 같같볐� NAVCIS �袴袴袴袴袴袴袴袴袴袴� Help 袴袴袴袴袴袴袴袴袴袴敲 � 낳같같 같같볐� PCCONTA� 旼컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴커 � �� 낳같같 같같볐� PCVENA � � Select you Forum by scrolling through list � � 교 낳같같 같같볐� PCVENB � � Tab or Mouse to Sections list � 틊 교 낳같같 같같볐� PCVENC � � Choose Section � � 교 낳같같 같같볐� PCVEND � � � � 교 낳같같 같같볐� PCVENE � � Enter date range � � 교 낳같같 같같볐� PDOXDOS� � or Choose ALL or Today... � � � 낳같같 같같볐읕컴컴컴캤 읕컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴켸 봬컴컴켸 낳같같 같같볐 Date Se� � 낳같같 같같볐 ( ) ALL� Ok � � 낳같같 같같볐 (�) Tod� 賽賽賽賽 � 낳같같 같같볐 훤袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴暠 낳같같 같같볐 OK � Help Cancel � 낳같같 같같볐 賽賽賽賽 賽賽賽賽 낳같같 같같봉컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴暮같같 같같훤袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴暠같같 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 CATALOGS The Catalogs Menu presents options are exactly the same as the Message items. All processes work the same except the import program invokes Cap's DLS Paradox Engine utility to import CAT files. WORKSHEET The WORKSHEET menu choice presents one option called MSG COUNT. This menu choice begins a cross-tab query on your message table which results in the creation of a Quattro Pro spreadsheet with counts the number of messages in your file, by author's name. I recently tried this routine on a table with 42,000 entries. The resulting Qpro spreadsheet created was 19.8 megs. Quattro Pro was not happy about this. So use this one early in your message storing career to see the cross-tab query functions of Paradox and to sample the export features. You might also want to add code to reduce the selection set. REPORTS The REPORT menu presents the following choices: 컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴 � Messages Catalogs WorkSheets Reports Exit 같같같같같같같같같같같같같같같같같겠컴컴컴컴컴컴컴컴컴컴컴염같같같같같같같같같같 같같같같같같같같같같같같같같같같같개 All Forum Messages 낡같같같같같같같같같같 같같같같같같같같같같같같같같같같같개 Last Forum Messages 낡같같같같같같같같같같 같같같같같같같같같같같같같같같같같개 Query Message Report 낡같같같같같같같같같같 같같같같같같같같같같같같같같같같같걘컴컴컴컴컴컴컴컴컴컴컴눗같같같같같같같같같같 같같같같같같같같같같같같같같같같같개 Catalog Report 낡같같같같같같같같같같 같같같같같같같같같걸袴袴袴袴� CIS A읕컴컴컴컴컴컴컴컴컴컴켸뺐같같같같같같같같같� 같같같같같같같같같갰 旼컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴� 별같같같같같같같같같� 같같같같같같같같같갰 � Moose & Squirrel Software � 별같같같같같같같같같� (11) The reports menu will simply send all records in the chosen database to the screen or the printer. Again, here is a spot where presenting a dialog box to reduce the selection set would be useful. Our current box allows you to choose the printer port and report type for printed reports. 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 같같같같같같같같�袴袴袴� Select Printer Type and Port 袴袴袴袴뺐같같같같같같같같 같같같같같같같같� 旼컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴� 별같같같같같같같같 같같같같같같같같� � 旼컴컴컴컴컴커 旼컴컴컴컴컴컴컴컴컴커 � 별같같같같같같같같 같같같같같같같같� � � Print To � � Printer Type � � 별같같같같같같같같 같같같같같같같같� � � (�) Lpt1 � � (�) Dot Matrix � � 별같같같같같같같같 같같같같같같같같� � � ( ) Lpt2 � � ( ) Laser Printer � � 별같같같같같같같같 같같같같같같같같� � � ( ) Lpt3 � 읕컴컴컴컴컴컴컴컴컴켸 � 별같같같같같같같같 같같같같같같같같� � � ( ) Com1 � � 별같같같같같같같같 같같같같같같같같� � � ( ) Com2 � Ok � Cancel � � 별같같같같같같같같 같같같같같같같같� � 읕컴컴컴컴컴켸 賽賽 賽賽賽賽 � 별같같같같같같같같 같같같같같같같같� 읕컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴� 별같같같같같같같같 같같같같같같같같훤袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴섟같같같같같같같같 같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같같 If you choose to send a report to the screen, the program presents the following screen: 컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴 Quit Scroll Toggel ��[ ]袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴袴[ ]敲 � CISMSGS FORUM MESSAGE � � 5/16/93 REPORT � � Start Msg................0 � � Forum....................0 � � Sect Number..............S0 � � Sect Name................ABOUT CISMSG � � Date.....................5/16/93 � � Time.....................11:00 � � Subject..................All about the authors of CISMSG � � In Reply To..............0 � � Msg Number...............0 � � To Name & PNN............All � � From Name & PNN..........Mark T. Houpt 70142,2720 � � � � MESSAGE: � � The following individuals contributed code to this application. I'm very � � programming, I learned from example code found in the CIS PDOXDOS libs. � � � � James Cap Walker: This application is really his idea. He created the Pa� � me a Paradox workshop application to view the files, allowed me to play w 훤袴袴袴袴袴袴袴袴 굇굇굇굇굇굇굇굇굇굇굇굇굇굇굇굇굇굇굇굇굇굇굇굇굇굇굇굇� 켸 *Print to Screen* � 컴컴컴컴컴컴컴컴컴컴컨컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴 Choose Quit or press ESC to quit viewing the report. (12) APPENDIX OZCIS Should you view your messages in OZCIS prior to attempting to import the file into this program, an error will result on import. Reading the file in OZCIS places the following characters at the start of each read message: !` (See Example Below) #: 0 S0/Forum Header Announcement !` 17-May-93 07:18:56 Sb: Pass 1 Header Fr: OzCIS To: Mark T. Houpt 70142,2720 Use a text editor to open the MES files and replace the !` characters with two (2) blank spaces. Your MES file will now import correctly. A REMINDER This program is intended as a shared learning application. Should you make changes to the program, we beg you please sent the changes to us so that we can include them in future uploads to the PDOXDOS forum. TECHNICAL SUPPORT Technical support is available. But first let me tell you a story. Back when I was a Kid-Cop, I had occasion to encounter a 14 Year old who for the purposes of this document shall be called "JJ". JJ's life ambition was to be a mercenary. In training for that pursuit, JJ shot his "best friend" right between the eyes. I believe JJ when he says he didn't mean to kill. I suspect he just wanted to see how someone reacted to being shot and was "somewhat" suprised by the result. I don't know what JJ's life ambition is now. I do know he is no longer in jail. JJ provides our technical support. Call any time! STUFF Paradox is a registered trademark of Borland International, Inc. PAL is a registered trademark of Borland International, Inc. DeskTopPlus is a CopyRight 1988-92 by Kallita, Inc. All Rights Reserved WBSLIB is a registered trademark of Weston Brothers Software, Inc, PaintPal is a registered trademark of Target Software, Inc. Other brand and product names mentioned herein are trademarks or registered trademarks of their respective holders. Anybody who wants to use Moose and Squirrel is welcome to it! (13)