Autonumber field

Results 1 to 2 of 2

Thread: Autonumber field

  1. #1
    Join Date
    Dec 1969
    Posts
    9

    Default Autonumber field

    I am using a recordset object and calling the addnew method to put in a new record (SQL Server).<BR>I have a problem with one field which is supposed to autonumber;<BR>(NewCand is my recordset object)<BR>NewCand("CandidateID") = ??AutoNumber??<BR>NewCand("Title") = Request.Form("dTitle")<BR>NewCand("FirstName") = Request.Form("tFirstName")<BR>How do I proceed?<BR><BR>Thanks<BR><BR>

  2. #2
    Stephen Fisher Guest

    Default RE: Autonumber field

    If it is Autonumber than I dont think you can call<BR><BR>NewCand("CandidateID") = ??AutoNumber??<BR><BR>Just remove this line of code. The addNew command will automatically increment the Autonumber field and add what it thinks the next number is

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •