Connectivity Manual C/S - DDCENU - record number next record
DDCENU - record number next record
The table DDCENU contains the first available record_id for each application. When you create a record in the DDCDAT file you must take the record_ID from DDCENU and update the number_value field with old-record_ID + 1.
| Application
| Application
| char x(8)
| "'Relapack'", Referenced to DDCAPP.application, same as DDCDAT.application
|
| number_type
| Number type
| inte >>>>>>>>>9
| Message = 3001
Data-record =
3002
Transaction = 3003
|
| number_value
| Number value
| inte >>>>>>>>>9
| First available number value to be used to identify DDCDAT records - HOLDS THE NUMBER TO BE USED |
Use the following Progress logic, or an equivalent in
another development language, to get number and update:
| | |
|
| /* find the number to be used */
|
| FIND LAST DDCENU
|
| WHERE DDCENU.application = "RELAPACK":U
|
| AND DDCENU.number_type = 3002
|
| NO-ERROR.
|
| IF NOT AVAILABLE ddcenu THEN DO:
|
| CREATE ddcenu.
|
| ASSIGN
|
| | DDCENU.application = "Relapack":U
|
| | DDCENU.number_value = 1
|
| | DDCENU.number_type = 3002 /* 3002 is for records, 3001 is for messages, 3003 is for transactions */
|
| | .
|
| END.
|
| /* already increase the number ddcenu for other data and assign value to be used. */
|
Connectivity Manual C/S - Contents
> EDIS
> Database structure EDIS > DDCENU - record number next record
| Main Category: |
Support Product Know How |
Document Type: |
Support - On-line help |
| Category: |
On-line help files |
Security level: |
All - 0 |
| Sub category: |
Details |
Document ID: |
01.642.839 |
| Assortment: |
Exact Financials (v3)
|
Date: |
25-04-2005 |
| Release: |
|
Attachment: |
|
| Disclaimer |