×

Special Instructions: Bumping M1 Tables To Force Field Population

Using Microsoft SQL SMS against your M1 database, run the following query:

Update [TABLENAME] set [COLUMNNAME] = [COLUMNNAME]

The [TABLENAME] and [COLUMNAME] fields are expected to be replaced with appropriate data. The column that you use for this "bumping" is not important; it simply needs to be in that table. For example, if you wanted to "bump" the Parts table, your query could look like this:

Update Parts set impPartID = impPartID