From: hillmw@ram.lmtas.lmco.com   
      
   So, I am at a lost at how a cache size of 20 was causing my numbers to   
   increment by 20, and then changing it   
   to 0 is incrementing my numbers correctly.   
      
   >   
   >   
   > By the way the cache size is how many numbers are stored in memory so   
   > that an IO to disk does not have to be done until the cache is   
   > exhausted (or flushed).  The increment is what determines the number   
   > by which the sequence values vary from each other.   
   >   
   > And Ed will probably tell you this but the alter table command   
   > includes an option to enable/disable constraints.  See the SQL manual.   
   >  This explnation should be in the Concepts manual section on   
   > constraints.   
   >   
   > HTH -- Mark D Powell --   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)