Hello alls , i am working on a interanet application for Inventory
handling,
i have a problem while submitting the data to server, please help me?
the problem goes like this
Data base : Ms-Access
Front End : ASP
The problem is how to comit the data "say Invoice" to main database is
two persons tries to make invoice at same time at different computers,
How to maintain the series of Invoice unaffected, how to allocat
Invoice number to them, and how to put a check that both of them can't
make a invoice of same customer at a same time at different computers
Please suggest
thanks
Deepak 5 1305
--give your invoice table a primary key field which is unique number.
--Make that primary key part of the invoice number.
This way, no two invoices will ever have the same number.
"Punjabi Munda" <de***********@gmail.comwrote in message news:11**********************@b28g2000cwb.googlegr oups.com...
Hello alls , i am working on a interanet application for Inventory
handling,
i have a problem while submitting the data to server, please help me?
the problem goes like this
Data base : Ms-Access
Front End : ASP
The problem is how to comit the data "say Invoice" to main database is
two persons tries to make invoice at same time at different computers,
How to maintain the series of Invoice unaffected, how to allocat
Invoice number to them, and how to put a check that both of them can't
make a invoice of same customer at a same time at different computers
Please suggest
thanks
Deepak
thanks for your reply but i know this solution , my main question i
think u don't understand, my main problem is if some one tries to make
a invoice from different computer at same time and one who starts
making it first rollback his data before saving it to server, now the
problem exsit that we are already allocate a invoice no. to the same
person, now how to handle this problem
please reply
deepak sachdeva
Jon Paal wrote:
--give your invoice table a primary key field which is unique number.
--Make that primary key part of the invoice number.
This way, no two invoices will ever have the same number.
"Punjabi Munda" <de***********@gmail.comwrote in message news:11**********************@b28g2000cwb.googlegr oups.com...
Hello alls , i am working on a interanet application for Inventory
handling,
i have a problem while submitting the data to server, please help me?
the problem goes like this
Data base : Ms-Access
Front End : ASP
The problem is how to comit the data "say Invoice" to main database is
two persons tries to make invoice at same time at different computers,
How to maintain the series of Invoice unaffected, how to allocat
Invoice number to them, and how to put a check that both of them can't
make a invoice of same customer at a same time at different computers
Please suggest
thanks
Deepak
Jon Paal answered your question correctly. That is how you maintain the
series of invoice numbers and ensure each invoice number is unique.
The question you really should be asking yourself is this: Why would you
allocate an invoice number before an invoice has been successfully created
in a database? Surely, until a user successfully commits their data, no
invoice exists.
--
Mike Brind
"Deepak Sachdeva" <de***********@gmail.comwrote in message
news:11**********************@l12g2000cwl.googlegr oups.com...
thanks for your reply but i know this solution , my main question i
think u don't understand, my main problem is if some one tries to make
a invoice from different computer at same time and one who starts
making it first rollback his data before saving it to server, now the
problem exsit that we are already allocate a invoice no. to the same
person, now how to handle this problem
please reply
deepak sachdeva
Jon Paal wrote:
>--give your invoice table a primary key field which is unique number. --Make that primary key part of the invoice number.
This way, no two invoices will ever have the same number.
"Punjabi Munda" <de***********@gmail.comwrote in message news:11**********************@b28g2000cwb.googleg roups.com...
Hello alls , i am working on a interanet application for Inventory
handling,
i have a problem while submitting the data to server, please help me?
the problem goes like this
Data base : Ms-Access
Front End : ASP
The problem is how to comit the data "say Invoice" to main database is
two persons tries to make invoice at same time at different computers,
How to maintain the series of Invoice unaffected, how to allocat
Invoice number to them, and how to put a check that both of them can't
make a invoice of same customer at a same time at different computers
Please suggest
thanks
Deepak
Hello Mike,
Thanks for your suggestions,
but when user has an interace to make invoice , he must be allocating a
temp invoice number which if he submit the invoice will be invoice
number , but what if he does not, , what if we don't allocate a
invoice number but allocate him a temp. no. which can be a part of
final invoice number, then how do we do it
Deepak Sachdeva
Mike Brind wrote:
Jon Paal answered your question correctly. That is how you maintain the
series of invoice numbers and ensure each invoice number is unique.
The question you really should be asking yourself is this: Why would you
allocate an invoice number before an invoice has been successfully created
in a database? Surely, until a user successfully commits their data, no
invoice exists.
--
Mike Brind
"Deepak Sachdeva" <de***********@gmail.comwrote in message
news:11**********************@l12g2000cwl.googlegr oups.com...
thanks for your reply but i know this solution , my main question i
think u don't understand, my main problem is if some one tries to make
a invoice from different computer at same time and one who starts
making it first rollback his data before saving it to server, now the
problem exsit that we are already allocate a invoice no. to the same
person, now how to handle this problem
please reply
deepak sachdeva
Jon Paal wrote:
--give your invoice table a primary key field which is unique number.
--Make that primary key part of the invoice number.
This way, no two invoices will ever have the same number.
"Punjabi Munda" <de***********@gmail.comwrote in message
news:11**********************@b28g2000cwb.googlegr oups.com...
Hello alls , i am working on a interanet application for Inventory
handling,
i have a problem while submitting the data to server, please help me?
the problem goes like this
Data base : Ms-Access
Front End : ASP
The problem is how to comit the data "say Invoice" to main database is
two persons tries to make invoice at same time at different computers,
How to maintain the series of Invoice unaffected, how to allocat
Invoice number to them, and how to put a check that both of them can't
make a invoice of same customer at a same time at different computers
Please suggest
thanks
Deepak
I have no idea. Why you would want to allocate an invoice number when an
invoice might not be created makes no sense to me at all.
--
Mike Brind
"Deepak Sachdeva" <de***********@gmail.comwrote in message
news:11*********************@h40g2000cwb.googlegro ups.com...
Hello Mike,
Thanks for your suggestions,
but when user has an interace to make invoice , he must be allocating a
temp invoice number which if he submit the invoice will be invoice
number , but what if he does not, , what if we don't allocate a
invoice number but allocate him a temp. no. which can be a part of
final invoice number, then how do we do it
Deepak Sachdeva
Mike Brind wrote:
>Jon Paal answered your question correctly. That is how you maintain the series of invoice numbers and ensure each invoice number is unique.
The question you really should be asking yourself is this: Why would you allocate an invoice number before an invoice has been successfully created in a database? Surely, until a user successfully commits their data, no invoice exists.
-- Mike Brind
"Deepak Sachdeva" <de***********@gmail.comwrote in message news:11**********************@l12g2000cwl.googleg roups.com...
thanks for your reply but i know this solution , my main question i
think u don't understand, my main problem is if some one tries to make
a invoice from different computer at same time and one who starts
making it first rollback his data before saving it to server, now the
problem exsit that we are already allocate a invoice no. to the same
person, now how to handle this problem
please reply
deepak sachdeva
Jon Paal wrote: --give your invoice table a primary key field which is unique number. --Make that primary key part of the invoice number.
This way, no two invoices will ever have the same number.
"Punjabi Munda" <de***********@gmail.comwrote in message news:11**********************@b28g2000cwb.googleg roups.com...
Hello alls , i am working on a interanet application for Inventory
handling,
i have a problem while submitting the data to server, please help
me?
the problem goes like this
Data base : Ms-Access
Front End : ASP
The problem is how to comit the data "say Invoice" to main database
is
two persons tries to make invoice at same time at different
computers,
How to maintain the series of Invoice unaffected, how to allocat
Invoice number to them, and how to put a check that both of them
can't
make a invoice of same customer at a same time at different
computers
Please suggest
thanks
Deepak
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: sffan |
last post by:
I am new to database programming and was curious how others solve the
problem of storing encrypted in data in db table columns and then
subsequently searching for these records.
The particular...
|
by: Hamed |
last post by:
Hello
I have employed as a developer in a software company that its team uses
FoxPro / VB 6.0 / VC++ 6.0 as the developing tools and newly is going to
migrate to VS.NET. There is a project...
|
by: sedefo |
last post by:
I ran into this Microsoft Patterns & Practices Enterprise Library while i
was researching how i can write a database independent data access layer. In
my company we already use Data Access...
|
by: Neil Ginsberg |
last post by:
We're using SQL Server 7 with an Access 2000 MDB as a front end with ODBC
linked tables. I recently created a new set of tables for the app, and users
are complaining that unsaved data is being...
|
by: Andrew Arace |
last post by:
I scoured the groups for some hands on code to perform the menial task
of exporting table data from an Access 2000 database to Oracle
database (in this case, it was oracle 8i but i'm assuming this...
|
by: Tony Lee |
last post by:
Some time a ago, on this newsgroup the following comments were made in
recommending
good references for Access (2003)
>I used to recommend Dr. Rick Dobson's, "Programming Access <version>" for...
|
by: Lyle Fairfield |
last post by:
In a recent thread there has been discussion about Data Access Pages. It
has been suggested that they are not permitted on many or most secure sites.
Perhaps, that it is so, although I know of no...
|
by: Johann Blake |
last post by:
I am looking for a good solution on how to implement data access in an
application so that there is a clean separation between the data access
layer, the business layer and the GUI layer. I am...
|
by: Grip |
last post by:
Hi,
I have gone throught the group and Microsoft's online help and have
seen many suggestions but I am still seeking clarity:
1. I have an excel spreadsheet. Column A contains text that may...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |