Aaaah!
Compilation error with the second option was a typo by me. Second option works
the same as the first.
The reason appears to be that if the database has a NOT NULL condition this
takes precedence over the validation routine ie validation test does not take
place and the update is ignored. Also I redid the validation just to test if
the field was under 4 in length. I then shortened the field to 3 chars.
Validation worked fine ie I got the error message and the save was cancelled
BUT the working data stayed at the shortened field even if I moved to other
records and returned. I assume that this means that if I get an error in the
validation routine I should do a requery.
Rodgy
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/[EMAIL PROTECTED]
