Announcement

Collapse
No announcement yet.

Auto Complete Validation

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Auto Complete Validation

    Hi,

    I'm trying to use an auto complete field to allow part codes to be entered into a quote in a multiple record form but I'm struggling to find a way to make sure they get validated against the lookup table - if no entry exists in the lookup part I need an error to show to inform the user. The field otherwise allows an incorrect part code to be entered and then a SQL error is displayed on commit. Is there any way to enforce a valid value being selected in an auto complete field?

    Thanks

    Neil

  • #2
    Actually no, at least not on this moment. In the onvalidate you always need to do a check on those fields. Within standard dropdowns this is not the case as you can only select valid values and can set a field to required.
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment


    • #3
      How/when does the OnValidate event fire? I've put a message in it for now just to see but it never seems to pop on the screen, when editing the record and clicking save it just drops back to the original screen with the original value in the field. Adding a new record just throws an SQL error and doesn't fire the message I put into the onvalidate event?

      Comment


      • #4
        Not all macro's are supported within each and every event. If you want to see something happening you sometimes need to use echo's. The onvalidate will be called everytime you click on update, insert or delete.
        Albert Drent
        aducom software netherlands
        scriptcase partner, reseller, support and (turn-key) development
        www.scriptcase.eu / www.scriptcase.nl

        Comment

        Working...
        X