InfoPath Dev

Actually, I got curious and just tested this -- I tried using TOP to query a view in SQL Server Management Studio and it returned the 5 rows, as specified. Then I tried this as a SQL receive data connection in an IP 2007 form (editing the SQL command) and again had 5 rows returned. Could something else be preventing you from seeing the data you ...

The form is not going to automatically update your database. You'll have to have a submit connection to the database, and then either use that connection in your Submit Options for the form, or add another button with a rule to submit the data to the database. Without using a web service, the only way you'll be able to use the built in ...

I am officially completly baffled. Let me try to explain what I mean a bit better, and perhaps that will help us both. When doing your database mapping in DAT, on the left side we have a table or column, then on the right, the xpath to a form field that will provide the value for the column. We also have the option of selecting DBXL Mapping ...

And form id is mapped to DBXL Doc Id for all the tables in your mapping? 'Cause you shouldn't be getting a 'NULL' value for Doc Id....

I'm glad the tutorial helped! InfoPath (as you've just found out!) is a really powerful application -- this means it can also be really complex. Be sure to search the forum & post when you have questions -- there is a lot of valuable information and help here.

What I mean is -- in your database, the column Form ID -- do you have that set as an identity column? In SQL manager, if you right click the table and pick Design or Modify (depending on your service pack) the table opens in design mode. If you select the column, the column properties window will show the properties for it. Look for the ...

Here is a link to a how-to guide on Office Online -- one word of warning, it is probably using the Office 2003 version of Northwind -- as I recall, the 2007 version is a bit more complex and this tutorial may not work as written with it. Hope that helps!

Forgive me -- I"m not terribly familiar with Access data types. From a quick search, it looks like 'text' in Access is the equivalent of varchar in SQL, so it should be okay. Do you have any columns for images, or that are a 'memo' or 'long text' data type?

Well, the message is in the Submit Status -- submit is not allowed because you have columns in your data source with a large binary data type. You'll need to look at the tables you are using for your data source and determine which columns are large binary data types (note the submit status suggestion that they are 'text, ntext, ...

Okay, so your form has an email submit connection that is called main submit. If you don't plan to use that, you might want to delete it -- or you may just want to rename it to something like 'Email Submit' to make it more clear. We need to figure out why your connection to your database (probably the connection called 'Main ...