sivatagiherceg
asked on
Paradox Table on network
I have a database program that run's on a Lan Network.
I use a paradox table.
My problem is,that i have a autoincrement field for ref number if I insert a record on terminal A and try to insert a record on terminal B, at the same time the Number is assigned to both records(This cannot be correct) which means if A terminal starts to insert at the same time as B terminal I would expext different Ref Numbers.
please help how to solve this problem
I use a paradox table.
My problem is,that i have a autoincrement field for ref number if I insert a record on terminal A and try to insert a record on terminal B, at the same time the Number is assigned to both records(This cannot be correct) which means if A terminal starts to insert at the same time as B terminal I would expext different Ref Numbers.
please help how to solve this problem
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I sugest you not to use autoincremental field in the network with Paradox. I have common problem and I sove it with additional table that collects all my counters.
Check the Aubs coment to, it's very important when you work on network with Paradox.
Check the Aubs coment to, it's very important when you work on network with Paradox.
hi sivatagiherceg,
buy this q (worth 150 points)
http://www1.experts-exchange.com/bin/Q.10341336
meikl ;-)
buy this q (worth 150 points)
http://www1.experts-exchange.com/bin/Q.10341336
meikl ;-)
aubs answer will work fine.
If your net dircetory in the BDE is set the same for all users accross the network then it will work fine.
I have autoinc fields in my databases and i have encounterd no problems while users work similtaneously or even when users work with master detail tables.
Here is a article that you will also find very handy when working with paradox
www.o2a.com/tu.htm
If your net dircetory in the BDE is set the same for all users accross the network then it will work fine.
I have autoinc fields in my databases and i have encounterd no problems while users work similtaneously or even when users work with master detail tables.
Here is a article that you will also find very handy when working with paradox
www.o2a.com/tu.htm
select max(autoinc_field) where user_id=:user_id
-----
Igor.