Click here to Skip to main content
15,867,835 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Helllo


i am working on web application the problem i m facing is that

if a user access saleorder form i goto database and get Max SID from saleorder table and increment in it, and when user finish i sent this id Saleorder table and other info as well as same SID to other 2 tables

but the problem is that if multiple users access at samee time how can i manage SID there wil be id conflict as SID is PK in SaleOrder and FK in other two tables

plz plz plz help me regarding this problem someone asked me to use application variable but how i dnt knw


Regards
Posted

1 solution

Yes, you can use application variable as an solution.
For application, please have a look to one of my articles..
A walkthrough to Application State

Here I've explained a simple example.
 
Share this answer
 
Comments
Sandeep Mewara 7-Oct-10 12:07pm    
Off-topic: Hey, I dropped you an email yesterday night. Did you recieve it? If so, can you share across few things. I have my first discussion tomorrow.

Thanks
Brij 7-Oct-10 12:10pm    
I didn't get any mail from you.You can send me on my id: brij_mishra2003@yahoo.co.in again, then I'll check it.
Sandeep Mewara 7-Oct-10 12:15pm    
Is it? I picked email link from one of your forum messages to drop it. I will send it again, meanwhile can you check if it went to junk or so.
Brij 7-Oct-10 12:21pm    
Not in spam also :(. also you can add me on GTalk at id 'mailtobrij@gmail.com'
Sandeep Mewara 7-Oct-10 12:24pm    
Email sent at said Id.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900