How to remove incorrect dates/data from the database

Started by KindOne

KindOne

How to remove incorrect dates/data from the database 31 March 2023, 15:43

Registered: 1 year ago
Posts: 2

A while ago I changed the date/time of my computer twice while NetWorx was running.

I've opened NetWorx.db3 in dbeaver (while NetWorx was closed) and I found my incorrect dates in the USAGE table:

9842	1	1	2020-07-31	19	13601987	55938480
9843	1	1	2011-01-01	19	249554		585685
9844	1	1	2020-07-31	20	492901		886965

10989	1	1	2020-09-28	2	4043281		18915736
10990	1	1	2003-01-08	2	4260776		38570974
10991	1	1	2003-01-08	3	6023729		118633959
10992	1	1	2020-09-28	3	1749692		899850

Can I remove these incorrect rows or would that possible cause any sort of issues?

Reply Quote

Andrew

Re: How to remove incorrect dates/data from the database 31 March 2023, 17:59

Admin
Registered: 18 years ago
Posts: 3 570

It is generally safe to delete them. But before doing that I recommend running this command:

PRAGMA foreign_keys = ON;

This will enable foreign key enforcement, so any deletion will also remove any linked data from other tables.

Reply Quote

KindOne

Re: How to remove incorrect dates/data from the database 31 March 2023, 21:10

Registered: 1 year ago
Posts: 2

It worked. Thanks.

Reply Quote

Print view of this page

Reply to this topic

Sometimes you can find a solution faster if you try the forum search, have a look at the knowledge base, or check the software user manual to see if your question has already been answered.

Our forum rules are simple:

Be polite.
Do not spam.
Write in English. If possible, check your spelling and grammar.

Author:

Email:

Subject

A brief and informative title for your message, approximately 4–8 words:

Disable BBcode in this message Disable smileys in this message

Help information

Spam prevention: please enter the following code in the input field below.

 **     **  **         **    **  ********  **     ** 
 **     **  **    **    **  **   **        **     ** 
 **     **  **    **     ****    **        **     ** 
 **     **  **    **      **     ******    **     ** 
  **   **   *********     **     **        **     ** 
   ** **          **      **     **        **     ** 
    ***           **      **     ********   *******

Enter the code:

Message:

How to remove incorrect dates/data from the database

Reply to this topic

Software Products

Online Store

Help & Support

Download

SoftPerfect