Update the DBS

Snitz™ Forums 2000
https://forum.snitz.com/forumTopic/Posts/65538?pagenum=1
05 November 2025, 03:48

Topic


JJenson
Update the DBS
07 September 2007, 10:29


I am trying to write 2 siple scripts to go into the alternate mod setup. the first one is just supposed to keep adding one to the number everytime it is downloaded. would that be something like this?
[ALTER] MEMBERS
ADD#M_DOWNLOADED#int#NULL#1
[END]
The second one is just supposed to keep the last date something was downloaded would that be something like this?
[ALTER] MEMBERS
ADD#M_LASTDOWNLOAD#int#NULL#9\7\07
[END]
I don't want to add it in till I am sure but I think it is something like this?
Thanks<

 

Replies ...


JJenson
07 September 2007, 11:54


Nevermind got it the first one worked and the 2nd needed to be changed to

[ALTER] MEMBERS
ADD#M_LASTDOWNLOAD#VARCHAR(50)##
[END] <
Shaggy
07 September 2007, 12:26


You only really need 14 characters to hold a date; yyyymmddhhmmss.
<
JJenson
07 September 2007, 12:32


Thanks Shaggy smile<
JJenson
07 September 2007, 23:57


No worries I ended up getting it. smile<
© 2000-2021 Snitz™ Communications