I believe the SAVING UNIQUE operating on a multivalued field treats the request as a BY.EXP request...thus giving you the value marks.
You might want to try BSELECT to get just the individual keys: SELECT PERSON.ST 3152749 BSELECT PERSON.ST PST.ROOM.ASSIGNMENTS SAVE.LIST X.1 >>> [EMAIL PROTECTED] 8/23/2004 3:26:54 PM >>> 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/ Dave Rotman Director of Computer Services Cedarville University 251 N. Main Street Cedarville, OH 45314 [EMAIL PROTECTED] voice 937-766-7905 fax 937-766-8819 ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
