Click here to Skip to main content
15,891,136 members

Comments by Balaji1982 (Top 8 by date)

Balaji1982 9-Jul-12 1:32am View    
Hi dude, the Identity number must start with 1 daily.

This order number for today will be 2012070901, 2012070902, 2012070903.... for tomorrow will be 2012071001, 2012071002 and so on.

I recon we need to look for a more generic requests queuing system. First in First out implementation.
Balaji1982 4-Jul-12 8:26am View    
Thanks mate. Would this solve 10 or more concurrent requests for unique order number? I would like to keep the current table structure intact if possible and do the queuing only at the C# code level.
Balaji1982 4-Jul-12 4:34am View    
Thanks mate. Auto Increment is not suitable here as this is a Unique Order Number that is being generated. Something like this.
Format:
YYYYMMDD+MAX(COUNT(*) FROM TABLE)

This number for today will be 2012070401, 2012070402, 2012070403....

for tomorrow will be 2012070501, 2012070502 and so on
Balaji1982 26-Mar-12 2:27am View    
Thanks dude for your help. I appreciate it.
Balaji1982 25-Mar-12 6:11am View    
Hi dude,

Will work on this on Monday and let u know the outcome. Hopefully i should be able to get it working in my application. This bug in my application has been going on for a month now and the clients are pissed off because of this.

One thing i should let u know is i tried converting the source data from network in byte array from big5 encoding to Unicode and the converted data in byte[] doubled in size/length from 9000 to 18000. Since the rest of the processing in my app is entirely based on length of this data, i need to make sure i dont mess up this received data and i dont have to modify any other stuff except this encoding part. !!!