dbTalk Databases Forums  

Interesting Multi-user behaviour

comp.databases.filemaker comp.databases.filemaker


Discuss Interesting Multi-user behaviour in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
FP
 
Posts: n/a

Default Interesting Multi-user behaviour - 09-22-2005 , 11:23 PM






I came across this today and just thought I'd let people know.
I'm on OS 10.3 with FMD7 but I think this should also work on Windows.

- created file A
- set it to multi user
- selected open remote
- saw my computer listed under local hosts & clicked on it
- saw file A & clicked on it
- a new window opened, my FM was both Host & Guest
- put Get(MultiUserState) & Get(UserCount) calcs on the screen just to
be sure

- thought I'd try something stupid
- told file A (the non guest version) to switch to single user mode
- it did it and told me the connected users aren't getting kicked off
until I close the file
- however Get(MultiUserState) now said 0 (single user) and
Get(UserCount) said 2
On import I usually only test the MultiUserState, I guess now I'll also
be testing the UserCount

Another interesting thing I noticed, I have a MAIN table with 1 record
for things like registration code, registration name, number of users
allowed etc. Instead of creating relationships to obtain the related
data, I just created global calcs since they can be referenced from
anywhere. So when a user registers the company name changes and so
does the company name global calc.
This works until your in multi-user mode;
- user 1 logs in
- user 2 logs in, runs the registration, text and global calc both
update on version OK
- user 1's copy has not updated (to be expected)
- user 2 closes files (order is important)
- user 1 closes files
- some user opens the files, the registration text field is updated but
the global calc is not

FM seems to remember the value in a global calc at the time the files
are closed which may not be correct. It does not recalculate them
until a source field is modified.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.