Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
AT() Function
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
AT() Function
Miscellaneous
Thread ID:
00012891
Message ID:
00012891
Views:
66
Hi all,

I am using Arnon's encryption routine to store the user name, password and user level delimited by comas in a single 45 character field, and padded to the right with a character expression ('*'). After the verification of user name and password passes, the value returned to my login function looks like this
lcLoginString = "jpaskett,ADMINISTRATOR,*******" with the paassword removed.

this.cUserName = LEFT(lcLoginString, AT(",", lcLoginString) - 1)
this.cUserLevel = SUBSTR(lcLoginString, AT(",", lcLoginString) + 1)
this.cUserLevel = LEFT(this.cUserLevel, AT(",", this.cUserLevel) - 1)

This works, don't get me wrong, it returns "jpaskett" and "ADMINISTRATOR" respectively. The AT() function will allow me to look at the second occurance of the ',' but I have been unable to get it to work! Does anybody know how I can clean up this code?

Thanks in advance
Jon
Jon Paskett

Microsoft Certified Systems Engineer
We all have to start somewhere...
Sometimes over again!
Next
Reply
Map
View

Click here to load this message in the networking platform