cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
%3CLINGO-SUB%20id%3D%22lingo-sub-51781%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3ETable%20%26gt%3B%20Update%20should%20warn%20when%20column%20will%20fail%20due%20to%20List%20Check%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-51781%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3EWhen%20updating%20a%20target%20table%20that%20includes%20columns%20with%20a%20List%20Check%20property%2C%20the%20update%20on%20that%20column%20fails%20silently%20if%20the%20update%20source%20table%20contains%20items%20that%20are%20not%20in%20the%20target%20table's%20List%20Check.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20agree%20that%20the%20update%20should%20fail%2C%20but%20it%20should%20fail%20with%20a%20warning%20and%20an%20option%20to%20(a)%26nbsp%3Bremove%20the%20List%20Check%20before%20proceeding%20or%20(b)%20abort%20the%20update.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-51781%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CLINGO-LABEL%3EData%20Blending%20and%20Cleanup%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-51831%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20Table%20%26gt%3B%20Update%20should%20warn%20when%20column%20will%20fail%20due%20to%20List%20Check%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-51831%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EI%20phrased%20this%20poorly.%20The%20failure%20occurs%20when%20Update()%20is%20called%20from%20a%20JSL%20script.%20I%20have%20not%20tested%20whether%20the%20behavior%20is%20different%20when%20Table%20%26gt%3B%20Update%20is%20called%20from%20the%20menu.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
0 Kudos

Table > Update should warn when column will fail due to List Check

When updating a target table that includes columns with a List Check property, the update on that column fails silently if the update source table contains items that are not in the target table's List Check.

 

I agree that the update should fail, but it should fail with a warning and an option to (a) remove the List Check before proceeding or (b) abort the update.

1 Comment
john_madden
Level VI

I phrased this poorly. The failure occurs when Update() is called from a JSL script. I have not tested whether the behavior is different when Table > Update is called from the menu.