__________________________________________________________________________ | Action foRm Block Field Trigger Procedure Image Help Option | | ########################## Field Definition ##################### | | ------------------------------------------------------------------ | | | Field Name: |DEPTNO.....................| | | | Sequence Number: 1 Data Type: NUMER Select Attributes | | | | Field Length: 4 Query Length: 4 Display Length: 4 | | | | Screen Position: X: 20 Y: 4 Page: 3 | | | | Format Mask: | | | | Default Value: | | | | Hint: Enter value for : DEPTNO | | | | Valid Range: Low: High: | | | | Enforce Key From: | | | | List of Values: Title: Pos: X: Y: | | | |-----------------------------------------------------------------| | | | -------- List of Values SQL Text -------- | | | | | | | | | | | |-----------------------------------------------------------------| | | | ---------------- Comment ------------------- | | | | | | | | | | | ------------------------------------------------------------------ | | Enter the field name. | | Frm: dept_emp Blk: dept2 Fld: DEPTNO Trg: Rep | |__________________________________________________________________________|
_________________________________________________________________________ | | | ------------------ Block Definition --------------------- | | ______________________________________________________________________ | | |_| | | Seq | Records | Records | Records | A| | | | | Block Name | Base Table | Num | Disp | Buff | Lines | | | | | |-------------------------------------------------------------------| | | | | DEPT | dept | 1 | 1 | | 1 | | | | | | EMP | emp | 2 | .5.. | | 1 | | | | | | SG | salgrade | 3 | 5 | | | | | | | | | | | | | | | | | | | | | | | | | | | | |_| | | | | | | | | | | | | | | | | | | | | |_|_____________|______________|_____|_________|_________|____________| | | |_|_________________________________________________________________|> | | | | |_________________________________________________________________________| _________________________________________________________________________ | | | ------------------ Block Definition --------------------- | | ________________________________________________________________________| | |_| | Array | Primary | In | Columns | Menu | A| | | | | Block Name | Size | Key | Menu | Sec | Description| | | | | |------------|---------|----------|-------|---------|------------|--| | | | | DEPT | ..... | [ ] | [ X ] | [ ] | Depart inf | | | | | | EMP | | [ ] | [ X ] | [ ] | Empl Detail | | | | | | SG | | [ ] | [ X ] | [ ] | Grad by Sal | | | | | | | | | | | | | | | | | | | | | | | | | | |_| | | | | | | | | | | | | | | | | | | | | |_|____________|_________|__________|_______|_________|____________| | | | |<|__________________________________________________________________|> | | | | |_________________________________________________________________________|
__________________________________________________________________________ | Action foRm Block Field Trigger Procedure Image Help Option | | ########################## Form Definition ##################### | | ------------------------------------------------------------------ | | | Title: dept_emp | | | | Validation Unit: | | | | Mouse Navigation Limit: | | | | Default Menu Application: default | | | | Starting Menu Name | | | | Manu Security Group Name | | | |------------------------------------------------------------------| | | | ---------------- Comment ------------------- | | | | ........................................................... | | | | ........................................................... | | | | ........................................................... | | | | ........................................................... | | | | ........................................................... | | | | | | | -------------------------------------------------------------------- | | Enter any comment for the form. | | Frm: dept_emp Blk: dept2 Fld: DEPTNO Trg: Rep | |_________________________________________________________________________ |
---------------------------------------------------------------------- | Search | | | | Search for: | | _____________________________________________ | | | | | | --------------------------------------------- | | Replace with: | | | | [ ] Backward [ ] Replace | ----------------------------------------------------------------------
__________________________________________________________________________ | Action foRm Block Field Trigger Procedure Image Help Option | | ########################## Block Definition ##################### | | ------------------------------------------------------------------ | | | Block: DEPT | -- Records --| Array Size | | | | Table: dept | Displayed: 1 | [ ] Prim Key | | | | Sequence Number: 1 | Buffered: | [ X ] In Menu | | | | | Lines per: | [ ] Column Sec | | | |-----------------------------------------------------------------| | | | Description: Department Information | | | |-----------------------------------------------------------------| | | | --------- -Default Where/Order By ----------- | | | | | | | | | | | | | | | |-----------------------------------------------------------------| | | | ---------------- Comment ------------------- | | | | | | | | | | | ------------------------------------------------------------------ | | Enter the number of records to dispaly in the block. | | Frm: dept_emp Blk: dept2 Fld: Trg: Ins | |_________________________________________________________________________ |
GRANT SELECT, UPDATE (LOC) ON DEPT TO CRANE;Cand Crane ruleaza formatul DEPT_EMP, ea poate actualiza campul LOC, dar primeste mesajul
Field protected against updatecand incearca sa oricare alt camp din blocul DEPT.
__________________________________________________________________________ | Action foRm Block Field Trigger Procedure Image Help Option | | ########################## Block Definition ##################### | | ------------------------------------------------------------------ | | | Block: EMP | -- Records --| Array Size | | | | Table: emp | Displayed: 5 | [ ] Prim Key | | | | Sequence Number: 2 | Buffered: | [ X ] In Menu | | | | | Lines per: 1 | [ ] Column Sec | | | |-----------------------------------------------------------------| | | | Description: Department Information | | | |-----------------------------------------------------------------| | | | --------- -Default Where/Order By ----------- | | | | WHERE JOB = 'PRESIDENT' | | | | AND EXISTS / SELECT DEPTNO FROM DEPT | | | | WHERE DEPTNO = EMP.DEPTNO | | | | ORDER BY EMPNO | | | |-----------------------------------------------------------------| | | | ---------------- Comment ------------------- | | | | | | | | | | | ------------------------------------------------------------------ | | Enter the deafult where and order by clauses for queries in this block | | Frm: personnel Blk: EMP Fld: Trg: Ins | |_________________________________________________________________________ |
Obs: Daca sunt prezente si clauze Where si clauze Order By, clauza
Where are prioritate.
------------------------------------------------------------ | ------------- Default Where/Order By ------------- | | EMPNO | | | |____________________________________________________________|
---------------------------------------------------------------------- | | | SWEENEY TODD'S BEANSPROUT FACTORY | | --DEPAR --------------------------------------------------------- | | | Dept. No:| Sweeney Todd's Beansprout Factory | | | | | | Find: ........ | | | | ---------------------------------------------------|---------------| | | | 1 Department Information | | | -E M P L O |-| 2 Employee Details |------------- | | | ID Sur | | 3 Grades by Salary Range |ission Gr. | | | | 7782 CLA| | | | | | | 7839 KIM| | | | | | | 7934 MIL| | | | | | | |-| | | | | | | | | | | | ----------------------------------------------------------------- | | | | | ----------------------------------------------------------------------
4. __________________________________________________________________________ | Action foRm Block Field Trigger Procedure Image Help Option | | ########################## Block Definition ##################### | | ------------------------------------------------------------------ | | | Block: ORD | -- Records --| Array Size: 10 | | | | Table: ord | Displayed: 1 | [ ] Prim Key | | | | Sequence Number: 1 | Buffered: 20 | [ X ] In Menu | | | | | Lines per: | [ ] Column Sec | | | |-----------------------------------------------------------------| | | | Description: Order Summary Information | | | |-----------------------------------------------------------------| | | | --------- -Default Where/Order By ----------- | | | | order by orderdate, ordid | | | | | | | | | | | |-----------------------------------------------------------------| | | | ---------------- Comment ------------------- | | | | | | | | | | | ------------------------------------------------------------------ | | | |_________________________________________________________________________ | 5,6 __________________________________________________________________________ | Action foRm Block Field Trigger Procedure Image Help Option | | ########################## Block Definition ##################### | | ------------------------------------------------------------------ | | | Block: ITEM | -- Records --| Array Size: 10 | | | | Table: item | Displayed: 4 | [ ] Prim Key | | | | Sequence Number: 2 | Buffered: 20 | [ X ] In Menu | | | | | Lines per: 1 | [ ] Column Sec | | | |-----------------------------------------------------------------| | | | Description: Item details for an order | | | |-----------------------------------------------------------------| | | | --------- -Default Where/Order By ----------- | | | | itemid | | | | | | | | | | | |-----------------------------------------------------------------| | | | ---------------- Comment ------------------- | | | | | | | | | | | ------------------------------------------------------------------- | | | |_________________________________________________________________________ |