Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Can't delete record!

AlanStewart
in Custom Web Publishing

Featured Replies

  • Newbies

I have an FMP 5 database set up to manage vendor records via an intranet and browsers. Each user has the option to delete, edit or create a new record. Create new and edit both work fine, but when I try to delete a record, I get an error 101. Doesn't 101 mean record not found? I can search for the record I want to delete, even get a record detail of it via my browser, I just can't delete it.

Using: Mac G4, IE 5, FMP5 unlimited.

Not sure where to start troubleshooting. Thanks in advance for any suggestions!

[This message has been edited by webvox (edited February 15, 2001).]

please post the code starting with the beginning of the form and related tags and include the code at the end of the forms (submit buttons, etc. ). You could probably clip the middle.

jeremy

------------------

Life's great when you're a millionaire. . . well, ya know, i'm assuming.

  • Author
  • Newbies

Hopefully this will come across okay. If there's a better way to post the code, please let me know.

Database name: GlobalVendors and using CSS for page formatting.

Thanks for helping, Jeremy!

A

TOP PORTION OF CODE

<HTML>

<HEAD>

<TITLE>global vendors : record detail</TITLE>

<META NAME=GENERATOR CONTENT="Claris Home Page 3.0">

<X-CLARIS-WINDOW TOP=69 BOTTOM=623 LEFT=67 RIGHT=757>

<X-CLARIS-TAGVIEW MODE=full>

<link rel="stylesheet" href="globalstyle.css" type="text/css">

</HEAD>

<BODY BGCOLOR="#FFFFFF" background="../images/core/masterbg.jpg">

<P> <FORM ACTION=FMPro METHOD=POST> <INPUT TYPE=hidden NAME=-DB VALUE='GlobalVendors'> <INPUT TYPE=hidden NAME=-Lay VALUE='Layout #1'> <INPUT TYPE=hidden NAME="-Format" VALUE="record_detail_reply.htm"> <INPUT TYPE=hidden NAME="-Error" VALUE="record_detail_error.htm">

<table border="0" align="center" name="actiontable" class="subtitle" cellspacing="6">

<tr>

<td>

<div align="center">

<input type=submit name="-Edit" value="Save Changes">

</div>

</td>

<td>

<div align="center">

<input type=Submit name="-Delete" value="Delete Record">

</div>

</td>

<td>

<div align="center">

<input type=reset value="Reset Form" name="reset">

</div>

</td>

</tr>

</table>

<BR>

<CENTER>

</CENTER>

BOTTOM PORTION OF CODE

<CENTER>

<table border="0" name="actiontable" cellspacing="6" class="subtitle">

<tr>

<td class="subtitle">

<div align="center">

<input type=submit name="-Edit" value="Save Changes">

</div>

</td>

<td class="subtitle">

<div align="center">

<input type=Submit name="-Delete" value="Delete Record">

</div>

</td>

<td class="subtitle">

<div align="center">

<input type=reset value="Reset Form" name="reset">

</div>

</td>

</tr>

</table>

<p><BR>

</p>

<SPACER TYPE=horizontal SIZE=15>

</CENTER>

<P> 

</FORM>

</BODY>

</HTML>

Syntax.

Please refer to your CDML Reference. "Other tags that are required" Edit Record, the -edit action tag requires -recid. Delete, the -delete action tag requires -recid.

There may be other syntax problems as well. But start here.

Peace

Keith M. Davie

  • Author
  • Newbies

Bingo!

You were right: it was missing the recid tags. I must have looked a hundred times at my code before posting and didn't see it. Thanks very much for your help!

  • 5 months later...

Thank goodness for your reply and for this information. I, too, had been staring at my code and manuals for ages trying to figure this out.

Just as an FYI to anyone else who might use this info: I thought I HAD included the recid - but I was getting my record ID from a TOKEN:

<INPUT TYPE="hidden" NAME="-recid" VALUE="[FMP-currenttoken:1]">

- which did not work. When I changed my code back to

<input type="hidden" name="-RecID" value="[FMP-CurrentRecID]">

everything then worked smoothly.

--Skye

Thank goodness for your reply and for this information. I, too, had been staring at my code and manuals for ages trying to figure this out.

Just as an FYI to anyone else who might use this info: I thought I HAD included the recid - but I was getting my record ID from a TOKEN:

<INPUT TYPE="hidden" NAME="-recid" VALUE="[FMP-currenttoken:1]">

- which did not work. When I changed my code back to

<input type="hidden" name="-RecID" value="[FMP-CurrentRecID]">

everything then worked smoothly.

--Skye

Hi Skye!

  • 5 months later...

I'm getting the same error now too.

If I view the source code on the page I'm editing, the current recID is correct.

the record is created by the URL:

href="http://hostname:591/progress_reports/FMPro?-db=progressreports.fp5&-format=new_record.html&-lay=report&user_id=[fmp-currenttoken]&project_id=[fmp-currentrecid]&-New=

the page that is returned is:

<form action="FMPro" method="post">

<input type="hidden" name="-db" value="progressreports.fp5">

<input type="hidden" name="-lay" value="report">

<input type="hidden" name="-format" value="redirect.html">

<input type="hidden" name="-error" value="detail_error.html">

<input type="hidden" name="-RecID value="[fmp-CurrentRecID]">

LOTS OF HTML HERE

<input type="submit" name="-Edit" value="Submit progress report">

</form>

The record is created fine, I just can't edit it. Help please?

FTR - FMP 5.5 running on Win 2K IIS, custom publishing

TIA,

Carrie

Create an account or sign in to comment

https://fmforums.com/topic/765-cant-delete-record/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.