SQL InvoiceSequence question

Thread View: borland.public.interbase.sql

2 messages

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

2 total messages Started by Bram Schrijver Mon, 25 Nov 2002 22:20

#11390

Author: Bram Schrijver
Date: Mon, 25 Nov 2002 22:20

14 lines
1123 bytes

Hello,

I need to generate a invoicenr with help of a SP. This Invoicenr should be
like this:

Year|Month|Sequencenumber

The sequencenumber has to start every month with 0001

How do I accomplish this?

TIA,

Jerri

Re: SQL InvoiceSequence question

#11395

Author: Antonio Felix
Date: Tue, 26 Nov 2002 10:42

28 lines
1470 bytes

"Bram Schrijver" <aa.schryver@tirol.com> wrote:
>Hello,
>
>I need to generate a invoicenr with help of a SP. This Invoicenr should be
>like this:
>
>Year|Month|Sequencenumber
>
>The sequencenumber has to start every month with 0001
>
>How do I accomplish this?
>
>TIA,
>
>Jerri
>
>

Hi,

Use a Table to store the Invoice Numbers.
Use the Year + Month + Sequence as Primary Key.
Read an increment the sequence based on Year+Month on 
Invoice generation.

HTH
Antonio

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