Data Validation ? - InfoPath Dev
in

InfoPath Dev

Data Validation ?

Last post 11-25-2009 07:48 AM by AmyRayNai. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 11-05-2009 11:00 AM

    Data Validation ?

    Hi all. I'm starting to use IP 03. How can I verify that a value in a field is unique?  Basically, making sure that the value being submitted isn't already in the sql table.

  • 11-05-2009 10:16 PM In reply to

    Make a receive data connection for your sql table, Take one more textBox field and name it as result field and by default make its value false.

     Then write a rule on you previous field. In rule conditition select a specific column from your sql table and then check if your sql table column contains your field value, If yes then set your result field values as true.

    So now by your result field value you can know whether your entered text is already in the sql table or not.

  • 11-25-2009 07:48 AM In reply to

    Thanks for the response. What I ended up doing was made that field a unique one in sql. Easy enough. 

Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.