InfoPath Dev

Greetings, I created a stub form that has some C# code in the FormCode.cs file for the FormEvents_Loading event.  It runs fine locally (from the designer) but when I try to import it into DBXL by following the getting started with DBXL guide, I start getting the below error.  Wondering if I need to "publish" the file to some ...

Figured it out.  See here for an answer: http://www.infopathdev.com/forums/p/25249/87602.aspx#87602

Hilary, That was what I needed! :)  My code is below in case anyone else tries something similar.  Basically I use the DBXL AD Service (as a Data Control in my form) to find the department of the current user, then I query my DB Stored Procedure to get a New Form ID. I "only" do this if the Form is "new". ...

As a follow-up... I read this description of the classes: http://msdn.microsoft.com/en-us/library/microsoft.office.infopath.dataconnection.execute(v=office.14).aspx When you "Execute" are the results only bound to a field automatically, in that you can never iterate over them programatically?  The complete and total lack of any ...

Greetings, I have a stored procedure on my SQL Server 2008 that I have tested as working fine by SQL Queries etc..  It does some business logic but end result is it returns a varchar(8) as an OUTPUT parameter.  I am attempting to call that SP from Infopath via the OnLoad method of the form (C# format) and then show the result in a ...

Hilary, How do you read the results of the query and use it in your InfoPath Form?  After the .Execute() how would you see what came back from the DB? Thx, Rob

Thanks Ernesto. Still learning but I am close to solving this.  What I did was create a lookup table in SQL that keeps track of the "Current" index number for the Request ID.  Then I created a Stored Procedure on SQL Server that queries that table, increments by 1 and creates the base "AbsenceRequest" row using that ...

Greetings all,  I am now 25 minutes into my learning for Infopath/DBXL and am starting to put some effort into designing my first form.  My goal is to figure out a way to pre-populate a read-only field with an "ID" number and have that ID number guaranteed to be unique for the form and also (preferably) to be selected from a ...