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

[Laura Stern]

Why aren’t you validating the buffer before the AVM tries to commit it to the TT. If it fails you delete it or ask the user for new values, or whatever. No error will get raised. Or what else would you do with the bad record? I don’t really understand your use-case. Why would you have an updatable table with NO-UNDO and not ensure that valid records are stored?

Continue reading...