Jump to content

New Record instead of Edit

dellerton

By dellerton
in Other Internet Technologies

 Share

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

Recommended Posts

  • Newbies
dellerton Newbie

dellerton

Posted
  • Newbies
Posted

We have a database (SpEvents.fp5) hosted on an FMserver. We then have a filemaker web server on another server (both OSX... FMP 5.5 unlimited on web). We developed a series of web pages using Claris Hompage's Filemaker Connection Assistant (we have done this a million times). Most of the pages and dbfs we host are "read-only", but in the past (when this server ran 4.0) I did make a solution just like the one I am working on now that allowed a user to EDIT data in a related (on the real server) database. So, the web database (Sp_EventsWWW.fp5) has one key field in it to relate back to SPEvents. Then on the WWW layout, all other fields are related fields.

The solution works fine for searching and browsing; however, when we try to EDIT a record, the process makes a completely new record in the related (hosted) database. There are no error messages generated (it look like, from the web end, like the task was successful)

I know that in v 5.x, there were some changes made that would effect this. I have seen similar postings here that talk about adding a ".0) to the end of the field name when pointing at a portal row. This, though, does not seem to work for me.

Why can't I seem to be able to do a simple "Edit" record the way I could in 4.x?

Any help would be greatly appreciated...

I have included some of the relevant code below.

Dean

*****************

<HTML>

<HEAD>

<TITLE>speventsWWW - Record Detail</TITLE>

</HEAD>

<BODY BGCOLOR="#FFFFFF">

<P><FORM ACTION="FMPro" METHOD="POST">

<P><INPUT TYPE="hidden" NAME="-DB" VALUE="speventsWWW">

<INPUT TYPE="hidden" NAME="-Lay" VALUE="www">

<INPUT TYPE="hidden" NAME="-Format" VALUE="record_detail_reply.htm">

<INPUT TYPE="hidden" NAME="-Error" VALUE="record_detail_error.htm">

<INPUT TYPE="hidden" NAME="-recid" VALUE="[fmp-currentrecid]"><BR>

<TABLE BORDER=0 WIDTH="100%">

<TR>

<TD WIDTH="33%">

<P ALIGN=right>Menu:</P>

</TD>

<TD>

<P><TEXTAREA NAME="Sp_Events::actual_menu" ROWS=7 COLS=30 WRAP=virtual>[FMP-Field: Sp_Events::actual_menu]</TEXTAREA></P>

</TD>

</TR>

</TABLE>

</P>

<CENTER><INPUT TYPE="submit" NAME="-Edit" VALUE="Edit Record"></CENTER>

</BODY>

</HTML>

Garry Claridge Grand Master

Garry Claridge

Posted
Posted

Try this:

<P><TEXTAREA NAME="Sp_Events::actual_menu.1" ROWS=7 COLS=30 WRAP=virtual>[FMP-Field: Sp_Events::actual_menu]</TEXTAREA></P>

Placing a ".0" creates a new Portal row; i.e. record in the related file. Using ".1" should refer to the first related record (I guess that only one should exist).

All the best.

Garry

This topic is 8057 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
Go to topic listing
×
×
  • Create New...

Important Information

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

  I accept