Article View: comp.sys.mac.databases
Article #674Re: 4D Field Incrementing
From: Mike Hennahane
Date: Wed, 27 Jan 1993 00:39
Date: Wed, 27 Jan 1993 00:39
17 lines
1285 bytes
1285 bytes
Matthew Mashyna <mm5l+@andrew.cmu.edu> writes: >I'm not sure I fully understand what your trying to do. If you only need >to assign a unique number to you clients starting with 1000 then why not >use something like: >[Clients]Client_Num:= sequence number([Clients]) + 1000 >The sequence number is always unique -- until it wraps bitwise. but what if you are doing, say, invoice numbers and you don't want gaps for invoices that are created but not saved? (like a creation loop where the last one is cancelled to end the loop). it is a good idea to have the flexibility to check what the next number is without incrementing it (or to have the flexibility to reset the next number). --mike
Technical Details
Message-ID:
<michaelh.728095157@Xenon.Stanford.EDU>Path:
arc1-ca.pugleaf.net!sparky!uunet!pageworks.com!world!eff!sol.ctr.columbia.edu!usc!howland.reston.ans.net!spool.mu.edu!agate!stanford.edu!CSD-NewsHost.Stanford.EDU!Xenon.Stanford.EDU!michaelhReferences:
<IfNKxZ_00YVXQ1muNy@andrew.cmu.edu>Show Full Headers
Complete Article Headers
Newsgroups: comp.sys.mac.databases Path: arc1-ca.pugleaf.net!sparky!uunet!pageworks.com!world!eff!sol.ctr.columbia.edu!usc!howland.reston.ans.net!spool.mu.edu!agate!stanford.edu!CSD-NewsHost.Stanford.EDU!Xenon.Stanford.EDU!michaelh From: michaelh@Xenon.Stanford.EDU (Mike Hennahane) Subject: Re: 4D Field Incrementing Message-ID: <michaelh.728095157@Xenon.Stanford.EDU> Sender: news@CSD-NewsHost.Stanford.EDU Organization: CS Department, Stanford University, California, USA References: <IfNKxZ_00YVXQ1muNy@andrew.cmu.edu> Distribution: usa Date: 27 Jan 93 00:39:17 GMT Lines: 17