 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / April 2008Sumitting Forms connected to a database. Help!!!
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?  SignatureThanks, JRangel 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. SignatureClay Fox / Microsoft InfoPath MVP www.InfoPathDev.com / The InfoPath Authority / Downloads, Samples, How-To, Experts, Forum > 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 [quoted text clipped - 7 lines] > What am i doing wrong? Why is the form inserting an empty record in the > database table? I did as you suggested and SUCCESS!!! SignatureThanks, JRangel > 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. [quoted text clipped - 17 lines] > > What am i doing wrong? Why is the form inserting an empty record in the > > database table? 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 > I did as you suggested and SUCCESS!!! > -- [quoted text clipped - 31 lines] > > > > JRangel |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.