Auto increment

From: Carlos Que Yabut (carlosy_at_emaya.net)
Date: 12/17/04

  • Next message: Baliga, Narasimha: "LoadFromfile" 
    Date: Fri, 17 Dec 2004 01:58:41 -0800

    I am using ADO to access MAXDB. I am having problems getting the "auto
    increment" field. Everytime a record is inserted, i kept getting a null in
    the 'auto increment' field. Is there a specific setting i need for the
    TADOdateset?

  • Next message: Baliga, Narasimha: "LoadFromfile"

    Relevant Pages

    • Re: Form Save
      ... Increment Number is a required field with no duplicates ... they get the same calculation. ... Auto Number ... Increment number ...
      (microsoft.public.access.modulesdaovba)
    • SQL - CRecordSet
      ... I am trying to use MFC and CRecordSet class to manage a database. ... of the currently selected record before the AddNew call. ... I'd like to know what are the default fields (or special fields like auto ... increment) filled in after addnew / update. ...
      (microsoft.public.vc.mfc)
    • Re: Auto Number
      ... I found a similar problem and made a procedure to increment the primary key ... The field refno is my primary key and needs to be incremented by 1 each time ... > auto number 1, and sequentially up to about 20,000. ... > Mike from Moriches ...
      (comp.databases.ms-access)
    • RE: HOW DO I SETUP NUMBERING INVOICES
      ... I would suggest to store the invoice number into an external file or a text ... provided you save the workbook everytime you open. ... If you would prefer to increment the number on each save, ...
      (microsoft.public.excel.programming)
    • Re: Form Save
      ... Yes, that is how Access works, the autonumber primary key is not created ... Auto Number ... Case Number (defaults to the combination of Date and Increment Number) ... I've tried a number of Docmd.Save or Requiry or macro saves, ...
      (microsoft.public.access.modulesdaovba)