[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Double jeopardy when a NO-UNDO temp table violates a uniqueness constraint

[bronco]

if I delete just the record I don't get the error anymore. define temp-table tt no-undo field c1 as character field c2 as character index c1 as primary unique c1 . create tt. assign tt.c1 = "1" tt.c2 = "1". create tt. assign tt.c1 = "1" tt.c2 = "2". catch err1 as Progress.Lang.Error : MESSAGE 'err...' VIEW-AS ALERT-BOX. delete tt. end. finally: MESSAGE 'done' VIEW-AS ALERT-BOX. end.

Continue reading...