Re: ADO autInc

From: Mike Shkolnik (mshkolnik2002_at_ukr.net)
Date: 12/10/03 

Date: Wed, 10 Dec 2003 13:16:20 +0200

Tomas,

MS Access will generate this autoinc value only after real post. So you
can't get it in OnNewRecord event 

--
With best regards, Mike Shkolnik
EMail: mshkolnik@scalabium.com
http://www.scalabium.com
"Tomas Rutkauskas" <tomasr@mail.lt> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:3fd6fd7d@newsgroups.borland.com...
> 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: problems with autonumber fields
    ... look at CreateField DAO method in access help, to make autonumber - you need to set dbAutoIncrField attribute for a field. ... Best regards, ...
    (microsoft.public.access.modulesdaovba)
  • Adding records to MS Access 97 Tables using ASP.net
    ... Autonumber and the other two are text type for the last two days and now i am ... I dont have any queries in the table. ... Regards ... Three Cheers to Technet for the Help! ...
    (microsoft.public.dotnet.framework.aspnet)
  • Retrieve The Autonumber Value In Access Using C#
    ... How do i get The Autonumber Value of a record that is just inserted? ... And then specialy in de Visual Studio.Net 2003 envoirement? ... With the sqlCommand or DataSet in c#? ... Regards, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Problem with AutoNumber
    ... If it's autonumber with its New Values property not set to random, I can't think of any possible reason why this should happen... ... then what you did took care of it. ... Regards, ...
    (microsoft.public.access.formscoding)