I am using railway reservation project.
I am using for passenger Reservation Train_No,Boogie_no,Seat_No.
I have problem with While Selecting Same Train_No,Boogie_no,Seat_No from two Pc's.
It gives error duplicate values.
What I will do When Two user selecting same values simultaneously.
Please Suggest me Idea for this Project.
I am Using Visual Basic 6.0 for Front End and Oracle 9i for Back end.
bk_yogeshvaidya
0
Newbie Poster
Recommended Answers
Jump to Postthis isn't necessarily pertinent to vb, but normally what you would do is create a locked column in the database, whenever they start reserving set it to locked and not allow any other users to access when the column is set
Jump to Postyou need to check for existance of the record before insert the same into database. you can use COUNT() for the purpose.
All 5 Replies
dickersonka
104
Veteran Poster
debasisdas
580
Posting Genius
Featured Poster
ithelp
757
Posting Virtuoso
Banned
ramulal
0
Newbie Poster
ramulal
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.