On Friday, June 25, 2021 at 3:29:11 AM UTC-7,
kilg...@gmail.com wrote:
I am at my wit's end here.
pls consider this query below.
I have asked enform to find certain records, based on the content of the field HR-ID. ENFORM is successful in retrieving the records in question, but when asked to LIST same records, there are no values.
I feel the error might be in the DDL definition of the record vs the file, but i can find no discrepancies. Any hints what can go wrong, please ?
1 * ?dictionary $xxx.yyyyyyyy
5 * ?Assign uaub1 to $xxxx.yyyyyyy.uaub
6 *
7 *
17 * open uauB1;
19 *
37 *
38 * LIST
39 * uaub1.ansnr
47 * uaub1.record-update
47.1 * uaub1.sletdato
47.2 * uaub1.hr-id
47.3 * uaub1.afdnr
48 * where
49 *
55 *
56 * uaub1.hr-id = "M015494"
57 * or uaub1.hr-id = "M014169"
57.1 * or uaub1.hr-id = "M013859"
57.2 * or uaub1.hr-id = "G54297"
57.3 * or uaub1.hr-id = "G54296"
57.4 * or uaub1.hr-id = "G53397"
58 *
59 * ;
ANSNR RECORD-UPDATE SLETDATO HR-ID AFDNR
------ ------------- -------- -------- -----
13859 19930612
14169 19930612
15494 19930612
53397 19930612
54296 19930612
54297 19930612
You mentioned that the problem might be the DDL definition of the record, but you don't show us what the DDL definition is for the record.
One thing you could do is add the command:
?show uauB1
to the lines you input to ENFORM to show what ENFORM believes the record is. Put it right before the LIST statement.
If that does not show you the cause of the problem, look at the DDL for the record. If you are sure you have the current DDL source that created the dictionary, you can look at it, though for complex dictionaries, that can be hard to figure out.
You can use DDL to show exactly what is in the dictionary now:
DDL
?dict $xxx.yyyyyyyy
?ddl your-terminal-name
output record uaub1.
?exit
That will write to your terminal what DDL understands the record to be. It might refer to other elements in the dictionary, like some DEFs, and if you aren't certain how they are declared, you can use the output command to list what they are.
If this still doesn't show you the cause of the problem, post the record information here and maybe we can spot the problem.
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)