J
Jac
Hi,
Is it possible to writa query where you select information and at the same
time you update that information.
Now I do this in 2 queries :
select number from lastnumbers where code = 'BRF'
update lastnumbers set number = number + 1 where code = 'BRF'
My problem is that another person can do the read at the same time and
retrieve the same number value as I did.
Maybe I can lock that record (only one record with code = 'BRF') when I am
reading en updating. How can I do that?
Tkx,
Jac
Is it possible to writa query where you select information and at the same
time you update that information.
Now I do this in 2 queries :
select number from lastnumbers where code = 'BRF'
update lastnumbers set number = number + 1 where code = 'BRF'
My problem is that another person can do the read at the same time and
retrieve the same number value as I did.
Maybe I can lock that record (only one record with code = 'BRF') when I am
reading en updating. How can I do that?
Tkx,
Jac