"One or more field types are not installed properly. Go to the list settings page to delete these field" error from SPQuery

When using SPQuery often one might often encounter this error. This errror is caused because the field that you are refrencing in your CAML query is repersented differently internally. This can be because either you renamed a column or another site column with the same name exists.

Though the Display name of the column may be the say the internal column name can be different in SharePoint. SPQuery Fieldref requires the internal column name in order to perform the query. Remedies for this error are,

1. Use the U2UCamlQueryBuilder to re-construct the query and determine the actual internal field name or
2. Delete the field and recreate it.

Happy coding :-)

Form Services Limitations

Infopath 2007 has many new features and controls, however the following are the controls and features of Infopath 2007 that are not supported by Infopath Form services.

The controls that are not supported in Infopath Form Services are,
1.ActiveX control
2.Bulleted list control
3.Choice group
4.Choice section
5.Combo box
6.Horizontal repeating table
7.Horizontal region
8.Ink picture control
9.Master/detail control
10.Multiple-selection list box
11.Numbered list control
12.Picture control
13.Plain list control
14.Repeating choice group
15.Repeating recursive section
16.Scrolling region
17.Vertical label

The business logic features that are not supported in Infopath Form Services are,
1.Userroles

The security related features that are not supported in Form services are,
1.Restricted Security Level
2.Form Design Protection
3.Information Rights Management

The data connection features that are not supported in Infopath Form Servcies,
1.Query data from a Microsoft Office Access database
2.Submit data to a Microsoft Office Access Database
3.Submit data to a Microsoft SQL server database

The filling out forms features that are not supported by Infopath Form services,
1.Merge data from multiple forms
2.Export data to Microsoft Office Excel
3.Export data to Web
4.Ink support
5.Offline support
6.Spell checking
7.AutoSave, AutoRecover, or crash detection features
8.Custom task panes
9.Add-in menus

The view related features that are not supported in Infopath Form Services
1.Word print views
2.Multiple print views at once
3.Print Page breaks, headers or footers

The programming features that are not supported in Infopath Form services
1.Scripting
2.COM add-ins