-
I would try creating a new data connection - modify the SQL to call the stored procedure, and just try the data connection as is (the new one) to see if data is returned to the form. Put the data fields from the new connection on the form so you can see if data is returned. Compare the schemas of the original data connection to the new one to see ...
-
still no luck after clearing the datatype errors. no more errors, but still no data. the command is reporting success in the execution history and examining packets sent to the server shows that the SQL statement is being sent, however the server is not receiving the data.
-
I think this formula would be valid and may be what you are trying to achieve:
substring(xdMath:Eval(xdMath:Eval(xdXDocument:GetDOM("LeadManagers")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[contains(xdXDocument:get-DOM()/my:myFields/my:DocInfo/my:Matrix, d:Discipline2)], 'concat(d:GrantAccess/pc:Person/pc:AccountId, ...
-
Ok. I don't know the full XPath to either your secondary data source node or to your main data source node where you currently have the default value from the 2ds - but the code after you run the SQL query might be something like:
XPathNavigator secDSNav = ...
-
Hello
According to my previous question (https://www.infopathdev.com/forums/t/40434.aspx) about (converting separate string fields to separated emails in a text box field)
and very good solution I have received I have problem in using Eval function in my form (Attached). when I use below code in field1 of my form: ...
-
Oh, I hope so, before this form kills us both. :)
-
on re-checking, the old form has the same error. Apologies, this form is giving me brain damage I think. I did however get a new error about datatypes when trying to run:
The query cannot be run for the following DataObject: approvers
InfoPath cannot run the specified query.
[0x80040E07][Microsoft OLE DB Provider for SQL Server] Error ...
-
I take it that is from the copy of the template I gave you? In your original, it was still succeeding?
-
the modifysqlquery command was succeding before. now It returns the following error:
ModifySqlQuery error: InfoPath has encountered an error. The operation failed. The form's code contains an error. The following call in the form's code failed: ADOAdapter.Query Operation aborted
-
Can you put the QdabraRules execution history on your form and verify that the Modify SQL Query command for the approvers data connection is returning success? The command is supposed to execute the query, but if GetXml /dsname=approvers isn't returning any data, that would indicate there is no data being returned to the form... I also noted ...