Posted by Grant Foraker on October 24, 2005 at 14:30:32:
In Reply to: Sub Keys are NOT unique posted by Jim Guerber on October 23, 2005 at 09:36:54:
If Comet can't resolve the unique key problem. Then, back to my earlier post, we can make sub keys as complicated as we want by defining them ourselves. Probably have to expand the record length.
0311 FORMAT_
CNBR$;_
CNAME$;_
CADDR1$;_
CADR2$;_
CSTATE$;_
CZIP$;_
etc.
sub key to sort by name @500 FOR 30
@(500);CNAME$;_
CNBR$
sub key to sort by ZIP @530 FOR 15
@(530);CZIP$;_
CNBR$
sub key to sort by city @545 for 15
@(545);CCITY$;_
CCNBR$
Uses more record space and repeats the data fields. Disk space is cheap and we're going to have to do a file copy anyway.