Solved

Paradox Table on network

Posted on 2000-05-18
5
269 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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Printing problem 2 93
find a node in VST 2 68
URL for downloading Google Chrome for Win XP 2 155
Delphi...Split view - idea? 1 68
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…
This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

773 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