[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference iosg::all-in-1

Title:ALL-IN-1 (tm) Support Conference
Notice:Please spell ALL-IN-1 correctly - all CAPITALS!
Moderator:IOSG::PYECE
Created:Fri Jul 01 1994
Last Modified:Fri Jun 06 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:2716
Total number of notes:12169

2571.0. "Duplicate DOCNUM?" by ALFSS2::BEKELE_D (When indoubt THINK!) Thu Mar 13 1997 18:30

    This has to be a rare incident, if at all, but has anyone
    figured the circumstances under which a duplicate DOCNUM
    gets created in the same drawer?
    
    Thanks!
    
    Dan
T.RTitleUserPersonal
Name		DateLines
2571.1Same drawer but not the same folderSHRMSG::HOWARDWhoever it takesThu Mar 13 1997 23:0413
    If you cross file, the same document number exists twice. Could there
    be more than one person/application using the file cabinet at the same
    time?  I've never seen it, but ALL-IN-1 just checks for the last
    document number, adds one, and uses that.  It doesn't go back and use
    old numbers which have been deleted (doesn't this sound familiar?).  I
    once deleted most of the documents from an account every day, and the
    same numbers got reused over and over.  So if both users checked at the
    same time, but created documents in different folders, I would think
    there would be two of the same number.  I don't think DOCNUM is a
    unique key. It is DOCNUM and FOLDER which are unique together.
    
    Ben
2571.2IOSG::MARSHALLFri Mar 14 1997 17:047
>> I don't think DOCNUM is a
>> unique key. It is DOCNUM and FOLDER which are unique together.

As an aside, DOCNUM isn't really a key at all; it's a pseudo-key that gets
mapped to the real key field, called FIXER.

Scott