User Forum
Xequte User Forums
Profile    Active Topics    Forum FAQ    Search this forumSearch
     
Forum Tips
» This forum is for users to discuss their software problems and suggestions for improvement.  Remember that only a tiny percentage of our users experience such problems (To be precise less than 0.7% have ever posted on this forum)
» Include your software version number (as displayed in the About Box)
» Check the FAQ before posting as most common questions have already been answered
» You don't need to also e-mail us separately as our support team will respond to all questions on this forum
 
 All Forums
 Xequte User Forums
 MailList King
 Delete history records after so many days

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

Size 
UserName:
Password:
Mode 
Format  BoldItalicizedUnderline Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkInsert EmailBrowse for an image to attach to your post Insert CodeInsert QuoteInsert List
   
Message 

 

Emoji
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Black Eye [B)]
Frown [:(] Shocked [:0] Angry [:(!] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
Bruce23 Posted - Aug 02 2012 : 11:23:28
How do I set the history to automatically delete records after 30 days or so many days. This would help with the size of MLK.
Thanks
7   L A T E S T    R E P L I E S    (Newest First)
xequte Posted - Sep 08 2013 : 12:50:12
Hi

Try using the database utility I mentioned in your other post:

http://www.xequte.com/forum/topic.asp?whichpage=1&TOPIC_ID=3401


Repair, then optimize the database. You can then delete entries in bulk from the table using SQL (e.g. DELETE from MLK_HIST where "Date"<'2013-08-15')

Nigel
Xequte Software
www.xequte.com
nigel@xequte.com
geb Posted - Sep 08 2013 : 06:00:36
Hi

I set months on all options to 0 and optimized but when checking all the history was still there
Db still hangs

I sure its corrupted and I've had to force close it
geb Posted - Sep 08 2013 : 05:39:36
Hi Nigel

I made a incorrect import of a large list +100k's . I want to try and delete the history and the options described above only allows for deletion after months and not days
The system is unresponsive I've optimized the database
How do I get rid of this uneeded history in the database that is hanging the system
xequte Posted - Aug 06 2012 : 00:41:25
Sorry, you must be using an older version.



Nigel
Xequte Software
www.xequte.com
nigel@xequte.com
Bruce23 Posted - Aug 04 2012 : 21:02:31
Found it under File / Optimize Database /
not view/
Maybe you are thinking of a different version.
Thanks Nigel
Bruce23 Posted - Aug 04 2012 : 20:59:04
Under View / Options/ I see no link to a database. Can you upload an image for me. I tried to upload the image of my mlk to show you there is no database link, but the upload failed.
No link to a database under view/ options/ thanks.
xequte Posted - Aug 03 2012 : 00:28:10
Hi

Please select View > Options, Database and check the box to automatically optimize the database. Click Settings and configure the History option.



Nigel
Xequte Software
www.xequte.com
nigel@xequte.com