Re: 4D Field Incrementing

Thread View: comp.sys.mac.databases

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Matthew Mashyna Tue, 26 Jan 1993 17:05

#671

Author: Matthew Mashyna
Date: Tue, 26 Jan 1993 17:05

10 lines
871 bytes

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.


Matt

Re: 4D Field Incrementing

#674

Author: Mike Hennahane
Date: Wed, 27 Jan 1993 00:39

17 lines
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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads