Sage 100

I have a client that needs to delete a range of records (date = YYYY/MM/DD) because they are records that were not cleared out of the table before restarting in Sage again.  This involves a couple hundred records, so deleting from DFDM would be cumbersome.  Are there any ramifications from deleting records from within the SQL DB?

------------------------------
Jane Scanlan
Partner, Next Level Manufacturing Consulting Group
Chanhassen MN
952-210-7758
------------------------------

What table?  Direct SQL edits are the same as DFDM... do them only when you are sure, checking other tables for orphaned records (like SO header, SO detail...).
Be extremely careful with "delete from..." scripts because it is so incredibly easy to miss something in your "where..." and there is no undo. 
Right-click Edit... is safer because you can see what you are deleting.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

Thanks All!

------------------------------
Jane Scanlan
Partner, Next Level Manufacturing Consulting Group
Chanhassen MN
952-210-7758
------------------------------

Original Message:
Sent: 09-20-2021 08:04
From: David Overholt
Subject: Is it OK or not OK to delete Sage100 Premium records from within the SQL database

Jane,

In my humble opinion. Deleting records through SQL is basically the same as deleting them using DFDM and comes with the same risks.  Although with SQL you can easily delete multiple records so you run the added risk of accidentally deleting too much. As always backup, backup, backup.

 

 

 

 

 

Thanks

David Overholt

DWD Technology Group, Inc.

9921 Dupont Circle Drive West, Suite 300 | Fort Wayne, IN 46825

260.423.2414 main

800.232.8913 toll free

sagesupport@dwdtechgroup.com

www.dwdtechgroup.com