Online registration database.

[Ocean West]

[Mona, wrote:]

-A person will register for a course

-Fmp will then via a script check to see if that person has already

registered for that course

-If not, fmp via a script will then check to see if there is room in the

course or if the person needs to be placed on a wait list. This could be

a rather lengthy task (a few seconds) for larger classes.

Here is my problem - and actually, I don't know if it really is a

problem, I'm actually wanting clarification on this "theoretical"

problem AND if it really could be a problem, I need a solution.

Because this is on the web, multiple people could be hitting the site at

the same time, thus the script could be accessed by multiple people at

the same time. If this is the case, the script might be using erroneous

data or turn into an infinite loop if restarted by mutliple users.

So here are my questions:

1 - is a script hit by multiple users at the same time going to mess up

or does fmp somehow keep the script unique per user? (I am using globals

as fields - if this were opened as a multiple user file, the globals are

unique per machine.)

2 - If the answer to the above is "yes, the script is going to mess up",

how do I prevent this from happening?

[Anatoli]

I will worry about the script and global field. I think the global will be assigned to WebCompanion, thus to any user. Better is to use unique cookie.

Because of that I am avoiding scripts by calculating fields and relations. I have several applications on web and I am using only 2 scripts:

1. security evaluation to make sure no one messes with old posted order. That was because I did not used cookies.

2. In discussion forum I am shifting the value of last visit.

Hth.