How To Create A Count Timer

jothis

Active Member
Licensed User
Hi Friends

I Have A Program That Include Login Page And I Want Add A Login Count That Means If A user Logined i have A field In My Database Named count And Here I want To Add Count eg::if aru is logined first time iwant to add count as 0000000001,Then He logined Again Then The Next Count is 0000000002 Next is 0000000003

Any One Can Help Me?

Jothis
:sign0085:
 

jothis

Active Member
Licensed User
But How is possible Like 0000000001

But How is possible Like 0000000001,0000000002
0000000010 and 0000000100

Is It Possible
Help me
jothis
:sign0085:
 

jothis

Active Member
Licensed User
But I want to add a string in fornt of it

thank you for helping me klaus

But I Want To Add A String in front of it LIKE LOGIN0000000001 Is It Possible?

Please Help me
I attached My code here
jothis
:sign0085:
 

Attachments

  • Counter.zip
    895 bytes · Views: 182

klaus

Expert
Licensed User
Longtime User
Yes, it is possible.
From the database you get LOGIN0000000001 in the variable LoginVal
Then
LoginCounter=SubString(LoginVal,5,StrLength(LoginVal)-5) ' removes the 5 first characters to get the count number
LoginCounter=LoginCounter+1 ' adds 1
LoginVal="LOGIN"&Format(LoginCounter,"D10") ' modifies the counter text



Attached one solution.

Best regards.
 

Attachments

  • COUNTER1.sbp
    1.8 KB · Views: 187
Cookies are required to use this site. You must accept them to continue using the site. Learn more…