2. ASPRunnerPro General questions
  3. Row Deletion
This topic is locked

Row Deletion

 		3/29/2005 3:50:58 PM
ASPRunnerPro General questions
Andy C author

I was going to a database and deleting some rows that were no longer needed, and there was a row that i noticed was more or less a duplicate so I deleted it by selecting the checkbox and i noticed the one beneath it was also deleted. And I went into my database and sure enough the ID's were missing for both of these rows even though I only wanted one row to be deleted. Any ideas? Thanks BTW the "name" field was the same but every other field was not.
Thanks

Andy
Sergey Kornilov admin 3/30/2005

Hi,
this could happen if key field value is the same for both rows.

You need to make sure key column value is unique for each row.
Andy C author 3/30/2005

Thank You very much for the quick Response!

Two More questions:

Ok, first question, can i work around this by creating Multiple Key fields in Asset tracker?

Also I am having a problem when updating the Key Field, I am not able to, I am sure that it is a Unique value, however when I click "save" the previous value is returned.(this is only in the Key * Field the other fields update without a problem)
Thanks

Andy
Sergey Kornilov admin 3/31/2005

Hi,
I won't recommend to update Key Fields.
You can create a new field in your database and set it as autonumber. Choose this field as a Key Field in ASPRunner to avoid this problem.
Andy C author 3/31/2005

Is there any way around this? My problem is i have only one field so it must be the key field, and there is only one field because this is the query that the lookup wizard uses on a differnt page. So i dont have any ID's or anything like that because it is only for the Lookup wizard.
Thanks.
Sergey Kornilov admin 4/4/2005

Hi,
you can add a new field and set it as Key column.

This won't break your existing application functionality.
Andy C author 4/4/2005

Ok, thank you much.