|
|
|
|
Page 1 of 1
|
[ 6 posts ] |
|
how I can clean Activities with Status = 1
| Author |
Message |
|
Litus
Joined: Mon Sep 10, 2007 1:57 pm
Posts: 74
|
 how I can clean Activities with Status = 1 Hi,
How I can delete permanently the activities erased from MIG?
thank's
|
| Fri May 23, 2008 1:26 pm |
|
|
|
MiG Support
Site Admin
Joined: Mon Dec 06, 2004 4:24 pm
Posts: 2485
Location: Sweden
|
Re: how I can clean Activities with Status = 1 Since DBConnect can synchronize between several clients/databases it needs to know which has been deleted and which has just not been added yet. That is why a record is marked as deleted and not actually deleted. You can just delete them manually if you want, using SQL.
|
| Fri May 23, 2008 1:39 pm |
|
|
|
Litus
Joined: Mon Sep 10, 2007 1:57 pm
Posts: 74
|
Re: how I can clean Activities with Status = 1 Ok, so I delete all the data in activities and activitycategory,activityupdates with id X?
|
| Fri May 23, 2008 1:58 pm |
|
|
|
MiG Support
Site Admin
Joined: Mon Dec 06, 2004 4:24 pm
Posts: 2485
Location: Sweden
|
Re: how I can clean Activities with Status = 1 I don't follow. Your two posts doesn't seem to align. Didn't you want to clean out deleted activities?
|
| Fri May 23, 2008 5:29 pm |
|
|
|
Litus
Joined: Mon Sep 10, 2007 1:57 pm
Posts: 74
|
Re: how I can clean Activities with Status = 1 Yes I want to delete all this activities from DataBase. (Status = 1).
At this moment, after the delete I get more Id's to create activities with the random method.
thank's
|
| Fri May 23, 2008 5:44 pm |
|
|
|
MiG Support
Site Admin
Joined: Mon Dec 06, 2004 4:24 pm
Posts: 2485
Location: Sweden
|
Re: how I can clean Activities with Status = 1 Then you should just delete them with an SQL "DELETE * WHERE STATUS = '1'".
|
| Fri May 23, 2008 5:47 pm |
|
|
|
|
Page 1 of 1
|
[ 6 posts ] |
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum
|
|