InfoPath Dev

Hi,  Every time my InfoPath form is opened, I want to populate Dropdown box with SQL Data. I have webservice which collects data from SQL Server and returns back. In Infopath, I created new Data Connection and consuming this webservice to get data. I also checked "Automatically retrieve data when form is opened". This way ...

swathip, Thanks for your reply. Your solution worked like a charm. This expression won't check for uppercase or lowercase. (Example: If i enter "infopath" and have "INFOPATH" already in repeating table then it wont display message. It considers as different values). I modified default value setting for ...

Hi, In repeating table, when user inserts new item, I want to check for duplicate record in repeating table. If user enters any existing record (e.g: "MaterialID") then display message box otherwise allow user to enter new Material ID. Any thoughts ?  Thanks is advance.

Shiva, Thanks for your reply. I was getting error because i am inserting many records in repeating table. I tried to enter different no. of records and monitored response time. Here is the results: For 500 records, Response time = 3 minutes. For 600 records, Response time = 4 minutes. For 700 records, Response time = 5' 50" ...

Hi,  I am using Infopath 2007. I am calling webservice and populate repeating table (C# code). It works perfectly fine when i have ~100 records. But when there are more records (~700),  application throws following exception: System.Runtime.InteropServices.SEHException External component has thrown an ...