8967_dynamic.p
| 1 |
DEFINE TEMP-TABLE customers_d |
|---|---|
| 2 |
field customer_id as INT |
| 3 |
field customer_name as character |
| 4 |
index Idxcustomer_id is unique customer_id |
| 5 |
. |
| 6 |
|
| 7 |
DEFINE TEMP-TABLE orders_d |
| 8 |
field customer_id as INT |
| 9 |
field order_amount as int |
| 10 |
|
| 11 |
. |
| 12 |
|
| 13 |
create customers_d. |
| 14 |
customers_d.customer_id = 1. |
| 15 |
customers_d.customer_name = 'John Doe'. |
| 16 |
|
| 17 |
create customers_d. |
| 18 |
customers_d.customer_id = 2. |
| 19 |
customers_d.customer_name = 'John Smith'. |
| 20 |
|
| 21 |
create orders_d. |
| 22 |
orders_d.customer_id = 1. |
| 23 |
orders_d.order_amount = 10. |
| 24 |
|
| 25 |
create orders_d. |
| 26 |
orders_d.customer_id = 1. |
| 27 |
orders_d.order_amount = 20. |
| 28 |
|
| 29 |
create orders_d. |
| 30 |
orders_d.customer_id = 2. |
| 31 |
orders_d.order_amount = 15. |
| 32 |
|
| 33 |
|
| 34 |
DEFINE VARIABLE qh AS WIDGET-HANDLE. |
| 35 |
|
| 36 |
CREATE QUERY qh. |
| 37 |
qh:add-buffer(BUFFER customers_d:HANDLE). |
| 38 |
qh:add-BUFFER(BUFFER orders_d:HANDLE). |
| 39 |
qh:QUERY-PREPARE("FOR EACH customers_d, each orders_d of customers_d WHERE orders_d.customer_id = customers_d.customer_id").
|
| 40 |
qh:QUERY-OPEN. |
| 41 |
|
| 42 |
REPEAT WITH FRAME y: |
| 43 |
qh:GET-NEXT(). |
| 44 |
IF qh:QUERY-OFF-END THEN LEAVE. |
| 45 |
display qh:GET-BUFFER-HANDLE(1):BUFFER-FIELD('customer_id'):BUFFER-VALUE.
|
| 46 |
END. |
| 47 |
|
| 48 |
qh:QUERY-CLOSE(). |
| 49 |
DELETE OBJECT qh. |