Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Koen Piller
  Where is Koen Piller?
 Santpoort-Zuid
 Netherlands
 Koen Piller
 To: JK M
  Where is JK M?
 Meycauayan City
 Philippines
 JK M
 Tags
Subject: RE: help on date and auto numbering..
Thread ID: 268549 Message ID: 268609 # Views: 30 # Ratings: 0
Version: Visual FoxPro 6 Category: VFP and .NET
Date: Tuesday, July 13, 2010 3:03:03 PM         
   


> >
> >
> >
> > Hi,
> >
> > What is the condition for the next number? date or reccord ?
> >
> > id controlnumb date field
> > 1 10-01 01.01.2010 appels
> > 2. 10-02 01.01.2010 pears
> > 3. 10-03 01.03.2010 appels
> >
> > or
> >
> > 1. 10-01 01.01.2010 appels
> > 2. 10-02 01.02.2010 pears
> > 3. 10-03 01.04.2010 appels
> >
> > Regards,
> >
> > Koen
>
> Hey Sir Koen, 10-01 where 10 is the last 2 parts of the current year which is 2010, and 01,02,03 are like IDnumbers, which start from 01 and will reset to 01 again if the current year changes from 2010 to 2011, therefore creating 11-01..

JKM,

10 or 11 meaning the last 2 digists of the year is clear.
Question is what is the condition for the next sequence number? date / reccord or whatever ? Do you want a function to renumber all existing data or do you want a function to assign a number to new data ?

Regards,

Koen

ENTIRE THREAD

help on date and auto numbering.. Posted by JK M @ 7/13/2010 8:25:45 AM
RE: help on date and auto numbering.. Posted by Bhushan Sahni @ 7/13/2010 8:33:38 AM
RE: help on date and auto numbering.. Posted by JK M @ 7/13/2010 11:48:02 AM
RE: help on date and auto numbering.. Posted by Samir H. @ 7/13/2010 2:52:50 PM
RE: help on date and auto numbering.. Posted by JK M @ 7/13/2010 3:01:08 PM
RE: help on date and auto numbering.. Posted by Koen Piller @ 7/13/2010 12:56:39 PM
RE: help on date and auto numbering.. Posted by JK M @ 7/13/2010 2:37:01 PM
RE: help on date and auto numbering.. Posted by Koen Piller @ 7/13/2010 3:03:03 PM
RE: help on date and auto numbering.. Posted by JK M @ 7/13/2010 3:15:09 PM
RE: help on date and auto numbering.. Posted by ho me @ 7/14/2010 5:58:21 PM
RE: help on date and auto numbering.. Posted by Christian Tabligan @ 7/15/2010 2:57:22 AM
RE: help on date and auto numbering.. Posted by JK M @ 7/15/2010 5:51:26 AM
RE: help on date and auto numbering.. Posted by Christian Tabligan @ 7/15/2010 6:20:28 AM