Jump to content

Can't delete record!


AlanStewart
 Share

This topic is 7199 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • 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).]

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

  • 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>

Link to comment
Share on other sites

  • 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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • 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

Link to comment
Share on other sites

This topic is 7199 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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