____________________________________________________ 1991 North Carolina Developer's Competition - Proceedings ____________________________________________________ Officially Sponsored by: Blink Inc., "Blinker" dLESKO Associates, "FUNCky" Nantucket Corp., "Clipper" Black & White International, "Dr. Switch" Concentric Data Systems, "R&R Report Writer" Artful Applications, "Artful.Lib" A function of: Coordinated by: The NC Clipper User's Group Droege Computing Services,Inc. 2925 Huntleigh Drive, Suite 201 3200 Croasdaile Drive Raleigh, North Carolina 27604 Suite 304 Durham, North Carolina 27705 (919)383-9749 Foreword On January 12th, 17 software developers from Colorado, New Jersey, Virginia, Maryland and North Carolina squared off against each other to determine which developer could create the best application in 6 hours. They used the tools of their choice, Clipper, (Summer 87 and 5.0), Advanced dbMASTER, Oracle, Pro C, 4th Dimension, OMNIS 5 and Quick Basic2. The competition required that each team (1 or 2 persons) develop a Patient tracking system to be used by Duke Medical Center to track child abuse by Duke's Child Protection Team. Each application was then judged by teams of judges composed of systems professionals from KPMG Peat Marwick, (one of the Big Eight accounting firms), Duke Medical Center, and other software professionals and consultants. By Saturday night everyone decided that the North Carolina's Developer's Competition was a success. The competitors, judges and volunteers split $75,000 worth of cash and software products. The corporate world saw firsthand what the leading edge of technology can produce in a truly short period of time. Most of all, The Child Protection Team at Duke now has its tracking system. At least four of the teams volunteered to finish and enhance the system at no extra cost. How can your user group do something like this? It is my opinion that when 1991 is over, The North Carolina Developer's Competition will be remembered as the "hottest" event of the year. Why do I say that? Based on the response and enthusiasm generated by the contestants and the judges, they all want to do it again... and now! Here are some pointers on how to organize and conduct your own developers competition. Armed with this information, you can then start to generate enthusiasm in your user group for the event. We started over 9 months ago, selling the idea from many perspectives: for fun, as a "national event", to promote cross pollination of ideas and to promote the user group. Then get organized. We used a notebook with sections for the different committee assignments and, of course, a database to track competitors, judges, sponsors and volunteers. The major hurdles are to get a site, get competitors, get judges and get sponsorship and prizes. The easiest was to obtain sponsorship, thanks to Blink, dLESKO and Nantucket. These companies encouraged us tremendously. By December, Concentric Data Systems, Artful Applications and Black & White International had joined the ranks of our official sponsors. Many other companies donated prizes. Finding judges was also fairly easy. Choosing from the many software development companies in the area and with the sponsorship of Peat Marwick, we came up with many highly qualified judges. Of course, you will need a lot of judges, at least as many judges as competitors. The specifications called for the teams to develop an application with 3 databases, a "one", a "many" and a "table lookup", 8 reports including 2 ad hoc queries, plus form and mail merge functionality. We had 5 panels of five judges each look at every team for 20 minutes. They judged the teams on a 100 point scale which gave points for the accuracy of the reporting, the relational capabilities, basic file maintenance, user interface, screen design and color, and help facilities. The scores from each of the five judges were averaged. To insure fairness, we also computed an average by dropping the low and high score. Where the ranking would have changed based on the two different scores, we inspected the judging. In one case, one judges' result had to be disqualified. All of the judging and scoring was audited by the accounting firm of Peat Marwick. Surprisingly, it was difficult to find competitors and the application. We charged $100 to participate. Plan on competing on a Saturday. It is just too much of a challenge to pull developers away from work. (As it was, we lost 10 local developers because of work they needed to do on the weekend.) We found the application through our normal consulting channels when a client approached us with work done free. Try to pick an application that is interesting, different, and has an additional altruistic merit. The Duke Child Protection Team system provided all of these elements. The specifications for the application included information on a child's parents, demographic data, basic medical information and the history of abuse whether it was physical, sexual, or emotional. The winning team, Belsoft, a consulting firm from Richmond, VA using Clipper Summer 87, won first place by receiving an average score of 79.0. Competition was very close as the second and third place team scored 78.2 and 76.9. The Top scoring Teams and their tools were: 1. Belsoft, Richmond, VA, Clipper Summer 87. 79.0 2. Macon Systems, Colorado Springs, Advanced dbMASTER, 78.2 3. Relational Analysis, Silver Spring, Maryland, Oracle, 76.9 4. Droege Computing, Durham, NC, Clipper S87, 69.3 5. PC Concepts, East Brunswick, NJ, Clipper S87, UI2, 56.2 The rest was basic organizational hard work. Finding a site, planning the meals, budgeting, marketing, etc... Some hints include the following: Try to participate in one before you plan one. I found that even though I had spent 8 months planning the competition, my participation in Virginia's preliminary competition gave me new insights into the planning and organization of the event. No matter how well you plan, you will hit a few snags. Some, such as potential judging discrepancies, we had planned for, others we had to adapt as we went. In the end, the event was tremendously rewarding for all concerned. I would encourage your group to consider participating or planing an event like this. You may want to sponsor a user group competition to send the winner to next year's North Carolina Developer's Competition. The team that won first place did just that. In any case, you will have a great time, you will do something useful for a needy cause and you will increase the visibility of your user group and its member consultants. Introduction What is the Database Developer's Competition We all have heard claims about which development tools are the best and the quickest. The 1991 North Carolina Developer's Competition is an event which will put these claims to the test. The competition will take place January 11 and 12, 1991 and will bring together 50-100 developers from all over the United States. Application Specifics Large corporations from the "Triangle" (Raleigh, Durham, Chapel Hill and the world renown Research Triangle Park) will be encouraged to submit an application to the 1991 North Carolina Developer's Competition for a software application to be developed. The company whose application is chosen will be able to choose which competitor's system it wishes to implement after the competition (not necessarily the winner's). The system will be provided to the company free of charge. Corporate MIS personnel from these same companies will judge the event and representatives from a "Big Eight" accounting firm will be responsible for calculating and auditing the judges' results. Scope of the Competition Twenty-five to fifty development teams will be chosen to compete in the event. Each team will consist of one or two persons using a variety of database application software, languages, and third party products. Only one CPU, monitor, keyboard, and printer is allowed. This is a "no holds barred" competition. Developers can use any tools, language, or program generators. Only completed applications used as templates are prohibited. First, second, and third place contestants will receive cash prizes ($2500, $1500, $500) respectively. Third party products will be awarded to all. No competitor will leave the competition empty handed. Schedule of Events Competitors will arrive January 11, 1991 in time for a small gathering scheduled for 8:00 p.m. to meet the other competitors and sponsors and discuss the plan for the following day. A continental breakfast will be served at 7:30 the next morning, and at 8:30 the competitors will be given the specifics of the application and begin working at 9:00. Developers will have six hours to complete their application. Judging will follow for approximately three hours, then the ballots will be tabulated, and the winners announced at an awards dinner later that evening. 1991 North Carolina Developer's Competition - Schedule of Events Friday 8:00 pm Social Gathering to meet the competitors Saturday 6:00 am Set up, Coffee Only 7:30 am Continental Breakfast, Registration 8:30 am Packages handed out 8:45 am Discussion of Application, Rules 9:00 am Competition Begins 12-1:00 Lunch 1:30 pm Judges Orientation 3:00 pm Competition Ends 3:00 pm Judging Begins (preliminary round) 5:00 pm Judging Ends (Carts Available 5-6:30) 5-6:00 pm Final Judging 7:30 pm Awards Dinner Other Activities Things to do Friday or Saturday Night... Charlie Goodnight's Comedy Zone -- Live Comedy Acts Weeping Radish Restaurant and Brewery 115 North Duke Street 682-2337 The Palace International--International Music 117 West Parrish 687-4922 Haufbrau -- Blues 615 Broad Street 286-9945 Ninth Street Bakery -- Variety of Individual Artists 754 Ninth Street 286-0303 Seventh Street Restaurant -- Variety of Individual Artists 1104 Broad Street 286-1019 Under The Street -- Blues, Jazz (under 7th St. Rest) 1104 Broad Street 286-2647 System Specification CPT Patient Database Overview: The Child Protection Team at Duke University Medical Center is a multidisciplinary group that evaluates children from Durham and surrounding areas of North Carolina when there is a concern of abuse or neglect. Approximately 500 patients are seen per year. Our total case file is in the thousands. At the present time, none of the information on cases is computerized. The large number of cases make it impossible to keep up with basic statistics, epidemiology and patient care needs. Being chronically underfunded, we have not yet set up a database, though it is urgently needed. There is no off the shelf software that provides basic patient and child abuse tracking. There is a wide demand for such software although most CPT programs are underfunded. As part of the developer's competition, we will make available to associations that deal with these issues information pertaining to the availability of software solutions generated from the developer's competition. As you will learn as you study this application, the nature of this project is very serious. Record Layout and Field Definitions: You are free to change the structures as you see fit, these field lengths match the ascii files that are provided for each file. Field types YNU are 1 character wide and represent [Yes, No, or Unknown]. Patient Database: History Number 9 Character Do not allow entry of duplicate history numbers Child's Name (first) 15 Character Child's First Name Child's Name (middle) 15 Character Child's Middle Name Child's Name (last) 15 Character Child's Last Name Mother's Name (first) 15 Character Mother's First Name Mother's Name (middle) 15 Character Mother's Middle Name Mother's Name (last) 15 Character Mother's Last Name Mother Deceased 1 Character Mother deceased Father's Name (first) 15 Character Father's First Name Father's Name (middle) 15 Character Father's Middle Name Father's Name (last) 15 Character Father's Last Name Father Deceased 1 Character Father deceased Number of Siblings 2 Integer Optionally to show "unknown" Address line 1 40 Character Address line 2 40 Character City 25 Character State 2 Character Zip 10 Character County 15 Character County of Child Home Phone 13 Character (999)999-9999 Work Phone 13 Character (999)999-9999 Date of Birth 8 Date Race 2 Character [Black] [White] [Native Amer.] [Asian] [Other] Sex 1 Character [Male] [Female] School 20 Character Name of School, "Unknown" Referral Code 3 Character See Referral Table, and notes Seen by 20 Character Last Name is sufficient CME Program YNU Character Child Medical Evaluation (Yes or No) Child Died YNU Character Child Died Date Child Died 8 Date Date Child Died Admission YNU Character Child Admitted to the hospital Followup Scheduled YNU Character Followup Scheduled Followup Date 8 Date Followup Date Referral to DSS YNU Character Referral Made to Department of Social Services, Yes, No or Unknown. Agency 20 Character Agency of DSS, Name of DSS Date of Referral 8 Date Date of Referral to DSS Case Accepted YNU Character Case Accepted Referral to Police or DA YNU Character Referral Made to Police or District Attorney, Yes, No or Unknown. Agency 20 Character Name of Police/DA Referral Date of Referral 8 Date Date of Referral to Police/DA Abuse Database: Each patient can have any number of each of these records. This database contains the date, type of abuse, outcome and physical findings for each instance of abuse. The data in this file will be used to generate the statistical reports. You are responsible for linking these records with the patient record. Date of Evaluation 8 Date Date of Evaluation Category Code 3 Character SA Sexual Abuse: PA Physical Abuse: EA Emotional Abuse: FTT Failure to Thrive: N Neglect NUR Nursery: DEP Dependency: Outcome 1 Character [Confirmed] [Suspected] [Ruled Out] [Unknown] Physical Findings YNU Character Yes, No, Unknown Referral Database - Referral Code refers to a table of referral sources. During entry of patient data, the user should enter the code that represents the referral source. If they don't know the referral source, they should have some method of retrieving the code. If the code doesn't exist the user should have the ability to add the referral source to the referral table at that time. Referral Code 3 Character Unique Value Name 40 Character Practice/Hospital 40 Character Name of Practice, Hospital or referring agency Department 40 Character Department Name Address 40 Character Address Line 1 Address line 2 40 Character Address Line 2 City 25 Character City State 2 Character State Zip 10 Character Zip Code Referral Category 10 Character Examples: Duke ER, Duke General Ped, Health Department, Outside Provider, Dept of Soc Services, School, Law Enforcement, Self, Other. Other Issues: - How will the system deal with the confidentiality issue? What are your recommendations? What levels of access can you provide? - Link children with their mothers where the last names do not match. - Handle duplicate history numbers. For instance, if the user enters a history number that is already in the database, they should not be allowed to continue. Optionally, check also for duplicate birth dates while entering as a possible check against duplicates. - From the statistical reports, can bar charts, graphics, tables, etc... be generated? Address how this could be accomplished. - Needs ability to transfer data to other data forms, ASCII, or other statistical analysis. How will your system address means, medians, standard deviations, sums, totals and other basic statistical measures? Reporting: (report #1) Source of Referrals Duke Duke Medical Center - ER 999 Duke Medical Center - Eye Center 999 Duke Medical Center - Pediatrics 999 Duke Medical Center - Psychiatry 999 Halstead Ward 999 Subtotal ** 9999 Health Durham Department of Social Services 999 Smith Health Department 999 Wake Department of Social Services 999 Wake Department of Social Services 999 Subtotal ** 9999 Law Enfor. Fayetteville Police Department 999 Subtotal ** 9999 Total 99999 (Report #2) Case Analysis by Problem Category Category Total Black % White % Other % Mean Age SA 9999 999 99.9 999 99.9 999 99.9 9.99 PA 9999 999 99.9 999 99.9 999 99.9 9.99 EA 9999 999 99.9 999 99.9 999 99.9 9.99 FTT 9999 999 99.9 999 99.9 999 99.9 9.99 N 9999 999 99.9 999 99.9 999 99.9 9.99 NUR 9999 999 99.9 999 99.9 999 99.9 9.99 DEP 9999 999 99.9 999 99.9 999 99.9 9.99 Totals 9999 999 99.9 999 99.9 999 99.9 9.99 (report #3) Case Outcome by Problem Category (for one category or all categories) ie. Sexual Abuse (SA) Race # Boys % # Girls % Black 9999 99.9 9999 99.9 White 9999 99.9 9999 99.9 Native American 9999 99.9 9999 99.9 Asian 9999 99.9 9999 99.9 Oriental 9999 99.9 9999 99.9 Totals 9999 99.9 9999 99.9 Confirmed 9999 99.9 9999 99.9 Suspected 9999 99.9 9999 99.9 Ruled Out 9999 99.9 9999 99.9 Unknown 9999 99.9 9999 99.9 Confirmed 9999 99.9 9999 99.9 Mean Age 99.9 99.9 Median Age 99.9 99.9 (report #4) Fatalities For the children who died list their names, age at time of death, sex (report #5) Determine the number of records in the abuse database that match a criteria supplied to you at the time of judging. The criteria may be an expression based on either the abuse database or as related to the patient database. (report #6) Calculate the mean of a field or expression in the patient database that match a criteria supplied to you at the time of judging. The criteria will be an expression based on fields in the patient database. 1991 North Carolina Developer's Competition - Judge's Scoring Sheet Team# ________Company_________________________________ Judge#________Total_______JudgeSign.____________________________ It is the competitor's responsibility to demonstrate each function. You will have at most 15-20 minutes to demonstrate your program. Judging on the reporting section will be done by matching your reports with specific items on the reports answer sheets. Run each report, and wait for the judge to ask you for specific values, the judge will write those values down. The total for the reporting session will be used by all the judges. _____ 40pts Reporting. 5 pts for each of the following. (Before judging, the competitor should delete all test data, load the sample data and be prepared to demonstrate the ability to run the following reports. You will be judged for accuracy.) ____ Report #1 ____ Report #2 ____ Report #3 ____ Report #4 ____ Determine the count for a criteria supplied at the time of judging. ____ Determine the average for a criteria supplied at the time of judging. ____ Set up a custom form to print specified fields supplied at the time of judging. ____ Set up a mailmerge type facility. _____ 5pts Data Validation on coded field. Does the application force the key field to be unique? _____ 5pts Field lengths and types. Are all of the fields the correct length and type. (deduct .5 points for every incorrect field type or length. _____ 5pts Look-Up Table. One point for each of the following: ____ Callable from data entry screen. ____ Retrieves code and stuffs the keyboard. ____ Search using directional keys. ____ Search by Key field value. ____ Incremental searches by more than one index. _____ 5pts Relational Aspects. When the key field in the "one" database is changed, do all the related record's key fields in the "many" database change accordingly? _____ 5pts Deleting. When deleting one record from the "one" database, does the system delete all the related records in the "many" database? _____ 5pts Utility Functions. One point for any of the following. Maximum of 5pts. ____ Backup ____ Restore ____ Format ____ Chkdsk ____ DOS Dir Functions ____ DOS Exit and Execute program ____ DOS Editor ____ Change Config.sys or Autoexec.bat Files ____ Other ____ Other _____ 5pts Basic File Maintenance. Are all the basic file maintenance functions covered? _____ 5pts Confidentiality of Data. Does the system protect the confidentiality of the data. _____ 5pts User Interface. Evaluate the ease of use. (1 point for each reason given. Note for the following items the competitor should give reasons to support the item being judges, if you consider that a valid reason, give the points indicated, it is reasonable to expect that the same reason may be given to support ease of use, intuitiveness, documented, etc...) _____ 5pts Screen design. Grade the screen design and layout. (1 point for each reason given) _____ 2.5pts Intuitiveness. Evaluate the intuitiveness of the user interface. (2.5 points for 2 or more reasons) _____ 2.5pts Self Documented. Can the user operate the program without written documentation? (2.5 points for 2 or more reasons) _____ 2.5pts Help Features. How are different levels of helps implemented. Are they helpful? (2.5 points for 2 or more reasons) _____ 2.5pts Use of Color. Grade the choice of colors and/or the ability to set your own colors. _____ Subtotal _____ Penalty Penalty Points. Deduct 1 point for each fatal error. (Unexpected return to DOS) _____ Total Score In your opinion would this application qualify for one of the following special awards? ____ Best Overall Application ____ Most Attractive Interface ____ Most Intuitive Interface ____ Best Reporting abilities ____ Best Ad-Hoc Queries ____ Best on-line help 1991 North Carolina Developer's Competition - Rules 1. Any language, toolset, or program generator may be used in the program development. 2. The maximum number of members per team is two. 3. One computer and one keyboard per team. You must provide your own computer. (We will attempt to have replacement parts available, no guarantees!). Multitasking is acceptable. 4. Previously completed applications may not be used. 5. Any reference material on any type of media is acceptable (except previously completed applications). 6. Advanced information on the application for the competition is not permitted. Competitors will receive the rules and judging criteria before the event. The application will involve a main database, a table lookup related to one of the fields in the main database, and a file with a many relationship to the main database. 7. Collaboration with other teams is not allowed. Consultation or assistance from outside the team is not allowed. 8. Judging will be based on demonstrated capability, not on what the team says the programs can or could do. It is the developer's responsibility to demonstrate that the program meets the judging criteria within the 10 minutes allowed. 9. Non-compliance with these rules will result in immediate disqualification (as determined by the Rules Committee). Decisions on infractions by the Rules Committee is final and may not be repealed. 10. Rights to the each application will remain with the software developer. Each developer grants license to use the program at no charge to the following: 1) the company that provided the application, 2) the NC Developer's Competition Committee for inclusion in "The Proceedings" and for any other use deemed useful by the NC Developer's Competition Committee. With the exception of providing "The Proceedings" at moderate cost ($50-$100), no entity besides the original developer has the right to sell, market or distribute the applications. It is the duty of the developer to include appropriate copyright notices to this effect. 11. Participation in the competition implies acceptance of these rules and conditions. Scoring - Determining the Winner 1. Each team's application will be judged by a panel of five judges and a representative from the rules committee. The judging packet which contains 6 judging sheets, 1 criteria sheet and 1 answer sheet will be opened by the rules committee rep. The criteria sheet will be given to the team. The answer sheet will be held by the rules committee rep. to validate the reporting results. 2. The team has 10 minutes to demonstrate to the judges the capabilities of its application. Each judge will fill out their judging sheet. The rules committee rep will also judge the application in case one of the judge's results is suspect (see below). 3. The average of all 5 scores will solely determine ranking. We will review the judging in the following way: If by dropping the high and low scores for any team, the ranking for that team would be changed by 2 or more places, we will review the judging for that team. The rules committee has the option to do any of the following: rejudge the application, substitute the result from the rules committee rep, or replace the score with the average of the other 4 scores. 4. The top 5 teams will advance to the finals. All of the teams in the finals will be judged by the same team of 5 judges. Ranking will be determined by the average of the judges' results. Prizes 1st Place $2,500 in cash, and a selection of products listed below 2nd Place $1,500 in cash, and a selection of products listed below 3rd Place $500 in cash, and a selection of products listed below Products to be given away as prizes Product List Price Quantity ----------------------------------------------------------------------- Alpha Four 350? 8 Artful Lib 295 25 Blinker 189 25 Clarion 699 12 Clipper 795 0 Code Base 4.2 295 1 dBASE IV 795 5 dBRIEF 249 10 DESQview 190 0 Dr. Switch 180 5 FUNCky Library 195 25 GetIt 129 2 Grumpfish Library 199 5 Grumpfish Menu 199 5 Grumpfish Query 159 5 NetLib 249 2 Paradox 725 5 R&R 149 25 RaSQL/B 249 10 Sell More Software 100 25 Softclip 179 0 SysInit 195 25 TimeTrack 129 25 Turbo C++ 200 5 Turbo Pascal 175 5 UI2 595 0 DataEase 0 0 DataEase Developer 0 0 1991 North Carolina Developer's Competition - Application Profile Competitor # ________Company_________________________________ Fill out the following information about your application. This information will be used to help the client determine which application they will use. What hardware is required to run the application. List minimum and optimum requirements. What additional software is required to run the application. List cost. What would your rates for ongoing software development, maintenance and customization be? Give an estimate of the total cost to completion should you be chosen to complete the project. What is your development environment? (What tools are needed, or suggested for ongoing development of your application?) Software Languages_____________________________________________ Compilers______________________________________________ Linkers______________________________________________ Libraries______________________________________________ Debugging tools______________________________________________ Operating Systems (OS, Network)______________________________________________ Editor______________________________________________ Multi-User______________________________________________ /Multitasking Environment Application Profile - (continued...) What are the installation parameters needed to install the software? Config.Sys Settings______________________________________________ AutoExec.bat Settings______________________________________________ Network Settings (Shell.cfg)_____________________________________________ Other______________________________________________ If you are using a template approach... What is the size in KBytes of your Source (before) ____ What is the number of lines of code (before) ____ What is the size in KBytes of your Source (after) ____ What is the number of lines of code (after) ____ Would you be interested in marketing your product to other child protection teams nationwide? ____ Company Profiles The following company profiles were provided by each company. They are grouped by involvement. The competitors, judges, sponsors, product donors, and staff members are listed in order by company name. COMPETITOR William Marsh AEPCO Inc. 15800 Crabbs Branch Way Suite 300 Rockville, MD 20855 (301)670-6770 AEPCO, Inc., a minority-owned company, was founded in 1979 to provide quality engineering and scientific consulting services to government and industry. Our focus is to resolve complex technical problems by applying sound engineering principles and innovative concepts. During its existence, AEPCO has grown into a respected, multidisciplinary engineering and scientific service company. AEPCO seeks business opportunities that challenge our staff members to expand the bounds of their knowledge and experience. We encourage innovation, foster ingenuity, and reward creativity in solving our clients' problems. Areas of expertise include acquisition planning; ILS planning and management; systems and environmental engineering; architectural design; financial management; MPT; ADP; MIS; and CAD/D. Kevin Mooney Applied Information Systems 500 Eastowne Drive Suite 207 Chapel Hill, NC 27514 (919)942-7801 Fax: (919)493-7563 Peter Brawley Arthur Fuller Artful Applications 176 St. George Street Toronto, Ontario, M5R2M7 Peter Brawley and Arthur Fuller are the developers of Artful.Lib and Artful Two. They are 2 of 3 principles of Artful Applications, Inc. Mr. Brawley and Mr. Fuller have both written articles on programming and are software consultants and developers. They will be partners for the competition and will be using Clipper, Artful.Lib, UI2, Overlay, Smartmem.Lib, RTLink, RMake, Blinker, QEdit and Liblist. John Beckner BecknerVision, Inc. PO Box 1541 Lumberton, NC 28359-1541 John Beckner has been a Clipper developer since W.85 version. He developed vertical market applications in insurance, real estate, consumer loans and premium financing. He is the author of BECKNER.LIB, the first commercially available Clipper 5.0 third party library. Mr. Beckner will be using Clipper, Blinker 1.11 (or 1.3+), BECKNER.LIB 1.0, editor - Word Star 4.00 and DOS - MS-DOS 4.01. Mike Beall M. G. Kademani Belsoft, Inc. 13908 Belmont Stakes Court Midlothian, VA 23112 (804)233-5471 Michael Beall and M.G. Kademani develop custom single and multiuser Clipper (tm) applications. They provide an intuitive and user-friendly interface that is consistent throughout all of their applications. They also provide a custom reporting facility that has screen and printer options. Other services include hardware and software system design and installation for most popular networks (ie. Novell, 3Com, Banyan and Lantastic). Some applications developed include: Manufacturing Purchasing, Payroll System for the Milk Producers Association, Blood Pressure and Hypertension Tracking for State-wide use, Fitness Center Management, Sales Commission Tracking for Midatlantic Medical Distributors of Depuy Medical Supplies, Tour and Travel Management, and Sales, Consignments and Rental Management for Computer Companies. Michael Beall and M.G. Kademani are partners in the competition. Frank Barnhill Bits n' Bytes Computers 927 Old Dam Road Liberty, NC 27298 (919)376-3967 Jimmy Yelverton Carolina Group PO Box 4155 Asheboro, NC 27204 (919)626-7542 John Shepherd Tony Wazny Catawba Computers & Communications 8357 Newport Road Catawba, VA 24070 (703)983-6139 John Shepherd, owner of Catawba Computers & Communications: Lead Systems Analyst for BellSouth Communication Systems; Author of all RPTS; Staff member of Village Software. Mr. Shepherd's partner for the competition will be Tony Wazny of MicroKnight. Don King Computer Ease 927 Old Dam Road Liberty, NC 27298 (919)376-3967 Donald King is a consultant, developer of software and VAR of personal computer systems. He and his partner for the competition, Frank Barnhill, have been in the personal computer business since 1984, developing and marketing custom software such as accounting systems, fixed assets, personnel, etc. They will be using Clipper, C, Pro-C, Grumpfish Lib and Codebase 4. ComputerEase, founded in 1984, focuses on computer solutions for the small to medium sized business. Customized software packages automate accounting procedures, purchasing management, and inventory or fixed asset management with bar coding capabilities. Training, user support, and hardware for the turnkey solution make corporate computing power possible for the smaller business. As a customer of ComputerEase, you don't have to be a Fortune 500 company to compute like one! Blair Hill Hoornaz Kuklan Droege Computing Services 3200 Croasdaile Dr. Suite 304 Durham, NC 27705 (919)383-9749 Blair Hill and Thomas Droege have developed the software development tool, SysInit. This Clipper Library is the engine that drives over 100 different management information systems used by hospitals and businesses all over the US and Canada, and in the U.K., Belgium, France, Germany and Japan. Hoornaz Kuklan has developed many applications including, Key Control, Public Safety Incident Tracking, Work Order Management, Worker's Compensation, and many other management information systems used by service oriented departments in large medical centers. Dennis Elledge Elledge & Associates PO Box 5095 Raleigh, NC 27650 (919)832-0241 Paul Rasmussen Randy Hersom Habilitation Software, Inc. 204 N. Sterling Street Morganton, NC 28655 (704)438-9456 For over five years Habilitation Software, Inc. has been creating and marketing software for agencies serving persons who are developmentally disabled. Two of their products are the Habilitation Documentation System (HDS), which graphs progress towards client objectives, and Assure! - The Quality Assurance System, which provides comparative data to agencies about the performance of their service components. Habilitation Software, Inc. is located in Morganton, North Carolina. Mr. Hersom, Director of Programming, is the partner of Paul Rasmussen, President of Habilitation Software. Randy Crawford Knowledge Modeling Corporation 2628 Ferrand Road Durham, NC 27705 (919)383-1243 Kieron Hardy Macon Systems 725 South Tijon Street Colorado Springs, CO 80903 (719)520-1555 Macon Systems developed DB Master (the best-selling database system for Apple II's in 1980 and 1981) and has continued as a software development company with Advanced DB Master (for IBM/compatible) since 1981. Ms. Hardy will use Advanced DB Master, Level IV, Version 4.1, a completely menu-driven relational data base management system with proprietary programming commands. Thomas Reynolds N.C. State University Budget & Administration System Box 7206 Raleigh, NC 27695 (919)737-2175 Thomas Reynolds is an applications programmer for the Finance and Business Division of North Carolina State University. They develop micro applications in Clipper (C, etc.) to automate manual processes. Most applications deal with university accounting procedures. Mr. Reynolds will be using Clipper Summer 87 (possible version 5.0), VI Developers Addition, "Brief Editor, Clipper Tools 1 Library, Flipper, Soft-clip Library, Microsoft Quick C, and R&R Report Writer. Michael Smith Michael Stewart PC Concepts 4A Aver Ct. East Brunswick, NJ 08512 (201)613-1777 Michael Stewart and his partner Michael Smith, have worked in almost exclusively Clipper for three years. They have worked heavily with SBT code, also incorporating C and Assembler. Both men have been out of school for 3 1/2 years and have had substantial Novell experience. Consulting work: ITT, Prudential, Hoffman-Laroche, Proctor & Gamble, Kimball, ABB. Mr. Stewart and Mr. Smith will be using Clipper, the UI programmer, Netlib, Blinker, Spfpc Foxbase (as debugging tool), PConcept.lib (personal), Byte (third party lib.). Sam Youngman Stan Quick Relational Analysis 429 Greenbriar Drive Silver Spring, MD 20910 Relational Analysis provides expert consultation on the Oracle, Sybase, and Ingres relational database systems. Sam Youngman, a hands-on computer scientist, has been designing sound, efficient, and easy-to-use relational database applications since 1978, which includes nine years of Oracle experience. He can rapidly implement any requirement using SQL*Forms, PL/SQL, and the other Oracle tools on VAX/VMS, MS-DOS, IBM/MVS, and UNIX platforms. In addition, a powerful microcomputer system enables RA to remotely develop portable applications. RA offers unique experience in performance tuning, database administration, benchmarking, and DoD systems analysis, as well as unequaled programming in PL/1, C, and FORTRAN. Furthermore, Mr. Youngman is the author of numerous RDBMS papers and has been a speaker at the last three International Oracle User Group conferences. Sam is also the President of the Washington Chapter of the Independent Computer Consultants Association (WICCA). Sam Youngman's partner in the competition is Mr. Stan Quick. Henry Jacobs Sinc, Inc. 1299 La Velle Drive Xenia, OH 45385 (513)372-4334 Stan Quick SQC, Inc. C/O Relational Analysis 429 Greenbriar Drive Silver Spring, MD 20910 Mr. Stanley Quick has been developing custom business computer applications for clients for thirteen years. He formed SQC, Inc., in 1987 to provide complete life-cycle development expertise using database foundations, especially Oracle and FOCUS, to implement solutions to complex business problems. These problems have included litigation support for major patent infringement cases, sales tracking for communications equipment, and radiation tracking for a nuclear power plant, to name a few. Mr. Quick is an active participant in the local and International Oracle Users' Group as both a speaker and has served as an officer for four years. Stan Quick's partner in the competition is Mr. Sam Youngman. Frank Luo Weathersby Dull Bostian & Waynick (ITI) 1 Centerview Drive Suite 200 Greensboro, NC 27407 (919)294-8510 Frank Luo is the owner of LUO Computer Services. He uses the LUO Clipper Library and he also works for ITI. He will be using Clipper and personal libraries and his personal program generator. JUDGE Brian Smith BES Consulting 9438 Waterford Drive Manassas, VA 22110 (703)330-9418 Randy Laco CBR Associates 1018 Broad St. Durham, NC 27705 (919)286-1326 CBR Associates, Inc. is a consulting firm providing management information solutions for the health care field. The primary goal and effort of CBR is to assist hospital management in increasing quality of care and lowering costs. CBR has developed three integrated modules--Risk Management, Quality Assurance, and Physician Credentialing. These software modules provide hospitals with easy-to-use tools for use in the area of quality management. John Hawkins Data Based Advisor 4010 Morena Rd. Suite 200 San Diego, CA 92117 (619)483-6400 Thomas E. Frothingham, MD Department of Pediatrics Box 3937 DUMC Durham, NC 27710 (919)684-3006 Marcia Herman-Giddens, PA, MPH Department of Pediatrics Box 3937 DUMC Durham, NC 27710 (919)684-3006 Mickey Hatem Department of Pediatrics Box 3937 DUMC Durham, NC 27710 (919)684-3006 Jeanne Neimyer, MSW Department of Pediatrics Box 3937 DUMC Durham, NC 27710 (919)684-3006 Karen St. Claire, MD Department of Pediatrics Box 3937 DUMC Durham, NC 27710 (919)684-3006 Ed Jones 6618 Fisher Ave Falls Church, VA 22046 (703)536-6215 Chip Duke Management Technology - NSI PO Box 12313 2 Triangle Drive RTP, NC 27709 (919)541-1530 Richard Lowe Medical Center Information Systems Box 3900 DUMC Durham, NC 27710 (919)684-8482 Bill Schicht NC Division of Mental Health 325 North Salisbury St. Raleigh, NC 27603 (919)733-7011 Curt Edge NCSC PO Box 12889 RTP, NC 27709 (919)248-1148 Chip Hildreth North American Computer Service 18 West Colony Place Suite 210 Durham, NC 27705 (919)493-2477 Allen Pippin Northern Telecom, Inc. P.O. Box 13010 RTP, NC 27709 (919)992-8189 Gil Ramsey Northern Telecom, Inc. P.O. Box 13010 RTP, NC 27709 (919)992-2378 Kendall Ferner PC Experts 4183 Lake Meadow Drive Kernersville, NC 27284 (919)993-6047 John Connell KPMG Peat Marwick Suite 2800 Two 1st Union Center Charlotte, NC 28282 (704)335-5323 John Connell is a manager in KPMG Peat Marwick's Carolinas' Management Consulting Practice based in Charlotte, North Carolina. He has assisted many clients with the design and implementation of packaged and custom data processing systems in the manufacturing, distribution, government, and real estate arenas. Prior to joining Peat Marwick, Mr. Connell was an information technology consultant for another large public accounting firm. Lee E. Dempsey KPMG Peat Marwick Suite 2800 Two 1st Union Center Charlotte, NC 28282 (704)335-5323 Lee Dempsey is a senior consultant in Peat Marwick's Carolinas Management Consulting Department based in Charlotte, North Carolina. Mr. Dempsey has over four years of consulting experience in the analysis, design, implementation, operation, and management of EDP systems. His consulting background ranges from the automation of manual control systems to the design and implementation of distributed data processing networks within the mid-range environment. Debbie Green KPMG Peat Marwick Suite 2800 Two 1st Union Center Charlotte, NC 28282 (704)335-5323 Debbie Green is a consultant in Peat Marwick's Carolinas Management Consulting Department based in Charlotte, North Carolina. Ms. Green has over seven years experience in Information Systems including systems development, analysis, design, and implementation within the IBM mainframe environment. Her industry experience lies in the manufacturing area. Betina Mobley Bell KPMG Peat Marwick Suite 2800 Two 1st Union Center Charlotte, NC 28282 (704)335-5323 Betina Mobley Bell is a consultant in KPMG Peat Marwick's Carolinas Management Consulting Department. Ms. Bell has a broad quantitative and analytical background with a extensive knowledge of strategic management informatino systems planning and microcomputer applications packages. Ken Pugh Pugh-Killeen Associates 4201 University Drive #102 Durham, NC 27707 (919)490-6335 Johnnie Dennis Realsoft, Inc. 105 Carol Ct. Greenville, NC 27834 (919)355-0370 Glenn Clingroth SDU Consulting Inc. 111 Providence Road Chapel Hill, NC 27514 (919)493-7250 Dan Bandi SysPlus 2900 Yonkers Road Raleigh, NC 27604 (919)834-2334 Sysplus provides consulting services, application software, computer systems, and installation support to firms in the Research Triangle Area. We provide specialized support for the Legal, Medical, and Financial Industry. Capabilities include PC, S/36, and AS/400 systems and applications. Bert Borngesser SysPlus 2900 Yonkers Road Raleigh, NC 27604 (919)834-2334 Mark F. Friedman UAI Technology, Inc. 68 T.W. Alexander Drive P.O. Box 13628 RTP, NC 27709 (919)541-9339 Mark Friedman is the Chief Financial Officer and Vice President of Administration for UAI Technology, Inc. He also is President of UAI's Leonard Financial Planning Systems division. UAI, headquartered in Research Triangle Park, has three primary divisions. Phoenix-Hecht is the nation's leader in cash management software and databases. Phoeniz-Hecht/Gallup conducts syndicated market research studies in banking, money management, insurance and other financial related industries, and provides software applications to manage this information. Leonard Financial Planning Systems develops and markets software to Personal Financial Planners, and is the leading provider of these types of software products in the country. UAI employs more than 60 people in North Carolina, Princeton, NJ and Highland Park, IL. The company has twice been named by INC. Magazine as one of the fastest growing companies in America. The company was founded in Durham in 1978 and moved to its current headquarters in 1985. PRESS Dian Schaffhauser Data Based Advisor 4010 Morena Rd. Suite 200 San Diego, CA 92117 (619)483-6400 PRODUCT DONORS Alpha Software Corporation One North Avenue Burlington, MA 01803 (800)451-1018 Providing 8 copies of Alpha Four Software. Alpha Four is the fully relational database software that allows you to create custom database applications without programming. You outline your applications and your relational links through an intuitive and comprehensive set of menu choices. A runtime version is available so you can distribute your applications to other users or clients. Ashton Tate Corporation 20101 Hamilton Ave. Torrance, CA 90502 (213)329-8000 Providing 5 copies of dBASE IV Software. dBASE IV provides both beginning and advanced users with solutions to a wide range of PC data management needs, from simple customer list management to complete accounting and inventory systems. dBASE IV brings significant productivity gains to both users and application developers. Users can accomplish simple data management tasks with menu-driven query and reporting capabilities. They can manage their data quickly and easily without programming. dBASE IV's automated development features and powerful application development language provide a solution for more complex needs. This combination allows developers to build better applications faster without sacrificing flexibility. dBASE IV offers upward compatibility from dBASE III PLUS, allowing current files and most applications to be used without modification. Plus, dBASE IV provides true multi-user capabilities for local area networks (LANs). These built-in capabilities include fully automatic file and record locking, screen refresh and complete data security. To minimize costs, multiple users can share a single copy of dBASE IV using the economical dBASE IV LAN Pack. Borland International, Inc. 1800 Green Hills Road Scotts Valley, CA 95066 (408)438-8400 Providing 5 copies each of Paradox, Turbo C++, Turbo Pascal. By any standard, Paradox is the most powerful database. That's why it's been rated #1 by every leading computer publication, and why hundreds of thousands of users worldwide have switched to Paradox. Paradox includes a full-development language (PAL) for building complete database applications. And now, with Paradox SQL Link, programmers can integrate SQL statements into PAL programs, use SQL table cursors, trap server error codes, and tap the unique capabilities of different database servers. Turbo Pascal Professional includes Turbo Pascal 6.0, protected-mode, command line compiler, Turbo Debugger, Turbo Profiler, and Turbo Assembler. Turbo Pascal now includes Turbo Vision, the first object-oriented application framework for MS-DOS. With Turbo Vision, applications automatically inherit a multi-window, mouse-based, user interface. Turbo C++ Professional includes C++ (based on AT&T's 2.0 specification), ANSI C, Turbo Debugger, New! Turbo Profiler, and Turbo Assembler. Clarion Software 150 East Sample Road Pompano Beach, FL 33064 (800)354-5444 Providing 5 copies each of Software Distribution Kit and Report Writer, and one copy each of Personal Developer 2.0 and Professional Developer 2.1. Report Writer accepts information in the most meaningful ways for you. It accepts information from any number of files even those produced with dBASE or other software. You can join together unlimited files, print fields from other files, and/or use other fields in computations. Personal Developer 2.0 allows you to create, modify, and run your own custom applications. Designing custom screens and reports are a snap with "point and shoot" applications. Included in the package are ready-to-run applications that you can use "as is" or customize for your own requirements. Professional Developer is "The most advanced DBMS/Application Development Environment Available for the PC." The application generator significantly reduces the time and cost of producing all applications. It allows your to incorporate dBASE, BASIC, and DIF files to generate reports and queries. It includes full LAN support. The whole environment is friendly and comfortable - and very, very fast. Communications Horizons 701 Seventh Avenue, 9th Floor New York, NY 10036 (212)724-0150 Providing 10 copies of RaSQL/B, 2 copies of GetIt and 2 copies of NetLib. DataEase International 7 Cambridge Drive Trumbull, CT 06611 (203)374-8000 Droege Computing Services, Inc. 3200 Croasdaile Drive Suite 304 Durham, NC 27705 (919)383-9749 Providing 25 copies each of SysInit and Sell More Software. Droege Computing Services is a software development company specializing in applications for healthcare. They market a series of programs for use as departmental information systems by large hospitals. The Sell More Software program is designed to facilitate the marketing, sales, and administrative activities involved in selling computer software. Created specifically for software developers and value-added re-sellers, the program helps to plan projects, track contacts with prospects and clients, track support and print custom mail merge documents and forms. SysInit is a set of procedures and routines that provides a complete development environment. It allows you to develop complex, network-compatible applications with less time spent on data entry and file management operations. SysInit handles all of the screen management, database management, printing, and network operations you face every time you develop a Clipper application. Grumpfish, Inc. P.O. Box 17761 Salem, OR 97305 (503)588-1980 Providing 5 copies each of Grumpfish Library, Grumpfish Menu, and Grumpfish Query. Grumpfish Library adds professional polish and pizazz to your Clipper programs immediately. You will not have to waste hours learning a new language to use Grumpfish Library-- even new Clipper developers can integrate Grumpfish modules into their programs within minutes of breaking the shrink-wrap. Grumpfish does the work while you get the praise. With Grumpfish Menu, you can slash your development time. Create working prototypes in minutes rather than days. Handle change orders in seconds rather than weeks. If you can write a text outline file, you can create a gorgeous, easy-to-use front end menu system with Grumpfish Menu. Grumpfish Query is a complete ad hoc reporting system that you can link into your application immediately. Handles relations, output to screen/printer/text file/DBF/WKS, data dictionary, supports 90 printers, and much more. Sequiter Software Inc. P.O. Box 5659 Station L Edmonton, Alberta, CANADA (403)437-2410 Providing one copy of Code Base 4.2. Code Base 4.2 is the C Library for database and screen management. You can build a multi-user, dBASE compatible application which is several times faster than dBASE IV, Clipper, or Fox Pro. As you directly use the data, index and memo files of dBASE III through IV or Clipper, you can use Code Base 4.2 with any dBASE compatible product. Code Base 4.2 executables are 1/2 to 1/3 the size of corresponding Clipper executables. Softsystems, Inc. 148 West Orange Street Covina, CA 91723 (818)332-1919 Providing 25 copies of TIME TRAK. The TIME TRAK systen is designed to provide a variety of techniques for scheduling your own or other individuals appointments or for scheduling resources such as meeting rooms, equipment, etc. TIME TRAK may also be used on a local area network with the appointment and user files located on a server. Solutions Systems 541 Main Street South Weymouth, MA 02190 (617)431-7445 Providing 10 copies of dBRIEF. dBRIEF is the dBase enhancement for the best selling BRIEF editor. Together, the two create a dBase editing environment that puts maximum programming power in your hands. dBRIEF allows you to indent and re-indent code automatically, view DBF file structures while writing source code, create headers for functions, procedures, and programs that are user-definable, programmable, and application sensitive, and print source code with conditional outlining. WallSoft Systems, Inc. 233 Broadway Suite 869 New York, NY 10279 (800)233-3569 The UI Programmer 2 (UI2) is a powerful development environment which includes a screen painter for designing screens and reports, an integrated data dictionary and a template-driven applications generator. UI2 includes a basic set of templates that generate various dBASE III+ dBASE IV, Clipper, FoxBASE, FoxPro, Quicksilver, dBXL and C programs, automatically. Additional templates are available, both from WallSoft and from a growing list of third party vendors. Experienced programmers can also write their own templates designed to meet their individual needs using UI2's object-oriented template language. Retail Price: $595 (Dbase version; available through dealers). UI2 for C: $695 (Only available from WallSoft). System Requirements: IBM XT, AT, PS2 and compatibles, MS DOS, 640K, min. 2 MB disk space. SPONSOR Artful Applications 176 St. George Street Toronto, Ontario, M5R 2M7 (416)920-7395 Last year's most revolutionary Clipper product is now available for Clipper 5.0! Artful pioneered data-driven programming for Clipper. Now Artful is completely rewritten to take full advantage of Clipper 5.0 - slashing your development, making your applications smaller, faster and even more powerful. There is nothing to compare with Artful Two. Not a code generator, not a canned set of frozen routines, Artful is a suite of intelligent black boxes which combine to supply 70, 80 even 90% of your application's code. Multi-page, multi-file, multi-zoom screens. Pulldown menus. Relational queries. Field-level help system. Relational Find. Report Manager. Dictionary Manager. A battery of sophisticated WHEN and VALID routines. User-configurable color schemes. Multi-level security via user passwords. Language transparency: translate the headers, remake the library and ship your program in any language. Multi-user transparency: change NO code to create a multi-user program -- simply use another link file. Cascading replaces and deletes. Add indexes and relations without even leaving your application! You owe yourself a look at Artful Two. It may be your most profitable decision of the year. Phillip Smith Black & White Intl., Inc. P.O. Box 1040 Planetarium Station New York, NY 10024 (212)787-6633 Dr. Switch-ASE turns any size dBASE language application into a RAM resident (TSR) program. TSR's created with Dr. Switch-ASE occupy only 16-20K of RAM. Dr. Switch-ASE includes Cut, Past, Timer, Alarm and Macro functions. Supports Clipper Summer 87, Clipper 5.0, dBASE III Plus, dBASE IV, FoBASE+ and FoxPro. Dr. Switch-ASE supports both Expanded and Extended memory and is fully network compatible. Dr. Switch allows you to switch between any two programs using a hot key. It includes a Cut & Paste feature for transferring data between programs. The built-in macro capability allows playback of an infinite number of keystrokes. Dr. Switch also includes an Exit-To-DOS enhancer, a memory mapping utility, a menu builder and a TSR swapping utility. Supports Expanded and Extended memory and is fully network compatible. Dr. Switch-DeveloperPak allows dBASE language programmers to run large programs directly from their applications. The DeveloperPak supports Clipper Summer 87, Clipper 5.0, dBASE III Plus, dBASE IV, FoxBASE+, FoxPro, QuickSilver and Vulcan. The DeveloperPak replaces the RUN/! command. It swaps all but 4K of an application out of memory before running a program. Developers can include Dr. Switch with their applications without royalties. It supports Expanded and Extended memory and is fully network compatible. Jim Boomer Blink, Inc. P.O. Box 7154 Richmond, VA 23221-0154 (804)353-0137 Jane Christie Blink, Inc. P.O. Box 7154 Richmond, VA 23221-0154 (804)353-0137 Blink, Inc. is an innovative software company committed to providing high quality programming tools, which enable PC software developers to create more powerful and efficient software applications in a shorter time frame. The strengths of the company lie in the technical excellence of its software, the firm commitment to continued product development and the prompt and comprehensive technical support offered to customers. This privately held, international company is headquartered in Richmond, Virginia. The pilot product is a linker, BLINKER, which contains a multitude of features tailored specifically for the Clipper market, to optimize usage of limited resources such as development time and available memory on the computer. BLINKER, written in assembly language, is on the cutting edge of technology, being the first dynamic overlay linker on the market and the first product to dynamically overlay C and assembler code. Blink, Inc. has also introduced transparent incremental linking for Clipper, reducing link times from minutes to seconds and virtually eliminating the link phase of development - now it is only necessary to Edit-Compile-BLINK! Blink, Inc. has made vast inroads into the Clipper market worldwide in a relatively short space of time, with distribution in the United States, Canada, Australia, Asia, the Middle East, Africa and Latin America. BLINKER in exclusively distributed in Europe through the UK subsidiary Blink, Inc., currently based in Wales. Jud Cole Blink, Inc. P.O. Box 7154 Richmond, VA 23221-0154 (804)353-0137 Jud Cole, President of Blink, Inc., is responsible for product development. A graduate in Computer Science from Imperial College, London, he worked with IBM for 3 years before setting up his own consultancy business and has over 10 years of experience in the computer industry. Jane Christie, Vice President of Blink, Inc., oversees all daily operations. She is a graduate in law from University College, Cardiff, with over 6 years of business experience. Malcolm Shedden Blink, Inc. P.O. Box 7154 Richmond, VA 23221-0154 (804)353-0137 Robert Hershfield Concentric Data Systems 110 Turnpike Road Westboro, MA 01581 (508)366-1122 Concentric Data Systems, Inc. develops and markets a family of R&R Report Writers. The latest release, Version 4 of R&R Report Writer for dBASE and compatibles, began shipping in December 1990. It produces publication-quality reports with proportional fonts for HP LaserJet, PostScript, and Epson dot-matrix printers, and contains many other new features. R&R has been recognized as Reader's Choice report writer for Data Based Advisor and DBMS Magazine for 1989 and 1990, PC World's Best Products of 1990, PC World's Editor's Favorite Utilities, InfoWorld's Top 100, and PC Magazine Editor's Choice. PC World recently called R&R "The undisputed reporting champ of the dBASE world." Other versions of R&R are available for ORACHE SQL, Novell NetWare SQL, XDB SQL, and Lotus 1-2-3 and Symphony. Deborah Woolridge dLESKO, Inc. 320 York St. Jersey City, NJ 07302 (201)435-8401 dLESKO INCORPORATED is the publisher of the FUNCky Library for Clipper, winner of the Database Advisors Readers Choice Award for 1989 and 1990. Formed in 1987 and based in New Jersey, dLESKO provides support and development tools for Clipper developers throughout the world. It's primary product, FUNCky, extends the traditional features of Clipper by providing a library of User Defined Functions (UDFs) that can be incorporated into Clipper applications as though they were an intergral part of the Clipper language. FUNCky is 5.0 compatible and includes 450 feature or enhancements. Mouse support, DOS disk and file access routines, expanded video functionality & increases speed are prominent. Multiple File Specifications and Embedded Attributes are among the most notable of the new features. Mark Whiteside Nantucket Corporation 12555 W. Jefferson Blvd. Suite 300 Los Angeles, CA 90066 (213)390-7923 Clipper 5.0 is a comprehensive application development system for PCs offering network support, user-extensibility, a replaceable database driver and executable file generation. An open architecture system, Clipper 5.0 includes a robust language, pre-processor, compiler, linker, virtual memory manager, editor and a debugger and permits development of applications that are larger than available memory. STAFF Cliff Allen Allen Marketing 6070-H Six Forks Rd. PO Box 19765 Raleigh, NC 27609 (919)848-4764 Chris Allen Allen Marketing 6070-H Six Forks Rd. PO Box 19765 Raleigh, NC 27609 (919)848-4764 Mary Scott Custom Application Software Systems PO Box 37824 Raleigh, NC 27627 (919)834-3250 Jeanne Nerwinski Custom Software Designs 112 Leon Street Durham, NC 27704 (919)477-0542 Bonnie Carver Droege Computing Services 3200 Croasdaile Drive Suite 304 Durham, NC 27705 Thomas Droege Droege Computing Services 3200 Croasdaile Drive Suite 304 Durham, NC 27705 Michael Hillerbrand Droege Computing Services 3200 Croasdaile Drive Suite 304 Durham, NC 27705 JoAnn Jacobs Droege Computing Services 3200 Croasdaile Drive Suite 304 Durham, NC 27705 Chuck Snyder Droege Computing Services 3200 Croasdaile Drive Suite 304 Durham, NC 27705 Christy Yates Droege Computing Services 3200 Croasdaile Drive Suite 304 Durham, NC 27705 Pat Hughes Edward Weck PO Box 12600 RTP, NC 27709 (919)544-8000 Charlie Lee Foresight 2005 Marion's Ford Chapel Hill, NC 27516 (919)968-1984 Bob Vaughn Vaughn Software Services PO Box 1086 Apex, NC 27502 (919)362-0432 Rankings Page No. 1 Average 3 Order (high and low dropped) 01/12/91 Team# Company, Name S1 S2 S3 S4 S5 Ave_3 Ave_5 R-3 R-5 -------- ------------------------------ ----- ----- ----- ----- ----- ------- ------- --- --- 01 Belsoft, Inc., Table 01 79.0 77.5 79.5 80.0 79.0 79.167 79.000 1 1 09 Macon Systems, Table 09 81.5 74.5 83.5 76.5 75.0 77.667 78.200 2 2 03 Relational Analysis and SQC, 79.5 76.0 77.5 76.5 75.0 76.667 76.900 3 3 Inc., Table 03 10 Droege Computing Services, 69.0 71.5 68.0 69.5 68.5 69.000 69.300 4 4 Table 10 16 PC Concepts, Table 16 59.5 51.0 57.0 59.0 54.5 56.833 56.200 5 5 08 BecknerVision, Inc., Table 08 51.0 45.0 45.5 47.5 53.0 48.000 48.400 6 6 15 Droege Computing Services, 48.0 50.0 37.0 49.0 47.0 48.000 46.200 7 9 Table 15 17 AEPCO Inc., Table 17 49.0 46.0 40.0 53.0 48.0 47.667 47.200 8 8 11 Catawba Computers & 53.0 46.0 47.0 44.5 48.5 47.167 47.800 9 7 Communications, MicroKnight, Table 11 14 Carolina Group, Table 14 46.0 45.0 40.5 39.5 45.0 43.500 43.200 10 10 19 Habilitation Software, Table 42.5 53.0 34.5 39.0 38.5 40.000 41.500 11 11 19 13 Knowledge Modeling 43.5 14.0 30.0 46.5 10.0 29.167 28.800 12 13 Corporation, Table 13 07 Elledge & Associates, Table 07 26.0 34.0 44.5 23.5 25.0 28.333 30.600 13 12 02 Weathersby Dull Bostian & 21.5 31.5 27.0 19.0 37.5 26.667 27.300 14 14 Waynick (ITI), Table 02 12 N.C. State University, Table 26.5 21.0 26.0 28.0 27.0 26.500 25.700 15 15 12 06 Computer Ease, Bits n' Bytes 9.0 11.0 15.0 16.0 13.5 13.167 12.900 16 16 Computers, Table 06 05 Foresight, Table 05 11.0 7.0 6.5 4.5 0.0 6.000 5.800 17 17 Page No. 1 Average 5 Order (all scores averaged) 01/12/91 Team# Company, Name S1 S2 S3 S4 S5 Ave_3 Ave_5 R-3 R-5 -------- ------------------------------ ----- ----- ----- ----- ----- ------- ------- --- --- 01 Belsoft, Inc., Table 01 79.0 77.5 79.5 80.0 79.0 79.167 79.000 1 1 09 Macon Systems, Table 09 81.5 74.5 83.5 76.5 75.0 77.667 78.200 2 2 03 Relational Analysis and SQC, 79.5 76.0 77.5 76.5 75.0 76.667 76.900 3 3 Inc., Table 03 10 Droege Computing Services, 69.0 71.5 68.0 69.5 68.5 69.000 69.300 4 4 Table 10 16 PC Concepts, Table 16 59.5 51.0 57.0 59.0 54.5 56.833 56.200 5 5 08 BecknerVision, Inc., Table 08 51.0 45.0 45.5 47.5 53.0 48.000 48.400 6 6 11 Catawba Computers & 53.0 46.0 47.0 44.5 48.5 47.167 47.800 9 7 Communications, MicroKnight, Table 11 17 AEPCO Inc., Table 17 49.0 46.0 40.0 53.0 48.0 47.667 47.200 8 8 15 Droege Computing Services, 48.0 50.0 37.0 49.0 47.0 48.000 46.200 7 9 Table 15 14 Carolina Group, Table 14 46.0 45.0 40.5 39.5 45.0 43.500 43.200 10 10 19 Habilitation Software, Table 42.5 53.0 34.5 39.0 38.5 40.000 41.500 11 11 19 07 Elledge & Associates, Table 07 26.0 34.0 44.5 23.5 25.0 28.333 30.600 13 12 13 Knowledge Modeling 43.5 14.0 30.0 46.5 10.0 29.167 28.800 12 13 Corporation, Table 13 02 Weathersby Dull Bostian & 21.5 31.5 27.0 19.0 37.5 26.667 27.300 14 14 Waynick (ITI), Table 02 12 N.C. State University, Table 26.5 21.0 26.0 28.0 27.0 26.500 25.700 15 15 12 06 Computer Ease, Bits n' Bytes 9.0 11.0 15.0 16.0 13.5 13.167 12.900 16 16 Computers, Table 06 05 Foresight, Table 05 11.0 7.0 6.5 4.5 0.0 6.000 5.800 17 17 Page No. 1 Low Judges (judge is listed when they were the low judge in the group) 01/12/91 Team# S1 S2 S3 S4 S5 Ave_3 Ave_5 Rank-3 Rank-5 Check? -------- ----- ----- ----- ----- ----- ------- ------- ------ ------ ------ ** 1 16 59.5 51.0 57.0 59.0 54.5 56.833 56.200 5 5 06 9.0 11.0 15.0 16.0 13.5 13.167 12.900 16 16 ** 2 13 43.5 14.0 30.0 46.5 10.0 29.167 28.800 12 13 15 48.0 50.0 37.0 49.0 47.0 48.000 46.200 7 9 1.80 02 21.5 31.5 27.0 19.0 37.5 26.667 27.300 14 14 ** 5 11 53.0 46.0 47.0 44.5 48.5 47.167 47.800 9 7 0.63 ** 7 09 81.5 74.5 83.5 76.5 75.0 77.667 78.200 2 2 ** 12 05 11.0 7.0 6.5 4.5 0.0 6.000 5.800 17 17 03 79.5 76.0 77.5 76.5 75.0 76.667 76.900 3 3 ** 13 08 51.0 45.0 45.5 47.5 53.0 48.000 48.400 6 6 10 69.0 71.5 68.0 69.5 68.5 69.000 69.300 4 4 ** 14 19 42.5 53.0 34.5 39.0 38.5 40.000 41.500 11 11 ** 15 07 26.0 34.0 44.5 23.5 25.0 28.333 30.600 13 12 ** 20 17 49.0 46.0 40.0 53.0 48.0 47.667 47.200 8 8 ** 22 14 46.0 45.0 40.5 39.5 45.0 43.500 43.200 10 10 01 79.0 77.5 79.5 80.0 79.0 79.167 79.000 1 1 ** 25 12 26.5 21.0 26.0 28.0 27.0 26.500 25.700 15 15 Page No. 1 High Judges 01/12/91 Team# S1 S2 S3 S4 S5 Ave_3 Ave_5 Rank-3 Rank-5 Check? -------- ----- ----- ----- ----- ----- ------- ------- ------ ------ ------ ** 1 10 69.0 71.5 68.0 69.5 68.5 69.000 69.300 4 4 ** 3 01 79.0 77.5 79.5 80.0 79.0 79.167 79.000 1 1 ** 4 19 42.5 53.0 34.5 39.0 38.5 40.000 41.500 11 11 ** 6 06 9.0 11.0 15.0 16.0 13.5 13.167 12.900 16 16 ** 8 08 51.0 45.0 45.5 47.5 53.0 48.000 48.400 6 6 ** 11 16 59.5 51.0 57.0 59.0 54.5 56.833 56.200 5 5 09 81.5 74.5 83.5 76.5 75.0 77.667 78.200 2 2 ** 13 12 26.5 21.0 26.0 28.0 27.0 26.500 25.700 15 15 03 79.5 76.0 77.5 76.5 75.0 76.667 76.900 3 3 ** 14 02 21.5 31.5 27.0 19.0 37.5 26.667 27.300 14 14 ** 16 14 46.0 45.0 40.5 39.5 45.0 43.500 43.200 10 10 13 43.5 14.0 30.0 46.5 10.0 29.167 28.800 12 13 ** 17 15 48.0 50.0 37.0 49.0 47.0 48.000 46.200 7 9 1.80 07 26.0 34.0 44.5 23.5 25.0 28.333 30.600 13 12 ** 19 05 11.0 7.0 6.5 4.5 0.0 6.000 5.800 17 17 ** 22 11 53.0 46.0 47.0 44.5 48.5 47.167 47.800 9 7 0.63 ** 25 17 49.0 46.0 40.0 53.0 48.0 47.667 47.200 8 8 Developer's Competition System Tool Summary Tool Number ---------------------------------------- ------ 4TH DIMENSION 1 ADV DBMASTER 4.1 1 APPLETALK 1 BASIC 1 BLINKER 8 BRIEF 4 C 4 CLIPPER 4.0 1 CLIPPER 5.0 1 CLIPPER S'87 10 DESQVIEW 2 DOS 2 ETHERNET 1 FOXBASE 2 FUNCKY 3 GETIT 3 GRUMPFISH 1 LANTASTIC 3 MSLINK 1 MULTIEDIT 2 MULTIFINDER 1 NETBIOS 1 NETLIB 3 NOVELL 8 OMNIS5 1 ORACLE 1 OVERLAY 1 PCONCEPT 1 PLINK86 1 QB 2.0 1 QB3 1 QEDIT 5 RTLINK 1 SIDEKICK+ 1 SPF-PC 1 TLINK 2 VERNSIX 1 WINDOWS 3 WORDSTAR 1 Installation Instructions for installing the top 6 systems. 1 - Belsoft - Mike Beall, M. G. Kademani - (804)233-5471 1. Create a new directory on your hard disk. C:\> Type MD \ TEAM1 [Enter] C:\> Type CD \ TEAM1 [Enter] 2. Copy the program to your hard disk. C:\TEAM1> Type A:TEAM1 [Enter] The software will unbundle. The files will explode and unshrink. 3. Start the program. C:\TEAM1> Type ABUSE [Enter] Login as GUEST Password is GUEST 2 - Macon Systems - Kieron Hardy - (719)520-1555 1. Create a new directory on your hard disk. C:\> Type MD \ TEAM2 [Enter] C:\> Type CD \ TEAM2 [Enter] 2. Copy the program to your hard disk. C:\TEAM2> Type A:TEAM2 [Enter] The software will unbundle. The files will explode and unshrink. 3. Start the program. C:\TEAM2> If you have a color monitor, TYPE copy ncdc-c.ini ncdc.ini C:\TEAM2> Type NCDC [Enter] This program is limited to 35 records. 3 - Relational Analysis - Sam Youngman, Stan Quick - (301)565-8860 Need Oracle to run the system. To purchase Oracle, call Keith LeClaire at 415-595-0720 Ext: 346. Price for PC: $649. 1. Create a new directory on your hard disk. C:\> Type MD \ TEAM3 [Enter] C:\> Type CD \ TEAM3 [Enter] 2. Copy the program to your hard disk. C:\TEAM3> Type A:TEAM3 [Enter] The software will unbundle. The files will explode and unshrink. 4 - Droege Computing Services - Hoornaz Kuklan, Jimmy Lucas - (919)383-9749 1. Create a new directory on your hard disk. C:\> Type MD \ TEAM4 [Enter] C:\> Type CD \ TEAM4 [Enter] 2. Copy the program to your hard disk. C:\TEAM4> Type A:TEAM4 [Enter] The software will unbundle. The files will explode and unshrink. 3. Start the program. C:\TEAM4> Type CPS [Enter] 5 - PC Concepts - Michael Smith, Michael Stewart - (201)613-1777 1. Create a new directory on your hard disk. C:\> Type MD \ TEAM5 [Enter] C:\> Type CD \ TEAM5 [Enter] 2. Copy the program to your hard disk. C:\TEAM5> Type A:TEAM5 [Enter] The software will unbundle. The files will explode and unshrink. 3. Start the program. C:\TEAM5> Type ABUSE [Enter] If you get this message: invalid clipper setting. You need to make sure your clipper setting is: V setting: Minimum 10 / Maximum 17 R setting: Minimum 16 / Maximum 35 F setting: Minimum 29 6 - Beckner Vision - John Beckner - (919)739-0170 Waiting for complete version 1. Create a new directory on your hard disk. C:\> Type MD \ TEAM6 [Enter] C:\> Type CD \ TEAM6 [Enter] 2. Copy the program to your hard disk. C:\TEAM6> Type A:TEAM6 [Enter] The software will unbundle. The files will explode and unshrink. 3. Start the program. C:\TEAM6> Type CPT [Enter] For Password [Enter] Evaluation Results 1. Please comment on the idea of a developer's competition in general. How can the concept be used more effectively? "A brilliant win/win concept" "I was originally a skeptic, but Tom devoted the considerable resources needed to pull it off." "Too many subjective judging criteria." "The rule about completed applications was too vague, and should be eliminated if it cannot be clarified. If the spec is sufficient, the chances of unfair advantage is small." "The competition is a great idea and seemed to be a great success. The competition would have been more effective if its specifications had been more generic. A lot of the terms and requirements were more "Clipper" oriented than a database application specification should be. For instance, "Execute CHKDSK" is not particularly useful on a MacIntosh. If this is a Clipper-only competition, then such requirements are fair. Otherwise, it detracts from the main purpose of the competition." "Not possible - it was perfect." "Great idea. Could be done more often or in various cities. Need some way to limit use of libraries so competitors are on more even level." "State wide advertising." "I think the idea is excellent but it appeared that the programers could have had more complete results if they had more time, (maybe a full day instead of 6 hrs). "A wonderful way to network, advertise, develop skills and encouragement for more knowledge." "It was already used most effectively. There should be an exhibitors hall, and more companies should be encouraged to participate as exhibitors. *One note: All competitors should receive a certificate of competition, suitable for framing for our walls. And it's good advertising for the next event." "I thought the idea was great. I believe the competition should be more user oriented in the future though. An application that has the ability to perform a function does not necessarily mean "ease of use" for the end user. Since the application is going to be used by the submitting firm, it should perform the required functions gracefully. I saw too many "features" that would require extensive training in order for the average office employee to make use of them. I realize that the amount of time limits what the developer can do, but I think we owe it to the submitting firm to make the application easy to use. Perhaps end users should be used in the application judging process." "I'm not sure if I get the point. Was it to sell one's ideas to others? Not much sharing and discussing of methods went on. Having said that, it was fun and useful." 2. What is your opinion of the application program example (Child Protection System) used in the competition? What should have been done differently? "The choice of application could not have been better." "A few minor quibbles - some of the fields in the client table were probably more appropriate for placement in the abuse (transaction) table. But system specs were both appropriate and meaningful." "Nice to have a meaningful application. Task was sized perfectly for the 6 hour time frame." "The application was the perfect size and mix (reports, data loading, data entry screens). It was useful, interesting and non-trivial. I enjoyed the pressure of trying to compete it in the allowed time." "Possibly could have added a graph. Other than that, it was great." "More points should be given to user interface, content, etc., and less points to reports. Program example used was good." "Being a member of the CPT, I greatly appreciated the selection of the CPT program application." "Appropriate application-very thorough and complex. Perhaps redo the percentages for judging-see below reports." "Of course I am biased but I thought the problem of developing a data base for this clinical problem was very important and very interesting." "The application could not have been better. I only wonder who can benefit from next years' application as appropriately as the CPT this year." "The selection application was an admirable choice. I think it would be a good idea to use the competition to help non- profit organizations and charities develop software for their needs at an affordable cost." "Good example. Nice to have a real world example. More background (written by client) would have been really useful." 3. What are your views on the judging procedure? How can it be improved? "Very professional and well thought out." "Appeared to go O.K. - except for the time crunch. A second version of judging should be developed for the next competition, and CARE given to whether all judging criteria can be addressed within existing time limits." "20 minutes was too short. Maybe more teams of 3 could have been used." "20 minutes was not enough time for judging (30 perhaps?). Maybe try using 3 judges for the first round of judging so you would only need 2 phases of judging instead of 3. Make the evaluation even more objective." "This was obviously the toughest part. I guess the only thing I can think of is to make it more regimented, as far as "You must demo the program and show each function in an incredibly specific order." "The judges could act more professionally. I received very negative comments about the Macintosh from a judge prior to his review of my program. This showed a clear negative bias and was not professional." "As a computer illiterate, it would help the competitors to present their programs according to the order of the categories on the form." "40% seemed too high for reports. Also, some competitors were not completely sure on what they needed to do for the presentation. Clarify that it is the developer's role to explain their system to the judges. Also advise developers to closely review the judging criteria." "A stricter format for the competitors would have been helpful so that all the judges could be sure each point had been addressed." "The judges themselves were good overall. Only one complaint. Perhaps only one judge should be a programmer, as a judge- consultant to other judges on the team. The winning team this year was able to show ad-hoc query answers by use of a dot- prompt. Very UN-user friendly." "The judging procedures were fair, but time consuming. If their were any more teams involved, it would have taken all night to finish the judging. For the size of application, I believe too much time was given on the second round of judging. If the number of judges was limited to 3 or 4, more applications could be judged simultaneously. Next year, if there is a competition, you can be sure that more developers will be involved." "Need to have a more definite set of guidelines as to what client needed." 4. The OMNI Hotel was used as the site of the 1991 competition. What are your comments on this selection? "Well organized, good value." "Excellent. Staff very responsive & food was excellent." "Perfect." "It was O.K. for the competition since I drove from Raleigh. However, I can't comment on the price of rooms since I didn't stay there." "Great food, excellent facilities-use it for 1992!" "Excellent" "Would prefer to see more exhibitors placed in exhibit halls for electrical needs. I think that the set-up worked well. Breakfast, lunch, etc." "Do it again! Only problem was the laying of power cables. Maybe we can do something about that next time." "Hotel was OK. Banquet facilities would have been better if we hadn't been rushed out and frozen." 5. Do you have any other comments or suggestions? "Do it again, and make it a bigger and even better event." "Let's do it again." "Have award money available at awards banquet. Present wall plaques to winners as well." "Ease of learning/use should count for more of the total. Getting ready for '92 - hope it happens. Thanks!!" "Could use better review of specs, test data, and evaluation criteria before the competition to reduce the interruptions during the competition. Pay the awards at the awards dinner to the individuals. Reduce time spent awarding "product", and reduce number of people awarded "product". Need to strictly enforce the rule that everyone must stay away from the computer when time is up except when being judged." "You had better have another one next year!" "Appreciated the round robin prize selection at the end. This gave all developers a chance at good products. The winners get money, anyway, they should not complain." "It was a very enjoyable experience." "Continue the competition." "A very interesting competition. The possible types of applications programs are wide and varied. I hope the idea flourishes." "If we purchase proceedings, can we get the judge's form where the applications were graded? I would like to see aggregate scoring as well as individual scoring (leave off the scorers' name, but show their category). If we cannot get this in the package, Is it available to individual competitors? Irregardless of this availability, I enclose my $50 check for the proceedings." "I was really surprised by the amount of software donated by the vendor. Droege Computing Services did an excellent job in organizing the competition. Many thanks to Tom Droege for his time and effort." "Looking forward to next year!"