InfoPath Dev

Please do not post the same question twice, it causes confsion. Your other Post is deleted. Thanks

I dont see any reason why your query is failing, did you try out running your query at the DB side. May be data is not getting returned by DB.

Hi, Error message clearly says that ''This discrepancy might be caused by the data source returning multiple rows when InfoPath expects only one.'' This means that the schema of the InfoPath form and the data that is returned by the database is different. You can try out the same thing using a secondary data connection, that will work. Now ...

This usually occurs because there is not match found. The actual stored value will be displayed as both Value and DisplayName when no match is found in the options source list. I am assuming your drop-down is populated from a secondary data source. So my initial inclination is that your data source is somehow different (filtered?) based on the ...

Is your attribute actually named ''@DB_Name.txt'' or ''@DB_Name''? You probably need to reference it according to its actually name... which likely does not include the ''.txt'' portion.

Hi, You can take a default XML file of your template and set ID value in that and throw that XML to the user. As the XML file will have the reference to template it will open direclty with your template. For code to throw XML files from webpage, please search in old forums.

Hi edove - It is customary in these forums to only post your question once. Double posting is unnecessary and splits the threads making it difficult for people to research an issue. Your duplicates have been removed.

Hi, You can actually set the ''@UserInfoName'' and ''@UserInfoCode'' in some other temperory fields and pass those values to Webservice. That means bind your webservice to take values from a teperory fields. When you want to submit data to webservice put the values that you want to submit in temperory fields using the code and you can call the ...

XDocument.DOM refers to the MAIN data source. When you start with a blank form and add the connection later, you are now working with a SECONDARY data source. You cannot access a secondary data source via XDocument.DOM. Instead you need to use XDocument.GetDOM(''Name of Data Source'').selectNodes(...);

Look at Tools | Default Values to make sure that the nodes those sections are bound to are present when you start a new form (i.e. the check box is selected). The other thing that concerned me was you said that you had the sections inside the layout table. The layout table for the particular row should have been inside the section -- not the ...