Solved

Autoincremental fields in Access 97 with D4 & BDE

Posted on 1999-01-05
5
191 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 50 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone 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

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…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

821 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