[FX.php List] FW: Records being deleted from Query

Pete Jag sujag2100 at yahoo.com
Wed Mar 8 18:52:37 MST 2006


I have seen this same problem in FM6.  I still have
not figured out why?

--- Dale Bengston <dbengston at preservationstudio.com>
wrote:

> Rob & Joe,
> 
> A refresh re-loads a page just as it was loaded the
> first time,  
> including any post or get action that took place
> when the page  
> loaded. Thus any find will take place again, any
> edit will be  
> repeated, and any new-record creation will happen
> again. This is  
> expected behavior, even though it can cause unwanted
> results...  
> particularly with new record creation.
> 
> I can't imagine how a refresh could delete records
> all on its own.  
> Unless the page is specifically telling the FMP
> table to delete the  
> record (by record ID), how could this happen? And
> then, it couldn't  
> delete anything on refresh, because the refresh
> would re-post, and  
> fail when locating the record by ID the second time.
> And it could  
> only delete one record at at time, based on record
> ID match, not  
> multiple records.
> 
> Are the records really deleted, or are they somehow
> just no longer  
> being retrieved from FMSA on refresh? Can you find
> them if you log  
> into FMSA with an FMP client?
> 
> 
> Hope this gets the thought process going,
> Dale
> 
> On Mar 8, 2006, at 2:34 PM, Rob H. Christensen
> wrote:
> 
> >      Don't know about that one exactly, but I do
> get some unwanted  
> > effects
> > when refreshing pages. I have a page, which shows
> the result of an  
> > update of
> > data in the database. When this resultpage, which
> contains the  
> > actual edit
> > page with an include showing the result, is
> refreshed the edit is  
> > repeated.
> > But this is in FMP 6 Unlimited.
> >
> > Rob
> >
> >
> > On 06/03/06 19:46,
> "fx.php_list-request at mail.iviking.org"
> > <fx.php_list-request at mail.iviking.org> wrote:
> >
> >> From: "Scarpetta, Joe" <JScarpetta at NFPA.org>
> >> Subject: [FX.php List] FW: Records being deleted
> from Query
> >> To: <fx.php_list at mail.iviking.org>
> >> Message-ID:
>
<B826EE602644074BA6BA48C9BD9732CF084BFA1D at email.nfpa.org>
> >> Content-Type: text/plain; charset="us-ascii"
> >>
> >> Hello all,
> >>
> >>  Is there a condition when querying a table using
> FX and Server  
> >> Advanced
> >> 8.v2 where records get deleted from FileMaker if
> you refresh the  
> >> page.
> >>
> >>
> >>
> >> I'm not doing any updates to the tables, just
> displaying a set of
> >> records based on a find.
> >>
> >>
> >>
> >> Any feedback appreciated.
> >>
> >>
> >>
> >> Thank you,
> >>
> >>
> >>
> >> Joe
> >>
> >>
> >>
> >> Joe Scarpetta
> >>
> >> IS Consultant
> >>
> >> NFPA
> >>
> >> jscarpetta at nfpa.org
> >>
> >> 617.984-7572
> >>
> >> -------------- next part --------------
> >> An HTML attachment was scrubbed...
> >> URL:
> >>
>
http://www.iviking.org/pipermail/fx.php_list/attachments/
> 
> >> 20060306/2f14f9b0/att
> >> achment-0001.html
> >
> >
> > _______________________________________________
> > FX.php_List mailing list
> > FX.php_List at mail.iviking.org
> >
> http://www.iviking.org/mailman/listinfo/fx.php_list
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 


More information about the FX.php_List mailing list