Delete command; Delete_row function (OpenInsight)
At 11 MAY 2000 10:18:32AM Paxton Scott wrote:
Must be missing something simple here. I have disabled the delete row function from all menus in this system, so the user cannot remove data from the database. However, I want to provide that functionality for the administrator. Figured, no problem. Gave him a screen to select the table and the row to delete, then put some code on the button. Tried DELETE tablevar,key ELSE …. and DELETE_ROW(tablename, key, lockswitch) In both cases, all indications are that the activity is performed correctly. I even get an SSP613: %1% row(s) deleted. when I check get_status(err). BUT, the row is still their when I look in the editor or when using AREV editor.
What am I missing? TIA, [email protected]
[url=http://www.arcscustomsoftware.com/]ARCS, Inc.
At 11 MAY 2000 10:29AM WinWin/Revelation Technical Support wrote:
Paxton-
Is the record you're trying to delete maintained by a Relational Index?
Mike Ruane
At 11 MAY 2000 10:31AM Stephen S. Revelation wrote:
Paxton,
Have you tried reading the row after deleting it? It may be that the rows indicated in your table haven't been refreshed?
-Stephen
At 11 MAY 2000 04:24PM Paxton Scott wrote:
It must have been late! all works fine now, thanks for the response!
-Paxton