topic Re: sequence number in Application Development and Automation Discussions

sequence number

Former Member — Tue, 21 Mar 2006 03:50:32 GMT

plse guide me to solve this

there r 1500 plants eatch plant generate its own batch

plant1 batch number should be counted as 1

plant2 batch number should be counted as 1

plant3 batch number should be counted as 1

plant4 batch number should be counted as 1

and so on upto 1500 plants

similarly next sequence

plant1 batch number should be counted as 2

plant2 batch number should be counted as 2

plant3 batch number should be counted as 2

and so on upto 1500 plants

next sequence is like

plant1 batch number should be counted as 3

plant2 batch number should be counted as 3

plant3 batch number should be counted as 3

this will go up to 1500 plants batch number is plant specific.

for every plant plant should give its own sequence.

plse help me out

many thanks

aaryaa

Re: sequence number

Former Member — Tue, 21 Mar 2006 03:57:40 GMT

Hi Madhu,

Do you want the code to generate the following output..

Or you want to create a sequential batch number.

regards

satesh

Re: sequence number

Former Member — Tue, 21 Mar 2006 04:59:55 GMT

hi Satesh R

many thanks for ur reply.there is no code is needed i feel so we may have to create a table,that table should be populated eatch time with locking mechanism to overcome overlaping.

many thanks

aaryaa