ADO autInc

From: Tomas Rutkauskas (tomasr_at_mail.lt)
Date: 12/10/03 

Date: Wed, 10 Dec 2003 13:03:26 +0200

Hello,

How to read AutoNumber field value when ADO Dataset become in insert mode?
I always get null. It seems that AutoNumber is generated after post.
Is it possible to read Autonumber in insert mode?

p.s. I am using Access 2002, D7. Autonumber is the field in Access db.

Regards,
Tomas

Relevant Pages

  • Re: do all primary keys use autonumber
    ... that you won't have any duplicate values, and an Autonumber field occupies only about 4 bytes per record, much shorter than many other fields you might choose to use. ... choice of first resort, because it satisfies the requirements for a primary key, is small, and is not bound to anything else in the model, making it practically immune to any need for revision). ... Say, a table with just two columns, a random integer column named ID ...
    (microsoft.public.access.tablesdbdesign)
  • Re: "Indexed or Primary Key cannot contain a Null value" / Autonum
    ... Allen Browne - Microsoft MVP. ... Tips for Access users - http://allenbrowne.com/tips.html ... >> c) Is there any Default Value in the text box for the autonumber field>> on ...
    (microsoft.public.access.modulesdaovba)
  • Re: "Indexed or Primary Key cannot contain a Null value" / Autonum
    ... CaseAutonumber ... Allen Browne - Microsoft MVP. ... post the exact error message you are receiving. ... Is there any Default Value in the text box for the autonumber field ...
    (microsoft.public.access.modulesdaovba)
  • Re: Creating an Orders Form with multiple order types
    ... autonumber function, but I need sequential number for each type of order. ... the DMAX function. ... you can simply use an autonumber field and make the order number unique ...
    (microsoft.public.access.forms)
  • RE: Importing and Autonumber Problem
    ... Autonumber field in the query. ... One of the tables has a field called ClientID which is generated using ... Autonumber and is a primary key. ... mess and out of options. ...
    (microsoft.public.access.externaldata)