InfoPath Dev

I have an InfoPath 2010 form that I publish through the Administrator Approval path to the Sharepoint 2007 site.  There are approximately 15 fields that are promoted to be usable by Sharepoint.  However, there are six fields that don't work. The strange thing is that the XPath in Sharepoint is /my:CoASubmission/my:Main_Form/..... ...

OK, here is how we solved this problem.  Stored Procedure The stored procedure takes in a search filter parameter, along with the first and last page.  The result searches the synonym table and returns only those rows that are requested.CREATE FUNCTION [dbo].[SP_COA_LkpMaterialSynonym] ( @MsynFilter VARCHAR(2000) ,@FirstRow ...

OK, from my previous post, I've now implemented another button that does a search on our material database.  When I went to implement paging, however, I found that the ADO query processor doesn't understand the SQL Server WITH verb. Functional Requirement User enters a search criteria, and clicks search 1-20 rows are ...

 I inherited support for an application when the previous develper left the company.  I needed to restore the infopath project, because it is stored separately from the .xsn form. Based on a lot of feedback from this forum, I was able to put together the solution that works for what our button click event was supposed to do.  It ...