Results 1 to 4 of 4

Thread: Adding new record

  1. Aug 15th, 2000, 02:53 PM #1
    mikki
    mikki is offline

    Thread Starter
    Junior Member
    Join Date
    Aug 2000
    Posts
    23

    Unhappy

    When adding a new record to database table, the record is added in the very first position and at the end of the table. How do stop writing over the first record in the table?
    Reply With Quote Reply With Quote
  2. Aug 15th, 2000, 03:06 PM #2
    parksie
    parksie is offline
    Monday Morning Lunatic parksie's Avatar
    Join Date
    Mar 2000
    Location
    Mashin' on the motorway
    Posts
    8,169
    Have a look at AddNew, but in your case, I would advise that you don't need to put it in a specific order in the table. Just re-order it when you SELECT the records.
    I refuse to tie my hands behind my back and hear somebody say "Bend Over, Boy, Because You Have It Coming To You".
    -- Linus Torvalds
    Reply With Quote Reply With Quote
  3. Aug 15th, 2000, 04:48 PM #3
    JHausmann
    JHausmann is offline
    Frenzied Member
    Join Date
    Aug 1999
    Location
    Santa Clara, Ca , 95058
    Posts
    1,105
    Originally posted by mikki
    When adding a new record to database table, the record is added in the very first position and at the end of the table. How do stop writing over the first record in the table?
    I'll bet you don't have a primary key defined...
    Reply With Quote Reply With Quote
  4. Aug 16th, 2000, 07:54 AM #4
    mikki
    mikki is offline

    Thread Starter
    Junior Member
    Join Date
    Aug 2000
    Posts
    23
    My primary is ClientID
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width