Browse by Tags

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
Different Permissions on Fileds or View?!

Hi everyone I have to build a form with informations about new products and want to publish it on our sharepoint in "browsermode". This form will be filled by 3 different user from different departments. Every user should only see some general information and his added information but not the...

Posted to Newbie Questions (Forum) by jabbar on 08-07-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: repeating table add rows programaticly

Hello Thank you for your prompt answer it helped me a lot. finaly this is what i did instead cloning each row For i = 0 To rows - 1 Dim myNamespace As String = NamespaceManager.LookupNamespace("my") Using writer As XmlWriter = MainDataSource.CreateNavigator().SelectSingleNode( _ "/dfs...

Posted to Newbie Questions (Forum) by Franc1 on 06-25-2008
Decrease the time it takes for a form to open in SharePoint

Hi all, I did some searching, but couldn't find anything on this topic. I have an InfoPath form that is growing in size. It is being hosted on a SharePoint site and has multiple data connections to SharePoint lists, two of which are near or exceed 10000 rows (with many columns). This is causing the...

Posted to General (Forum) by Patrick on 06-20-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
Integrating Infopath 2003 with a SQl database

I have a database on a SQL 2003 server with a SPC call "sprGetAppDesc" To get the proper result I need to pass into it "strAppNum" and it will return "egaDescription". I have followed every example I can find on how best to do this and get no actual working result. The data...

Posted to Database Integration (Forum) by bsprygada on 03-31-2008
Re: SQL Question(Group By)

I created a SQL query with a Group By clause using Toad for SQL Server. It worked great. The query is below. But when I run the query in InfoPath, I get the error message below. Does that mean InfoPath does not support the Group By clause? I could create a view but I need to pass in variables from the...

Posted to Database Integration (Forum) by m181354 on 02-07-2008

Page 1 of 1 (9 items)