How to return ID number after insert?

Results 1 to 6 of 6

Thread: How to return ID number after insert?

  1. #1
    perini14 Guest

    Default How to return ID number after insert?

    I have a database with 2 fields: ID and LANGUAGE. I insert data with this sql:<BR>insert into table1 (language) values ("english")<BR>Now I need to get the ID number of just inserted row. Don&#039;t tell me to use rs.movelast, becose sometimes access inserts new row at the begining of the table (!!!). Also don&#039;t tell me to use where language="english" because I have multiple "english" entry.<BR><BR>Any ideas?<BR><BR>Thanks<BR>

  2. #2
    Stupid Genuis Guest

    Default RTFFAQs

    What db are you using.<BR><BR>Brain Power.

  3. #3
    Spleh Guest

    Default I don't know <eop>


  4. #4
    Jason Guest

    Default RE: How to return ID number after insert?

    Why are you inserting another record with the same entry? It seems pretty redundant to create multiple records for the same English entry if you already have one in the database.<BR><BR>What else are you storing in this database?

  5. #5
    Join Date
    Dec 1969

    Default But you had to show the world

    what a dumb *** you are by posting saying you don&#039;t know. This board definitely seems to be becoming fly paper of idiots like you.<BR><BR>Brain Power.

  6. #6
    perini14 Guest

    Default RE: RTFFAQs

    I&#039;m using access. And the table has more fields then only "language" field - that was just for example.

Posting Permissions

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