Connectivity Manual - 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 >
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: |
18.326.604 |
| Assortment: |
Exact Financials
|
Date: |
05-12-2008 |
| Release: |
|
Attachment: |
|
| Disclaimer |