Newbies RolandT Posted March 25, 2008 Newbies Share Posted March 25, 2008 I’ve a FMpro 9v03 database where i’ve used in a script the function ‘Get useraccount’. The result of the function is always ‘Administrator’ even if another user connecting the database. In the list of the accounts&privileges are many different users with a name that match the names of the employees in the database. The database hold information about the absent of many employees. I want to make a startup-script that give employees the possibilities to view their own information (without viewing the rest of the information of the other employees). Can someone tell me why the function ‘Get useraccount’ don’t give me the name of the account who’s visit the database? Thanx for your awnser Roland Tempels [email protected] Link to comment Share on other sites More sharing options...
Steven H. Blackwell Posted March 25, 2008 Share Posted March 25, 2008 What are you using, Get(UserName) or Get(AccountName)? There are two different function. Get(AccountName) should return the name of the Account that opened the file. Steven Link to comment Share on other sites More sharing options...
Newbies RolandT Posted March 26, 2008 Author Newbies Share Posted March 26, 2008 (edited) Thank you for the awnser. I use get(accountname). When i login with a accountname and password (know by accounts & privileges of the database)the result of 'get(accountname)' = Administrator, always! I use a calculation field (global) with 'get(accountname)' to see the result, and also a script with the same function to find the user who's open the database with the same name in the database to give personal information. Edited March 26, 2008 by Guest Link to comment Share on other sites More sharing options...
librone Posted March 26, 2008 Share Posted March 26, 2008 Hi Roland don't use global field. Ann Link to comment Share on other sites More sharing options...
Newbies RolandT Posted March 27, 2008 Author Newbies Share Posted March 27, 2008 Ann, the global option is turned off now but the result is the same. the database is transformed from FM version 6 to version 9. Could it be possible that in such case the get(accountname) doesn't work anymore? In version 6, i didn't use this function. thank you for you help, Roland Link to comment Share on other sites More sharing options...
librone Posted March 27, 2008 Share Posted March 27, 2008 set unstored field. Ann sorry for my English Link to comment Share on other sites More sharing options...
Newbies RolandT Posted March 27, 2008 Author Newbies Share Posted March 27, 2008 Ann, you are the one! Good knowledge don't need many (English) words. It works! Merçi beaucoup. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5897 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now