Jump to content

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

Recommended Posts

Posted

Hi

I got :

DB_A, DB_B, DB_C .

The page is on DB_A

The Inline Is from DB_B :

[fmp-inlineaction:-db=DB_B.fp5,-lay=main,ID={fmp-field:id},-max=all,-find]

[fmp-record]

<input type=text name="realation::comments" value="[FMP-Field: realation::comments ]" size=20 maxlength=51>

[/fmp-record]

[/fmp-inlinneaction]

Im trying to save the chenge I made using "-edit" but it wont let me...

Why it will let me edit a portal row, but not an inline?

and is it possible to edit rows with inline?

Posted

Inline is used just find records...another page must accept the edit action. Use the form to submit to that action/format page

------------snip--------------------------

[fmp-record]

<FORM ACTION="FMPro" METHOD="post" name="EDIT">

<INPUT TYPE="hidden" NAME="-RecID" VALUE="[FMP-currentrecid]">

<INPUT TYPE="hidden" NAME="-db" VALUE="Your_DB.fp5">

<INPUT TYPE="hidden" NAME="-lay" VALUE="your_layout">

<INPUT TYPE="hidden" name="-format" value="Record_Edited.html">

<input type=text name="realation::comments" value="[FMP-Field: realation::comments ]" size=20 maxlength=51>

</form>

[/fmp-record]

----------------snap--------------

I hope this is what ur looking for....

all the best!

Posted

"Inline is used just find records..."

From CDMLRD:

"<!-- Log page hits in another database -->

[FMP-InlineAction: -db=log.fp5, -lay=web, time="{CurrentTime}", date="{CurrentDate}",

page="This page!", browser="{ClientType}", ip="{ClientIP}", -new]

[/FMP-InlineRequest]"

To edit you will need a META Refresh page. Depending on the edit, you may need two META Refresh pages or one META Refresh with JavaScript.

Good luck.

Posted

"Inline is used just find records"<---in His case...

assuming that he wants to be able to edit/update each record individually.

Unable ....-new] vs. ...-edit]

and "To edit you will need a META Refresh page" -- he said that -edit didn't work for him so refresh wont help him...for log it works fine since all the variables are provided (already exsiting by the fact the user is connected)by a 'server' not pulled from the DB based on filtering/sorting

but above all -edit] should have worked to begin with confused.gif

then again...

I'm no expert, I'm

Willing to Try to help laugh.gif

Posted

Hi

I got a bit confused... crazy.gif

I have a page (form) with editable inline outputs from a different DataBase.

You are telling me that i need another form tag inside the inline tag....

Can you do that? (or I didn't understand... blush.gif)

Posted

Xtrim!

---"You are telling me that i need another form tag inside the inline tag"

From what you posted:

"[fmp-record]

<input type=text name="realation::comments" value="[FMP-Field: realation::comments ]" size=20 maxlength=51>

[/fmp-record]"

looks like you a generating/finding a "list" of records whose output(comments) will be populating values into a form field....well, now, your output will look like this:

----results.html------------

1.[some comments here]

2.[another comment of differenet record]

3. [then some more]

....

..

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

so I am guessing that these results would be then changes and submitted with a change (updated/edited) right?!

Therefor you need a

<form> "arround" the

<input type=text name="realation::comments...>

</form>

to subit the changed. So , yes u do need another form tag that will submit those changed to eg. RecordEdited.html.

All the best!

Posted

sums up to:

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

[fmp-inlineaction:-db=DB_B.fp5,-lay=main,ID={fmp-field:id},-max=all,-find]

[fmp-record]

<FORM ACTION="FMPro" METHOD="post" name="EDIT">

<INPUT TYPE="hidden" NAME="-RecID" VALUE="[FMP-currentrecid]">

<INPUT TYPE="hidden" NAME="-db" VALUE="Your_DB.fp5">

<INPUT TYPE="hidden" NAME="-lay" VALUE="your_layout">

<INPUT TYPE="hidden" name="-format" value="Record_Edited.html">

<input type=text name="realation::comments" value="[FMP-Field: realation::comments ]" size=20 maxlength=51>

<input name="-edit" type="submit" value="Update"> <input name="Reset" type="reset" value="Reset">

</form>

[/fmp-record]

[/fmp-inlinneaction]

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

Posted

Ok... I tried it but DW4 reports an error when I try to insert another form tag in the page... mad.gif

But the outputs seems fine anyway... only the buttons in the Master form r not working....

Do I have to put a submit button in each record ? Can't I make one submit button for all the records (like portal)?

Relevant Parts of my page :

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

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

<INPUT TYPE="hidden" NAME="-Lay" VALUE="WebMain"> <INPUT TYPE="hidden" NAME="-Format" VALUE="unit_slist_reply.htm">

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

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

[fmp-inlineaction:-db=units history.fp5,-lay=web,owner1_owner2={fmp-field:username},-max=all,-find]

[fmp-record]

<FORM ACTION="FMPro" METHOD="post" name="EDIT">

<INPUT TYPE="hidden" NAME="-RecID" VALUE="[FMP-currentrecid]">

<INPUT TYPE="hidden" NAME="-db" VALUE="units history.fp5">

<INPUT TYPE="hidden" NAME="-lay" VALUE="web">

<INPUT TYPE="hidden" name="-format" value="unit_slist_reply.htm">

<input type=text name="comments" value="[FMP-Field:comments ]" size=20 maxlength=51>

<input name="-edit" type="submit" value="Update">

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

</form>

[/fmp-record][/fmp-inlinneaction]

<INPUT TYPE="submit" NAME="-Edit" VALUE="Save Changes">

<INPUT TYPE=reset VALUE="Clear Changes"></center>

</FORM>

Posted

Xtrim:

"Do I have to put a submit button in each record ?

Can't I make one submit button for all the records (like portal)?"

there was a post on this...Update/Edit all records at ones..but this I would not suggest since ur updating many records at oens ur more likely to generate errors in the file. so yes update 1 record at the time...otherwise u will need to look up some JavaScripting

about the forms:

I thought u wanted just the "units history.fp5" to be updated!

where did this come from "<INPUT TYPE="hidden" NAME="-DB" VALUE="web users">" and why u have this entire new form at all?

all the best!

Posted

Hi, tnx 4 the quick reply...

I just showed you main parts from my page.

In the main form I have some fields that are from "Web Users" DB, and in the inline from "Units History".

Anyway the main reason I need one button is because the list can be hundreds of records, Plus it is a waste of space....

But from the other hand, portals are much slower then inlines... I have to think about it.... smirk.gif

Posted

"Anyway the main reason I need one button is because the list can be hundreds of records, Plus it is a waste of space.... "

waste of space? smile.gif what space..in HTML..thats no waste...waste is when u wait for 10 minutes for ALL the records to update and then u get the "middle finger" from the FileMaker saying that has been a problem updating records and now u have 1/2 of it updated and other ...Good Knows what happend........that, I would call "waste"

If u are concerened with 'the space' and design you can always use a small icon-images for the Submit-Reset buttons. The only waste I could see it the time invested into updating all these records 1 at the time...then again u create them 1at the time soooo...

anyway here is something that might be worth reading

.: OLD POST :.

all the best!

This topic is 7895 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.