Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

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

Recommended Posts

  • Newbies
Posted

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

Posted

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.

  • Newbies
Posted

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>

Posted

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

  • Newbies
Posted

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...
Posted

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

Posted

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

  • 5 months later...
Posted

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

This topic is 8331 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
×
×
  • Create New...

Important Information

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