• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 279
  • Last Modified:

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
0
sivatagiherceg
Asked:
sivatagiherceg
1 Solution
 
aubsCommented:
You need use BDE Administrator to set a path to a net file.

Start BDE Admin
Click on the Configuration Tab
Click Drivers>Native>Paradox

In the Net Dir Type the path to a network directory (must not be the same directory as the DB tables)

Close and save any changes.


0
 
ITugayCommented:
It seems as you need to get value of autoinc field in last inserted record. Add user_id or station_id field to your table and fill before insert it then:

select max(autoinc_field) where user_id=:user_id

-----
Igor.
0
 
IPCHCommented:
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.
0
 
kretzschmarCommented:
hi sivatagiherceg,

buy this q (worth 150 points)

http://www1.experts-exchange.com/bin/Q.10341336

meikl ;-)
0
 
flooderCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now