Help
-
in my project, i need Serial No like 1, 2, 3, in sequence in date wise for Example today is 28/10/2009......so the serial no should be like 1.2.3 and when the date changes it must start again 1.2.3 any idea ? thanks for help
You don't mention what your data store is. ASsuming a SQL DB, the resetting numbers mean you can't use an identity column, you probably just have to write code to work out the next value for the current date.
Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
-
You don't mention what your data store is. ASsuming a SQL DB, the resetting numbers mean you can't use an identity column, you probably just have to write code to work out the next value for the current date.
Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
-
You don't mention what your data store is. ASsuming a SQL DB, the resetting numbers mean you can't use an identity column, you probably just have to write code to work out the next value for the current date.
Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
-
Sir i am trying like this.... getting the todays date and then number of records and then adding +1 to the number of records...... if date is changed (means next day) then again start from 1 and then +1 .... is this right ? thanks for help
It's your business rule, but I think you described it correctly, yes.
Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
-
It's your business rule, but I think you described it correctly, yes.
Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.