E
Eddy
Hope someone can clear my thought. Thanks in advance.
I have the following table keeping all available document numbers for my
application.
Document / Num
-------------------------
Invoice / 1230
Receipt / 451
Currently, I am using SQL SELECT query to obtain the number and then utilize
SQL UPDATE query to increase the number by one. I am always worried about
somewhere between the two queries, there is a slight possibility that
someone else would obtain the old number (before the UPDATE query is
executed). So I am thinking of using a recordset to take control of the
table (ideally at the record). This way, I can read the number and increase
it by one altogether. My question is how MSDE and JET 4.0 (because I am
using both ADO and DAO) will handle the recordset when there are two
recordsets (two PCs) trying to access the table. Will MSDE / JET 4.0 arrange
the later one to wait and process it after the first one is clear. Or will
they just return an error to the later recordset.
I have the following table keeping all available document numbers for my
application.
Document / Num
-------------------------
Invoice / 1230
Receipt / 451
Currently, I am using SQL SELECT query to obtain the number and then utilize
SQL UPDATE query to increase the number by one. I am always worried about
somewhere between the two queries, there is a slight possibility that
someone else would obtain the old number (before the UPDATE query is
executed). So I am thinking of using a recordset to take control of the
table (ideally at the record). This way, I can read the number and increase
it by one altogether. My question is how MSDE and JET 4.0 (because I am
using both ADO and DAO) will handle the recordset when there are two
recordsets (two PCs) trying to access the table. Will MSDE / JET 4.0 arrange
the later one to wait and process it after the first one is clear. Or will
they just return an error to the later recordset.