?
Solved

Autoincremental fields in Access 97 with D4 & BDE

Posted on 1999-01-05
5
Medium Priority
?
198 Views
Last Modified: 2010-05-18
My autoincremental fields are not incremental by 1 but by a random number. is there a setting which tell the bde to increment in this manner.
0
Comment
Question by:DeanSmith
  • 3
  • 2
5 Comments
 

Author Comment

by:DeanSmith
ID: 1354639
I have an access 97 database that I am using the BDE to access. Everything
works fine except for the autoincrement field. It produces random results
rather than a sequential increment. On one machine it increments by 5 and on
another it is 6. I tried reinstalling BDE and that did not help.
I am using the most current, 5.0, that came with Delphi 4.0. I have installed update patch 2. If anyone can offer an assistance I would greatly appreciateit.
0
 
LVL 17

Expert Comment

by:inthe
ID: 1354640
This is common problem with access when you have default values together on the same table.  Remove  the default values and the Autoincrement feature will work.
Regards Barry

0
 
LVL 17

Accepted Solution

by:
inthe earned 200 total points
ID: 1354641
That should be common problem with "bde" and is documented in the Delphi 3 readme.txt file the only solutions are either remove the autoincrement field and use a number or remove all the default values from fields
Regards Barry


0
 

Author Comment

by:DeanSmith
ID: 1354642
Default values on the field in the access table seem to increase the autoincrement number by 1 more than the number of defaults.

If anyone has a reason for this i would like to know as I think it must be a fundemental problem with the BDE.
0
 
LVL 17

Expert Comment

by:inthe
ID: 1354643
you guess correct it is problem with bde as you say
Regards Barry
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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…
In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Screencast - Getting to Know the Pipeline
Suggested Courses
Course of the Month17 days, 3 hours left to enroll

864 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