This topic is locked

Delete Record

7/3/2003 1:56:50 PM
ASPRunnerPro General questions
G
Geohawk author

When I click on "delete" to delete a record in list view, all records in the table are deleted. Yikes! What's up with that?
Just started using your software and it's very good.

Sergey Kornilov admin 7/8/2003

Hi,
make sure that key column contains unique values for each record.

ASPRunner generates the following SQL statement to delete required record:

delete from <table name> where <key column> = <value>



This statement will delete all records in the database where <key column> equals <value> that's why you need to make sure all records have unique key column value.
Sergey Kornilov