| Object: | d_testdatawindow | Size: | 5841 |
| Comment: | Test Datawindow which uses the Sybase Sample database to show update properties and XREF v3.0.0 | Last Modified: | 02/23/2006 20:21 |
| Location: | d:\PB\PBDoc\prod\example\pbdoc_example_ansi.pbl<d_testdatawindow.srd> |
| Author: | Review Date: | 25/03/2006 14:32:38 | |
| Reviewer: | Signed: |
| Columns: | 4 | Computed: | 2 |
| Retreive Definition | Comments |
"PBSELECT( VERSION(400) TABLE(NAME=~"department~" ) TABLE(NAME=~"employee~" ) COLUMN(NAME=~"department.dept_name~") COLUMN(NAME=~"employee.emp_id~") COLUMN(NAME=~"employee.emp_fname~") COLUMN(NAME=~"employee.emp_lname~") JOIN (LEFT=~"employee.dept_id~" OP =~"=~"RIGHT=~"department.dept_id~" )) " |
| Update Where Definition | Comments |
Update Where Key Columns Only |
| Update Statement Definition | Comments |
Updates use DELETE and INSERT |
| composite_sortname | Comments |
department_dept_name + employee_emp_fname |
| footer_count | Comments |
count( department_dept_name ) |