Delete a simple row in a database...

Discussion in 'Questions (Windows Mobile)' started by albert, Jul 1, 2007.

  1. albert

    albert New Member

    I have a sql table in a database with diferent rows but at same time they are similar to each other...
    something like this example
    01/07/2007 alfa 200
    01/07/2007 alfa 400
    01/07/2007 beta 200

    How can I delete a simple row without touch the others from the database?
    It's there a easy way to identify every row in a database with a unique number?
    Thanks !
     
    Last edited: Jul 1, 2007
  2. Erel

    Erel Administrator Staff Member Licensed User

  3. albert

    albert New Member

    Thanks Erel
    It works fine with the RowId !! :sign0060:

    But when i delete a row ...i delete aswell de rowid for this row; How can I refresh the rowid for the existing rows (after I deleted one row)? :sign0104:
     
    Last edited: Jul 1, 2007
  4. Erel

    Erel Administrator Staff Member Licensed User

    As a principal primary keys are unique, and a deleted key should not be used again.
     
Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice