Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004

    Unanswered: inserting record into table


    i'm inserting data into a table
    insert into tablename (field1, field2, field3) values ('some', 'values', 'in here')

    table is like this

    id field1 field 2 field3

    once i've inserted i need to return the id value which is a nextval sequence

    what is the best way to achieve this? is it to do a select id from tablename where field1 = 'some', field2 = 'values', field3 = 'in here'

    or is there a better way of doing this

    thanks for any help

  2. #2
    Join Date
    Jan 2004
    sorted now thanks

Posting Permissions

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