Re: Identity question

[Raul Jager <raul@xxxxxxxxxx>]

Something like:  SELECT max(number) +1 from table where branch =
:myBranch and point = :myPoint   ?

Will that work well when two or more processes use it?

On 5/24/19 11:50 AM, Luis Rodriguez wrote:
> ,,Raul,
>
> Wouldn't it better to create a function that receives the branch and point
> of sales ID and returns the number or string desired?
>
> Regards,
> Luis
>
>
> Sent from my Moto G phone. Please excuse my brevity.
>
> On Fri, May 24, 2019, 11:42 Raul Jager <raul@xxxxxxxxxx> wrote:
>
> > The Paraguayan version of the IRS (SET) requires that we assign
> > consecutive numbers to the documents (Bills) starting with one for each
> > branch and point of sale.
> >
> > Can I get the system to generate the numbers?  I had only seen one
> > sequence per file.
> >
> > The numbers must have this format  001-001-0000001   First tree digits
> > are the branch, second group is the point of sale and the last seven
> > digits must be generated.
> >
> > If not automatic, will a trigger be the best option?
> >
> >
> > ___________________________________________________________________________________________
> >
> > The rules (in spanish)
> >
> > a)  Los  tres  primeros  dígitos  corresponderán  al  código  del
> > establecimiento,  donde  se  expide  el documento.Este código será
> > asignado por la Administración Tributaria;
> >
> > b) Separado por un guion, los siguientes tres dígitos corresponderán al
> > código asignado por el contribuyente a cada punto de expedición dentro
> > de un mismo establecimiento; y
> >
> > c) Separada por un guion, la numeración secuencial de siete dígitos.
> >
> >
> > -- Este e-mail fue enviado desde el Mail Server del diario ABC Color --
> >             -- Verificado por Anti-Virus Corporativo Symantec --
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at https://archive.midrange.com/midrange-l.
> >
> > Please contact support@xxxxxxxxxxxx for any subscription related
> > questions.
> >
> > Help support midrange.com by shopping at amazon.com with our affiliate
> > link: https://amazon.midrange.com

-- Este e-mail fue enviado desde el Mail Server del diario ABC Color -- 
            -- Verificado por Anti-Virus Corporativo Symantec --