InfoPath Dev

That doesn't give an example of receiving parameters from stored procedures. I just get an error stating that Command.Parameters is invalid.

I have the following code below, however I cannot access the @RETURN_VALUE of the stored procedure, any ideas: XDocument.QueryAdapter.Command.Parameters.Append(XDocument.QueryAdapter.Command.CreateParameter(''@RETURN_VALUE'',3,4)); XDocument.QueryAdapter.Command = ''execute createPickup ''' + driverName + ''',''' + registration + ...

I have an Infopath form that receives 100 rows, to display this on the UI at the same time causes perfomance issues therefore I have two datasets, one to store the information in the background (memory) and one that is bound to the UI. I only show 10 records at a time and thus have controls on the form where a user can request the next 10, ...

I have now figured it out, the problem was that the repeating group had been created once when the parent node (i.e my:Results) had originally been created, however there were other elements below the repeating group (i.e. my:Activity) that belonged to my:Results, therefore when I tried to add nodes to my:Activity I got a schema error as the node ...

I have the following structure (simplified for this illustraion): my:Fields my:Results jobid address postcode my:Activity type serialnum action I am trying to dynamically call a stored procedure to produce the my:Activity elements if the jobid from my:Results returns any elements when calling the stored ...

Many Thanks I look forward to the document.

Is there anyway of only returning the top 50 rows from a query, but giving the user the option to ask for the next 50 when required, using SQL server and a view? I know I can use the top statement in SQL however I need to make this dynamic i.e. user clicks on a button and requests rows 0-50, 51 to 100 etc. I know Infopath is really slow when ...

Many Thanks for the quick reply, your response was correct.

I have 3 web services as secondary connections that I wish to call, however I need to set the paramaters (accessed by somehow changing the queryField elements of the data connection) before querying the web service. I can access the DOM of the secondary connection, however I cannot set the individual parameters. When viewing the doms text (by ...

I have now fixed the problem. tgo you are right I stated that I inserted a row and then checked to see if it was a success or failure, however I should have stated that a row only gets inserted if the request is successful. I started a fresh infopath form and instead of using Submit and retrieve, I just used retrieve. Many Thanks for your ...