Sumitting Forms connected to a database. Help!!!

Sumitting Forms connected to a database. Help!!!

Post by SnJhbmdlb » Fri, 25 Apr 2008 12:11:00


I created a form that has a datasource to a SQL Server 2000 database. When i
enter the informatin on the form and hit submit the form tells me that it
sucessfully updated the database.

If i query the table in the database there is a record that has all empty
fields except for the time stamp. When i enter information in the form again
and hit submit i get an error telling me that it cannot create a duplicate
record.

What am i doing wrong? Why is the form inserting an empty record in the
database table?
--
Thanks,

JRangel
 
 
 

Sumitting Forms connected to a database. Help!!!

Post by Q2xheSBGb3 » Sat, 26 Apr 2008 07:15:04

You need to make sure you are using you query fields to pull rows and the
data fields for the data you wish to submit.
The data should be visible in your form.

I would statr with the basic new form and follow its instructions
Drag the Query Fields in as a section
Drag the Data fields in to the view as a repeating table
Preview and do some queries and test it.
Add a new row to the repeating table and submit and see the data go in.
--
Clay Fox / Microsoft InfoPath MVP
www.InfoPathDev.com / The InfoPath Authority / Downloads, Samples, How-To,
Experts, Forum

 
 
 

Sumitting Forms connected to a database. Help!!!

Post by SnJhbmdlb » Sat, 26 Apr 2008 08:18:01

I did as you suggested and SUCCESS!!!
--
Thanks,

JRangel
 
 
 

Sumitting Forms connected to a database. Help!!!

Post by BobC » Thu, 01 May 2008 02:04:39

Looking forward, you may want to consider moving to SQL 2005, as it
supports the XML data type for columns, and opens up a world of
options for reporting on form data.

/bac