BinaryWorks.it Official Forum
BinaryWorks.it Official Forum
Home | Profile | Active Topics | Members | Search | FAQ
 All Forums
 eXtreme Movie Manager 8, 9, 10 Forum
 Information
 Fix Movie ID

Note: You must be registered in order to post a reply.

Screensize:
UserName:
Password:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkInsert EmailInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
   

T O P I C    R E V I E W
alcohol Posted - 24 Oct 2014 : 19:24:17
Hello,

I have a database of 915 movies, all of them in 2 NAS servers X & Y. When i delete a movie and add another one, the movie id continue to increase in number instead of taking the deleted movie id. so far i have 915 movies and the latest id is 1018. is it possible by a function to reset all movie ids - without harming the database - and have 915 movies with ids from 1 to 915?

Thanks in advance
1   L A T E S T    R E P L I E S    (Newest First)
JDommi Posted - 24 Oct 2014 : 21:28:02
You can renumber by id. Have a look at the database tools of the menu (I hope I'm right with the menu as I'm @work just now).
But to prevent any possible error I would backup the whole database manually: http://www.binaryworks.it/cgi-bin/data/wiki/doku.php?id=backup_database

BinaryWorks.it Official Forum © Binaryworks.it Go To Top Of Page
Generated in 0.06 sec. Powered By: Snitz Forums 2000 Version 3.4.07