SXSW

well I didnt want to use serial numbers thinking someone might be able to pick out a pattern.. but I did find this in another post... Let ( [ alpha = "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ" ] ; Middle ( alpha ; Ceiling ( Random * Length ( alpha ) ) ; 1) & Middle ( alpha ; Ceiling ( Random * Length ( alpha ) ) ; 1) & Middle ( alpha ; Ceiling ( Random * Length ( alpha ) ) ; 1) & Middle ( alpha ; Ceiling ( Random * Length ( alpha ) ) ; 1) & Middle ( alpha ; Ceiling ( Random * Length ( alpha ) ) ; 1) & Middle ( alpha ; Ceiling ( Random * Length ( alpha ) ) ; 1) ) that field is set to require unique so after the username field is set with that calc in a "create username" script I added... Commit Records/Requests If[Get(LastError) <> 0] Perform Script ["Create Username"] Exit Script [] End If so it runs till its passes validation. Seems to work great. thanks for the help.

After trying to create hundreds of records with this script, a pattern finally emerged... I have an auto-enter on creation username and password field that is supposed to create a unique random number with this calculation. Int(Truncate ( (Random * 100000000) ; 0 )) It appears it has been trying to create duplicate username/passwords, and upon validation it fails because it is not unique. Then it resumes to skips over the rest of the "New Contact" record creation script. No error, no dialog no nothing during validation. This would explain why it was only happening sometimes. I do need to figure out why the random number generator is not working correctly. Am I off base on my calculation? There has to be a better way to generate unique random username/passwords. Any help is appreciated. thanks

I have been experiencing random errors with scripts. It seems it is just randomly skipping script steps in different places on different client machines. Sometimes is works sometimes it doesn't. Like if I run it through script debugger it doesn't skip anything, but without it, it skips large chunks of the script. Does anyone have any insight on why this is happening? I have tried to rule out numerous things, like rebuilding the script, setting it to a different script, recovery, save compact copy, etc with no results. There is no connection or consistency to the error. Help... Please... Somebody?

you can try and set the error capture to on...and see what it tells you it might help you solve the problem

Does anyone know if there is a way to set accounts and privileges accross multiple files without having to key in the same set to every file? I assumed there was a way to do this and have been unable to do so, if not there should be it would save me a huge amount of time...help... anyone?

I am having some problems with the performance and stabilty of Filemaker server 7. It is in a medium sized buisness network enviornment and there are multiple users across a local network and vpn. I use remote desktop to manage and monitor the server. In the past few days I have had a high number of crashes (4 in 1 day) and numerous corrupted files. I have installed the upgrades, tried to optimize larger files, and saved compressed copies but the stability dosen't seem to have improved. I cant seem to pinpoint any circumstances that would cause the server to be so unstable. I was hoping to get some helpful hints or user experiences...