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...