Alpha Video Training
Results 1 to 3 of 3

Thread: Form viewing filtered table in network environment

  1. #1
    "Certified" Alphaholic Mike Wilson's Avatar
    Real Name
    mike wilson
    Join Date
    Apr 2005
    Location
    Grand Rapids, Michigan
    Posts
    4,200

    Default Form viewing filtered table in network environment

    This might better fit in General v7, but I placed it here, as it seems to be a design question. I'm exhausted searching for this answer.

    Could someone explain please how a user gets the correctly filtered table in in a Network environment with this situation

    One Table – Staff, One Form – F_Staff.

    Dick and Jane are in the system. Dick filters table- Staff to employee ‘X” . Jane filters table Staff to employee “Y” and opens the form F_Staff before Dick, who also opens F_Staff.

    Does Jane’s F_Staff display Dick’s filtered table because she opened the form before Dick and the time factor, or does the system have session/user identifiers in the background that assure alignment? Does it have something to do with code being read bottom-to-top? Is this something that needs to be worried about?

    What I am at endpoint wondering is whether it is needed for a network bound application to pattern events very carefully to assure there is no “stepping” on each other. In this case, is it better to pattern the filtering of the table through the open form which has the table-form session established, or can I open the table first with script, filter it, and then open the form, and be assured someone else's session has not interceeded?

    Thank you.
    Mike W
    __________________________
    "I rebel in at least small things to express to the world that I have not completely surrendered"

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: Form viewing filtered table in network environment

    In a networked environment, each user accesses the database in their own session. Each session has no knowledge of other user's activities so long as they don't encounter tables/sets opened exclusively. The exclusive use may be deliberate or caused by one session's activities which require exclusive use such as zapping, packing, etc.

    You have to consider data integrity issues such as two users accessing the same record, both editing the record, and both saving their changes. I believe the changes make by the user saving last will overwrite the first.

    You can simulate this activity on one machine by creating two databases which contain the same tables, forms, etc. Both databases can be opened, normal user activities such as querying and filtering a form can take place independently of each other.

  3. #3
    "Certified" Alphaholic Mike Wilson's Avatar
    Real Name
    mike wilson
    Join Date
    Apr 2005
    Location
    Grand Rapids, Michigan
    Posts
    4,200

    Default Re: Form viewing filtered table in network environment

    Thanks Stan,
    That gives some insight. I will create that scenerio of two users on my one machine, and learn some things, which makes me thankful to Alpha for allowing this.
    Mike W
    __________________________
    "I rebel in at least small things to express to the world that I have not completely surrendered"

Similar Threads

  1. Query on filtered table
    By trackmanpete in forum Alpha Five Version 7
    Replies: 1
    Last Post: 01-02-2006, 01:27 AM
  2. Filtered Combo Box from External Table
    By Tom Cone Jr in forum Code Archive
    Replies: 0
    Last Post: 07-21-2005, 05:46 PM
  3. Filtered browse on a form
    By Bill@TrackerSystems.com in forum Alpha Five Version 6
    Replies: 5
    Last Post: 11-19-2004, 07:19 AM
  4. First Record with a Filtered Form
    By Alan Lucas in forum Alpha Five Version 5
    Replies: 5
    Last Post: 06-03-2003, 06:37 AM
  5. viewing child records w/ an alternatew form
    By lmarini in forum Alpha Five Version 4
    Replies: 10
    Last Post: 02-20-2002, 05:04 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •