Re: Why does database not open to the last record visited

On Jun 17, 10:27 am, bfako...@xxxxxxxxx wrote:
Great everybody, thanks.

Marc-Andre it sounds like yours is doing the same thing as mine. When
you said:

"One diffrence, though: it don't think I had a case where the file
would
reopen to the last visited record on the first try, and then revert to
the last modified record on second or third tries."

I probably wasn't clear enough - mine acts like yours. It almost
never goes to the last record visited on the first try.

But it is reassuring that someone else's setup exhibits the same
behavior.

Howard, I appreciate your weighing in, I've seen your name on this
forum a lot.

I'm not opening the file from a machine that is not the file's host,
where someone else has opened the file before me. I have a very
simple setup, not connected to the internet or any network or
anything. Disconnecting all opening and closing scripts does not
resolve it.

I'm not sure I was clear as to how to really test this. You have to
do a search for a record, then close the file and reopen it and see if
it comes back up to that record. Then you have to search for a
different record, close the file and reopen it and see if it comes up
to that new record. You can repeat it again a few times and see what
it does but that's the idea. With me, it will usually come up to some
previous record searched, not the last record searched.

I get the same problem if I'm not using a search to land on a record,
but am just flipping through records when all records are shown.

There is just something behind the scenes affecting the file either
whenever it is opened or whenever it is closed.

I would appreciate your further thoughts on this. In other words, do
Marc-Andre and I have a bug or setting off and should we therefore re-
install FMP; or, is this really something innate with FMP8.

This seems like major issue. It is logical to me that you want all
files to open to the last record visited, unless you tell it do
something else like a find &/or a sort. But in all my searching I
never saw it addressed in any FMP8 documentation or articles on
migrating from FMP 6 to 8, and I wonder if the folks at FMP are aware
of it.

It was such a priority for me that I spent a ton of time working on
this this over a period of months months, and I have a whole list of
things I tried to fix it without success.

The only thing that ever worked is to set up the related record
solution I referred to in my previous post.

However I guess I was hoping to find some setting or something in FMP,
rather than having to have a script and relationship in every database
I set up.

Your thoughts.

Alex

Interesting how different developers value different things. I don't
build a database without both and opening and closing scripts. They
serve a dozen functions that I need...loading preferences, making
backups, creating date-based records, loading global fields, loading
global variables, etc etc. Seems simple enough to add a few script
steps to save the last record viewed and load it on start up. No
relationship needed, just a script find.

I wouldn't classify it as a bug because it's simply a feature that you
want or expect that isn't occurring. How would you expect Filemaker
to behave in a multi-user environment? Do you want Filemaker to
expend resources "remembering" the last record viewed by each user for
each layout? Or each table occurence? Or each table? I'd prefer FM
to conserve resources and not assume what I want.
.

Relevant Pages

  • The nightmare begins...
    ... the data arrives back on the server, there is a script on the server ... I last really used FMP back when it was version 3 or 4 and have always ... TIA for any advice or suggestions you might have. ...
    (comp.databases.filemaker)
  • Re: Text File Output
    ... table you can import from any other fmp table as long as the data-types ... the same (textfield into textfield, ... create a script that imports the records. ... sourcfe and target file have the same names. ...
    (comp.databases.filemaker)
  • Re: Live byte count possible whilst *in* a field?
    ... Is it possible in FMP 6 and/or 9 to have a live byte counter? ... end loop ... I had to tinker with the script a bit and got it ... possible after the loop has been left) and needs to edit the message and to ...
    (comp.databases.filemaker)
  • Re: ? instant ? incremental ? interactive search
    ... Once the desired word or portion thereof is typed, script it so that clicking a button or pressing the enter key will run a script to find the results based on what has been typed. ... The related table would have to be reconstructed for each new word by adding a table row for just first letter, the first two letters, three letters, ... ... Can FMP be told to perform the search after each keystroke? ... Member, FileMaker Business Alliance ...
    (comp.databases.filemaker)
  • [SNS Advisory No.54] Active! mail Executing the Script upon the Opening of a Mail Message Vulnerabil
    ... SNS Advisory No.54 ... mail Executing the Script upon the Opening of a Mail Message Vulnerability ... LAC Co.,Ltd. ...
    (Bugtraq)