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


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

they are numbers which will be saved as data in a table sir, just like control IDs

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