InfoPath Dev

I am working on creating a form that will be used for status reports for our company. I have a SQL table with all the info that I need populated into the form, this table I turned into an ECT in SharePoint and created an External List. The requirement for this form is that it must be an InfoPath modified SharePoint list form, we do not want a ...

Hello,  I currently have a web form published to a our SharePoint site.  I need a field that will auto-fill with the currently logged on user when it is opened.  I am able to use the userName() function in a text box, however our username format is FirtInitial+LastName.  I would like to be able to show the displayName so that ...

That worked!  Thank you for taking the time to help me out.  I was able to create my formula using the value returned from the stored procedure and I have the correct final value that I am expecting.  I appreciate your help.

My apologies.  I put it back and the command went through without error.  I'm still not clear on how I can see the value that should be returned.  I'm trying to understand, so forgive me if my question seems silly. I dont understand the var = rp... line that we entered.  ...

dc.Command = 'DECLARE @remainingPays smallint ' + 'EXECUTE "dbo"."VCS_SP_Remaining_Pays" \'' + HireDateV + '\', @Remainingpays OUTPUT ' + 'SELECT @Remainingpays as RemainingPays'; The only thing I changed from the code was making pays lowercase in @Remainingpays.  In the ...

I apologize if I dont completely understand.  @Remainingpays is set as the output in the stored procedure.  set @Remainingpays = (select sum(1)                          --as Remainingpays Are you lookiing for ...

dc.Query(); var ds = XDocument.DataObjects["PayPeriodsDataSource"].DOM; var rp = ds.selectSingleNode('dfs:myFields/dfs:dataFields/d:row/@Remainingpays').text; dc.Command = originalCommand;    // restore the original command to the data source

I put the 2 var codes after dc.query() and got the error below. The following error occurred: Object required File:script.js Line:43 Line 43 is var rp = ds.selectSingleNode('dfs:myFields/dfs:dataFields/d:row/@RemainingPays').text;

I tried the code snippet you gave me and it executed without error.  Thank you for that.  Now the next step I need to figure out is how can take the value that is being returned, @Remainingpays, and set it equal to, /my:myFields/my:RemainingPays?  @Remainingpays is not a column in any table, otherwise I would create that ...

yes.  It's just a button that I labeled "Refresh" and attached the code to the On_Click event.