Browse by Tags

Infopath - Display data from a database

Hi there. Am new to all this :-) I have a template file created based on an MS Access database. One of the controls on the form is populated with the function Username. I have a main datasource, being the table in the access database where I wish to store the data from this form. I have a number of secondary...

Posted to Newbie Questions (Forum) by Gary Burke on 10-09-2008
Submit to SQL Database

Hi All, We had developed an application based on Infopath 2007 Form Services and it submits to a Form Library and it also has simple workflows. Well almost 95% of the work is done but our management is not too happy in having Form Library as the storage and want SQL Server 2005 as the storage instead...

Posted to Database Integration (Forum) by tosh9541 on 09-19-2008
SQL Server 2000 Trigger doesn't work

I am appending records to an SQL Server 2000 database using InfoPath 2007. I made a trigger on the table the form is based on but when I append a new record the trigger never fires. The trigger works fine if I append a new record using Query Analyzer. I first assumed it just would not work due to some...

Posted to Database Integration (Forum) by cduwel on 08-14-2008
Retruning all rather than matching query

Hello, I am new to InfoPath (using the 2003 version) and I have been trying to create master/detail pages from an existing SQL server DB. In trying to learn how to do this I have been using the wonderful example posted by Matt Faus posted at location http://www.infopathdev.com/blogs/matt/archive/2006...

Posted to Database Integration (Forum) by bmcclue on 07-03-2008
Re: Not Able to Pull Data From a SQL Database

Those were all great suggestions. I checked the security and it is good. I am using a secondary connection and querying it via JScript. I did try the final suggestion of recreating a form. I got a new error message: The following error occurred: 'XDocument.DOM.selectSingleNode(...)' is null or...

Posted to Database Integration (Forum) by David P on 05-29-2008
Not Able to Pull Data From a SQL Database

I have created a InfoPath form that queries a datasource for a a user and then auto populates other fields on the form. I orginally designed this using an MS Access database and everything worked perfectly. I changed the datasources to point to a SQL database (The SQL view's structure is identical...

Posted to Database Integration (Forum) by David P on 05-29-2008
Option button in databound repeating section

Hi, I'm trying to make a questionnaire. The situation is typical, two related tables in the database, the first with questions and the second with answers. I want do that questionnaire with the minimum number of controls, without know how many questions and answers will form it and can be selected...

Posted to Newbie Questions (Forum) by run000 on 04-02-2008
XML: MS Rowset Schema

I am working with iBase, an visual analysis database. iBase loves to import data, and infopath loves to collect data, so I'd like to use them together. InfoPath outputs XML and iBase loves XML, so it should be a natural match. However, iBase will only import XML formatted as "MS Rowset Schema"...

Posted to Database Integration (Forum) by Mojo Texas on 03-06-2008
Re: Saving a field back to a data a source(Access)

When I supply the row number directly it works great! But when I pass it a filter value it does not. I must have the wrong syntax. I will show you both ways I am trying it. This works... <xsf:calculatedField target="/dfs:myFields/dfs:dataFields/d:LaborSummary[2]/@NOW_ETC_HRS" expression...

Posted to Newbie Questions (Forum) by m181354 on 09-26-2007
Re: Saving a field back to a data a source(Access)

Looks like this is the line I need to change... <xsf:calculatedField target="/dfs:myFields/dfs:dataFields/d:LaborSummary/@NOW_ETC_HRS" expression="../../../my:FormData/my:NOW_ETC_HRS_USER_INPUT_TOTAL[../../my:DetailId = ../../dfs:dataFields/d:LaborSummary/@AUTONUMBER and ../../dfs:dataFields...

Posted to Newbie Questions (Forum) by m181354 on 09-24-2007

Page 1 of 2 (15 items) 1 2 Next >