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

[Dale Bengston]

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