InfoPath web form: How to check a value of user i/p field against the value in SQL table

Last post 12-26-2012 12:35 AM by Mel Clemente. 1 replies.

Page 1 of 1 (2 items)
	Sort Posts: Previous Next

11-06-2012 12:18 PM

nemo385
Joined on 07-16-2012
Posts 22

InfoPath web form: How to check a value of user i/p field against the value in SQL table

Reply Contact

Hi,

I have a web based IP 2010 form that has a n ID field which is a textbox. When a user enters an ID in the textbox, I want to first check if that ID is in the SQl table or not. If yes then only fetch the values in some other fields. Else display a custom error message saying the ID doesn't exist. Please let me know how could I achieve this? Thanks.

Filed under: webservice, infopath 2010, share point 2010, web based form

12-26-2012 12:35 AM In reply to

Mel Clemente
Joined on 08-07-2008
Philippines
Posts 340

Re: InfoPath web form: How to check a value of user i/p field against the value in SQL table

Mark as Not Answer Mark as Answer ...

Reply Contact

I believe you will need a web service for this. Try Qdabra's DBXL web service - it has a method called QueryDB. You can add rules to your ID field that queries SQL with that specific ID. A free trial is available here. Contact us if you need further assistance setting it up.

Mel Clemente
Qdabra® Software/ InfoPathDev.com
The InfoPath Experts – Streamline data gathering to turn process into knowledge.™

Page 1 of 1 (2 items)

InfoPath Dev