Can not Delete or Edit ANY records in my Database :(
unfortunatly, my database sql commands rely heavily on the database’s structure and primary key order… when someone or something (i.e: vb.net) edits or deletes a record from the database, it leaves an altered mark on the primary key, which makes the record edited or deleted change in order when the database adapter fills the data grid, although the database itself is still in order… many other sql functions that i have coded will not work either because the order has changed.. such as the form i created when users double click a search result record.. if the primary key field is altered in any way, the form will not be able to choose the correct record, as i add a constant to the record id selected…
hence, i now face a limit where i can not edit or delete criminal records, hence i must remove some objectives.
