InfoPath Dev

I am using Query Builder to Query a SharePoint list (Form library).  I have added 33 columns to my query.  When I build my data connection, I only see 21 of the 33 fields lsited in the secondary data source.  I can’t figure out why some are missing.  I don’t see a trend.  Sequence, field name, field type does not seem to matter.  Ideas? 

My queries are included below.  As an example, 'ShaftLength_5' is NOT included in my datasource but 'ShaftLength_1', 'ShaftLength_2', 'ShaftLength_3' and 'ShaftLength_4' are included.

<query maxrows='2'><columns><column name='Phone'/><column name='Address_x0020_2'/><column name='Flex_x0020_5'/><column name='ShaftLength_5'/><column name='FNS_x0020_Samples_x0020_1_x0020_Qty'/><column name='FNS_x0020_Samples_x0020_2_x0020_Qty'/><column name='FNS_x0020_Samples_x0020_3_x0020_Qty'/><column name='FNS_x0020_Samples_x0020_4_x0020_Qty'/><column name='FNS_x0020_Samples_x0020_5_x0020_Qty'/><column name='Comments_x0020_Graphics'/><column name='Loc_x0020_Finish'/><column name='Project_x0020_ID'/><column name='Customer_x0020_Name'/><column name='Customer_x0020_No'/><column name='Customer_x0020_Contact'/><column name='Address_x0020_1'/><column name='Customer_x0020_City'/><column name='Customer_x0020_State'/><column name='Customer_x0020_Zip'/><column name='Country'/><column name='Project_x0020_Description'/><column name='UNFModel_1'/><column name='UNFModel_2'/><column name='UNFModel_3'/><column name='UNFModel_4'/><column name='UNFModel_5'/><column name='Flex_x0020_1'/><column name='Flex_x0020_2'/><column name='Flex_x0020_3'/><column name='Flex_x0020_4'/><column name='ShaftLength_1'/><column name='ShaftLength_2'/><column name='ShaftLength_3'/><column name='ShaftLength_4'/><column name='Sales_x0020_Contact'/><column name='Comments_x0020_Program'/><column name='Date_x0020_Start'/><column name=''/></columns></query>

concat("<query><columns><column name='Phone'/><column name='Address_x0020_2'/><column name='Flex_x0020_5'/><column name='ShaftLength_5'/><column name='FNS_x0020_Samples_x0020_1_x0020_Qty'/><column name='FNS_x0020_Samples_x0020_2_x0020_Qty'/><column name='FNS_x0020_Samples_x0020_3_x0020_Qty'/><column name='FNS_x0020_Samples_x0020_4_x0020_Qty'/><column name='FNS_x0020_Samples_x0020_5_x0020_Qty'/><column name='Comments_x0020_Graphics'/><column name='Loc_x0020_Finish'/><column name='Project_x0020_ID'/><column name='Customer_x0020_Name'/><column name='Customer_x0020_No'/><column name='Customer_x0020_Contact'/><column name='Address_x0020_1'/><column name='Customer_x0020_City'/><column name='Customer_x0020_State'/><column name='Customer_x0020_Zip'/><column name='Country'/><column name='Project_x0020_Description'/><column name='UNFModel_1'/><column name='UNFModel_2'/><column name='UNFModel_3'/><column name='UNFModel_4'/><column name='UNFModel_5'/><column name='Flex_x0020_1'/><column name='Flex_x0020_2'/><column name='Flex_x0020_3'/><column name='Flex_x0020_4'/><column name='ShaftLength_1'/><column name='ShaftLength_2'/><column name='ShaftLength_3'/><column name='ShaftLength_4'/><column name='Sales_x0020_Contact'/><column name='Comments_x0020_Program'/><column name='Date_x0020_Start'/><column name=''/></columns><filter><eq><column name='Project_x0020_ID'/><value>", xdXDocument:get-DOM()/my:myFields/my:Form_Details/my:Unique_ID ,"</value></eq></filter></query>")

SQL Server 2005

InfoPath 2007

MOSS 2007

Dual Server installation with SharePoint

Client:  Windows XP

Thanks

Hi Barb,

Is it possible that the missing fields are sometimes blank? The query that creates the data connection (the first one, without the concat) has a maxrows='2'. This means that (for performance issues while designing the form) it will only query two rows to get the sample schema. However, if there are blank fields in those two sample rows, then the full schema won't be derived correctly. For more info, please read this example. Since your data connection is not getting executed on load (i.e. you execute the concat query after the user has entered some information) then there's no harm in removing the maxrows parameter while designing your form (while creating the data connection). Can you try this?:

<query><columns><column name='Phone'/><column name='Address_x0020_2'/><column name='Flex_x0020_5'/><column name='ShaftLength_5'/><column name='FNS_x0020_Samples_x0020_1_x0020_Qty'/><column name='FNS_x0020_Samples_x0020_2_x0020_Qty'/><column name='FNS_x0020_Samples_x0020_3_x0020_Qty'/><column name='FNS_x0020_Samples_x0020_4_x0020_Qty'/><column name='FNS_x0020_Samples_x0020_5_x0020_Qty'/><column name='Comments_x0020_Graphics'/><column name='Loc_x0020_Finish'/><column name='Project_x0020_ID'/><column name='Customer_x0020_Name'/><column name='Customer_x0020_No'/><column name='Customer_x0020_Contact'/><column name='Address_x0020_1'/><column name='Customer_x0020_City'/><column name='Customer_x0020_State'/><column name='Customer_x0020_Zip'/><column name='Country'/><column name='Project_x0020_Description'/><column name='UNFModel_1'/><column name='UNFModel_2'/><column name='UNFModel_3'/><column name='UNFModel_4'/><column name='UNFModel_5'/><column name='Flex_x0020_1'/><column name='Flex_x0020_2'/><column name='Flex_x0020_3'/><column name='Flex_x0020_4'/><column name='ShaftLength_1'/><column name='ShaftLength_2'/><column name='ShaftLength_3'/><column name='ShaftLength_4'/><column name='Sales_x0020_Contact'/><column name='Comments_x0020_Program'/><column name='Date_x0020_Start'/><column name=''/></columns></query>

Thanks.

Perfect.  That fixed it.

Thanks