 |
Hazram
Wanderer
Joined: 24 May 2005
Posts: 71
|
 Posted: Thu Sep 01, 2011 5:58 pm
#DBDELETE
|
My xp / time tracking system stores current xp info every n seconds, and stores it to a database. To prevent this database from getting unnecessarily large, I have the following line in an OnConnect event to clear it:
#REPEAT %numrec("All", xp) {#DBDELETE %concat(%eval(%i-1), "xp")}
This works sometimes, but not always. In particular, it seems to work the first couple times after the database is created, then stop working.
Any thoughts? |
|
|
|
|
Hazram
Wanderer
Joined: 24 May 2005
Posts: 71
|
Posted: Sat Sep 03, 2011 6:45 pm
|
No help? I'd try to get some official support for this, using support@zuggsoft.com, but my last 2 missives to that address, sent 4 business days ago, have not elicited replies. What happened to 48 hour tech support?
|
|
|
|
|
shalimar
GURU
Joined: 04 Aug 2002
Posts: 4671
Location: Pensacola, FL, USA
|
Posted: Sat Sep 03, 2011 7:24 pm
|
Have you ever though of using a database variable instead?
You can set the default value to %null, then you can clear it at any time with #RESET.
I have a good example of this available in the package library under Discworld. (It goes on to show how much xo earned in various increments over the last session, displayed in the status window)
And please excuse Zugg, he and his wife are in the middle of settling into a new home. |
|
_________________
Discord: Shalimarwildcat
Last edited by shalimar on Sat Sep 03, 2011 7:30 pm; edited 1 time in total |
 |
|
|
Hazram
Wanderer
Joined: 24 May 2005
Posts: 71
|
Posted: Sat Sep 03, 2011 7:30 pm
|
Yep, I have. I've been working on exactly that. Thanks for the suggestion though.
And Shalimar, log on more often will ya? I'd like to learn some skills from you. 
I didn't realize Zugg had RL things going on; I do excuse the tardiness of tech support replies. |
|
|
|
|
kittyfish
Novice
Joined: 20 Sep 2011
Posts: 37
|
Posted: Sat Oct 01, 2011 3:03 am
|
Shalimar come back to Discworld, we miss you!
|
|
|
|
|
|
|
|
