Is PST.ROOM.ASSIGNMENTS dict item defined as MV (Multivalue) or SV (Single Valued) item?
I would expect this if it was defined as SV (Single Valued) but really MV in it. -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 1690 S Congress Avenue, Suite 210 Delray Beach, FL 33445 USA Voice Phone: 561.454.3592 Fax Phone: 561.454.3640 >>> [EMAIL PROTECTED] 3:26:54 PM 08/23/2004 >>> Hi all, Not a regular here but I was hoping someone could enlighten me with this interesting 'feature' of UNIDATA... If I issue a select statement using saving unique on a mv field of pointers, then edit the SAVEDLISTS file to check the IDs, I see something like this... SELECT PERSON.ST 3152749 SAVING UNIQUE PST.ROOM.ASSIGNMENTS SAVE.LIST X.1 AE SAVEDLISTS X.1000 001: 8654y1y1 002: 9490y2y1 003: 9491y3y1 (where 'y' is the value marker) Why is there y1y1, y2y1, y3y1 appended at the end of each ID? I'm guessing it has to do with the saving unique feature or something? To continue with the issue... SELECT PERSON.ST 3152750 SAVING UNIQUE PST.ROOM.ASSIGNMENTS SAVE.LIST X.2 001: 1443y1y1 002: 2904y2y1 003: 5128y3y1 004: 6743y4y1 LIST.ALGEBRA X.3 = X.1 + X.2 the system returns: SIZE OF X.1 IS 3 SIZE OF X.2 IS 4 SIZE OF X.3 IS 7 result is stored in 'X.3' GET.LIST X.3 21 records retrieved to list 0. >LIST ROOM.ASSIGNMENTS 1443 2904 5128 6743 4 8654 9490 9491 8 records listed Enter <CR> to print non exist record ids 1 1 2 1 3 1 1 1 1 2 1 3 The LIST.ALGEBRA isn't ignoring what comes after the IDs and creates a savedlists with every value delimited by the value marker. I was expecting a total of 7 records (as indicated by LIST.ALGEBRA), when I do the GET.LIST X.3 there are 21 records. So first, what is the extraneous information at the end of each ID in the SAVEDLISTS? If I use a BSELECT instead I do not get this extra info. I am merely seeking more information with this whole thing... I was unaware that 'extra' information is stored when doing a SAVING UNIQUE and that using savedlists created with SAVING UNIQUE within LIST.ALGEBRA causes problems... or am I doing something wrong? I haven't found any documentation that denotes the above mentionned issue. Thanks for any feedback, Phil -- Philippe Parent - [EMAIL PROTECTED] Programmer Analyst, Administrative Information Services (ITS) University of New Brunswick PO Box 4400, Fredericton, NB, Canada, E3B 5A3 Phone (506) 453 3563 - Fax (506) 453 3590 ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
