DataEase is a package for users who hate to program but want to create custom database applications. It is menu-driven yet offers many powerful features available in other systems only through programming. You can set up a system complete with custom menus and help messages. Menus can have different levels of password protection, which adds security to the system. The package allows you to create a multiple-choice list for a particular field, thereby avoiding the need to design a cryptic coding system. It features financial and scientific functions as well as transaction processing. The report writer is based on the SQL query language. This can be difficult for the novice, although prompts help to compensate for this deficiency. Reports can be designed with data-entry screens, which let you specify different criteria for a report each time it is run. A Quick Report facility will do most of the design work, allowing users to add more advanced features. A library of report templates can be stored for future use. Research DataEase More information about Dataease
SQL stands for Structured Query Language. Often referred to as Sequel for short,
SQL was developed as a query language to accessmainframe databases such as IBM's DB2. PC products that incorporate
SQL are IBM's OS/2 Extended Edition, dBASE IV, SQL Server from Ashton-Tate and Microsoft, Paradox, DataEASE (using a modified form called DQL), PC/FOCUS, and many others. PC implementations of SQL fall into, two categories. Firstly, SQL commands can be written directly by programmers and experienced users to access databases. The second implementation recognises that most PC users are not programmers and do not want to learn SQL and so provides them with their normal friendly user interface. The underlying software then writes the SQL commands directly for them, which are used to query SQL server databases. Another benefit of SQL is that it will provide a common programming language for different machine architectures, i.e. code written on an IBMmainframe can be moved to a PC with less rewriting than with conventional languages. A full implementation of SQL also contains a very critical component for creating robust transactional databases. Often referred to as ROLL RACK/COMMIT, the facility allows a transaction that was interrupted half
way through updating multiple files to be rolled back, thereby preventing damage to the data files. Many PC implementations of SQL are subsets of the ANSI standard, and some include extensions to the ANS standard. Research SQL
The Probert Encyclopaedia was designed, edited and programed by
Matt and Leela Probert
Abbreviations
Research DataEase
More information about 
