I do not us invoice numbers but transaction numbers for which I create a
unique number based on:
set var vinv text = ('userid'+(format(.#now,'yymmddhhnnss')
I like this approach because it tells me alot of information just from the
number ie who did it and when
Tom Hart
________________________________
From: Mike Byerley <[email protected]>
To: RBASE-L Mailing List <[email protected]>
Sent: Tuesday, June 25, 2013 5:11 PM
Subject: [RBASE-L] - Re: Assigning Invoice Numbers
That's what I do, except I put the GET number in a separate table and use a
Stored Procedure to procure the NEXT number. It keeps the table with a lot
of data in it simpler and the table that has the NEXT numbers in it has
multiple columns but only one row.
----- Original Message -----
From: "Dan Goldberg" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Tuesday, June 25, 2013 4:33 PM
Subject: [RBASE-L] - Re: Assigning Invoice Numbers
:I just use the next function with autonum on the column. It will grab and
: increment the next number.
:
:
: From Help:
:
: (NEXT(tblname,autonumcol))
: Returns the next value of an autonumbered column.
:
: Where colname is an autonumbered column in tblname NEXT returns, and
: increments, the value of the next available autonumber. You cannot use
this
: function with INSERT, but you can use it with LOAD;NONUM. For example:
: Assume that you have autonumbered the column EmployeeID in the table
: Employees. The highest number currently used in the database is 134. In
this
: case, in the following example, the value of vNextOne will be 135 and the
: value of vNextTwo will be 136.
:
: Notice that the value has incremented even though no other commands or
: functions were issued.
:
: SET VAR vNextOne = (NEXT(Employees,EmployeeID))
:
: SET VAR vNextTwo = (NEXT(Employees,EmployeeID))
:
: Dan
:
:
: -----Original Message-----
: From: Les Stark
: Sent: Tuesday, June 25, 2013 10:32 AM
: To: RBASE-L Mailing List
: Subject: [RBASE-L] - Assigning Invoice Numbers
:
: I am having a problem with duplicate invoice numbers.
: I have a table INVNUM with a column INVNBR that holds an integer
: value for the invoice number.
: When I create a new invoice, SET VAR VINV#=INVNBR IN INVNUM to get
: the last invoice number from the table
: then I increment that number SET VAR VINV#=(.VINVNBR +
: 1) the incremented number is used for the current invoice
: then I update the table UPDATE INVNUM SET INVNBR=.VINV#
:
: The table is ready for the next new invoice and the current invoice
: is written with the value of VINV#
: This is a multiple user database and is using Row Locks, Column Verify
: on the tables
: How am I getting duplicate invoice numbers?
: Is there a better way to assign Invoice Numbers?
:
:
: --
:
:
