DriveWorks Pro 22

Document Rules: ODBC Data Export

Document Rules: ODBC Data Export

DriveWorks can export data into a database, control fields determine if a row is inserted, updated, or ignored.

ODBC Data Export

ODBC Export Rows Rules

The document name rule is used to determine the name of the new document, or to prevent the document from being created.

• If the values in the control fields of a row do not match an existing row in the database then DriveWorks will insert a new row.
• If the values in the control fields of a row match an existing row in the database then DriveWorks will update the existing row.
• If any of the values in the control fields of a row are blank, then DriveWorks will ignore the row.

  Rule	Meaning
  ""	When applied to a field which is also a control field the data export will not occur. When applied to a field which is not a control field, but the database settings on that field expect a numeric value the data export will not occur. When applied to a field which is not a control field and the database settings on the field expect a string then an empty string will be passed into the export row.
  DWVariableTotalQty	Reports the result of the variable TotalQty into the field.