InfoPath Dev

My form hits an SQL database, I want to check to see if a value entered into a text box already exist in the database.

Basically I want to make sure that the number (Member ID) is unique within the database.

Any Ideas?

Just ask the database if it has one already in there:

var query = "SELECT id from mytable where id=" + XDocument.DOM.selectSingleNode( "//my:id" ).text;

If it returns a row, then you know there is already an ID of that value in the database, if it doesn't you're in luck!

Hope this helps!

---------------
Matt Faus

I am not having much luck here, getting a debug error, says object expected. Thoughts?

Make sure your XPath is right. Also, if you get an object expected error, maybe that means that there were no rows that matched your criteria in the database, which tells you what you need to know.

What exactly is your error and could you give us the code snippet that is performing your query?

---------------
Matt Faus
InfoPath Dev Texas