Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Paradox Table on network

Posted on 2000-05-18
5
270 Views
Last Modified: 2010-04-06
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
Comment
Question by:sivatagiherceg
5 Comments
 
LVL 2

Accepted Solution

by:
aubs earned 15 total points
ID: 2820619
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
 
LVL 9

Expert Comment

by:ITugay
ID: 2820621
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
 
LVL 2

Expert Comment

by:IPCH
ID: 2820750
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
 
LVL 27

Expert Comment

by:kretzschmar
ID: 2820888
hi sivatagiherceg,

buy this q (worth 150 points)

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

meikl ;-)
0
 
LVL 1

Expert Comment

by:flooder
ID: 2825126
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question