[ic] Deleteing Interchange Database Tables with a Form

村橋詳三:木田ネットビジネス interchange-users@icdevgroup.org
Wed Apr 30 00:17:00 2003


I tried to delete a record from products table with the following form.
The problem is no delete function.

[tag flag write]products[/tag]
[set mv_data_enable]1[/set]

<FORM METHOD=POST ACTION="[process]">
<INPUT TYPE=HIDDEN NAME="mv_data_table" VALUE="products">
<INPUT TYPE=HIDDEN NAME="mv_todo" VALUE="set">
<INPUT TYPE=HIDDEN NAME="mv_data_key" VALUE="sku">
<INPUT TYPE=HIDDEN NAME="mv_data_function" VALUE="DELETE">
<INPUT TYPE=HIDDEN NAME="mv_data_verify" VALUE="YES">
<INPUT TYPE=HIDDEN NAME="mv_nextpage" VALUE="mgr-products-list">
<INPUT TYPE=HIDDEN NAME=mv_data_fields" VALUE="sku">
<input type="submit" value="DELETE">
</FORM>



Catalog error.log shows:
 update_data: DELETE without VERIFY, abort


When without <INPUT TYPE=HIDDEN NAME="mv_data_verify" VALUE="YES">,
Catalog error.log shows:
 No key 'sku' found for function='delete' table='products'


IC version is 4.8.5 and products table is GDBM.

Is there any other way to delete a record from non-admin user?

Thanks.
Murahashi