>If you have character expressions in your view, use PADR() to make sure that size of the filed doesn't change depending on data retrieved.
I used PADR(expr, LEN(field)) in the NVL expressions...
No, wait! I know! It's because there's a memo field in it.
Grr. I need to include that memo field as one of the editable fields on the form using the view. SET RELATION TO source table? Hmm...
Rich Addison, Micro Vane, Inc., Kalamazoo, MI
Relax, don't worry, have a homebrew.
- Charlie Papazian, The New Complete Joy of Home Brewing