Newbies AlanStewart Posted February 15, 2001 Newbies Share Posted February 15, 2001 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 More sharing options...
yafreax Posted February 15, 2001 Share Posted 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. Link to comment Share on other sites More sharing options...
Newbies AlanStewart Posted February 15, 2001 Author Newbies Share Posted February 15, 2001 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 More sharing options...
Keith M. Davie Posted February 15, 2001 Share Posted February 15, 2001 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 Link to comment Share on other sites More sharing options...
Newbies AlanStewart Posted February 16, 2001 Author Newbies Share Posted February 16, 2001 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! Link to comment Share on other sites More sharing options...
Skye Ridley Posted August 14, 2001 Share Posted August 14, 2001 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 More sharing options...
Skye Ridley Posted August 14, 2001 Share Posted August 14, 2001 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 More sharing options...
Anatoli Posted August 15, 2001 Share Posted August 15, 2001 Hi Skye! Link to comment Share on other sites More sharing options...
clevow Posted January 31, 2002 Share Posted January 31, 2002 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 More sharing options...
Recommended Posts
This topic is 8118 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 accountSign in
Already have an account? Sign in here.
Sign In Now