1
Download Unify DataServer/ELS Reference
Transcript
Compile screens (sfproc) 321 Restore screen to Data Dictionary (sfrestr) 322 Part V: Data entry and retrieval 323 Chapter 15: ENTER–data entry query by forms The Rules of Using ENTER 325 326 Register screen form with ENTER (entmnt) 329 Using ENTER for data entry 335 Entering the primary key field 335 Moving the cursor on the ENTER screen Adding or changing field data 336 335 Entering data in a text type field 336 Enter data in a binary type field 337 Changing data in a secondary table 337 Using ENTER with advanced field attributes (AFA) 338 Adding and modifying records with AFA 338 ENTER and AFA messages 339 Using ENTER for query by forms 340 Inexact matching on string fields 341 Inexact matching on non-string fields 342 Using queries to modify, delete, or report 343 Enter report options screen 344 Chapter 16: SQL-Query/DML language 349 Query facilities 351 Required and optional clauses 351 Identifying tables and fields in queries 352 Entering query statements 352 Help features 353 select...from CLAUSE 355 where CLAUSE 358 unique KEYWORD 366 Arithmetic expressions 367 Aggregate functions 369 order by CLAUSE 371 group by CLAUSE 372 Nested queries 375 Contents 7
