Chapter 32. V9.07
32.8. New erpcustom [ADDTODB] script: erp_duplicatecheck.vbs
Prev  Next

32.8. New erpcustom [ADDTODB] script: erp_duplicatecheck.vbs

Problem Description [195]

When the Add dataset to link database button is used another time on the same line, with the same material selected, then a duplicate is created.

Also with yellow range fields, this could happen, especially if export timestamp is activated.

Solution

You can find a new script erp_duplicate_check.vbb in $CADENAS_SETUP\scripts\erp.

If the script shall be used, activate it in $CADENAS_SETUP\erperpcustom.cfg, in the [ADDTODB] section.

If not existing yet, insert the key as follows:

[ADDTODB]
erp_duplicateCheck=$CADENAS_SETUP/scripts/erp/erp_duplicate_check.vbb

The script makes a select statement to check for duplicates with this settings:

  • prj_path,line_id

  • all ERP-fields that are asked in the current dialog (material, surface, ... whatever is activated here)



[195] #38345

Prev Up Next
32.7. Column sequence adjustable role dependent Home 32.9.  Key "HiddenItemToolbarEntries" - Set buttons in search result list visible or hidden via configuration file