Browse by Tags

Submit query and get the table

Hi, I need to send a query to database and the generated table should be displayed in the form. Is this possible with infopath? Regards, Kiran

Posted to Database Integration (Forum) by Jollybaba on 09-29-2008
Filter Data Received from SQL Data Connection

I have been working with InfoPath for a while now, but have yet to run into this situation. I have a user directory form that will connect to an SQL database and return the results of a table which contains user names. I want to return that list of user names to my form, however I need to incorporate...

Posted to Data Connections (Forum) by WSU54 on 09-11-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
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
Can not submit data from InfoPath form to SQL Database

Hello I was wondering if someone could possibly help me. I am currently running sharepoint2007 server along with ms sql2005. I have created a form that goes out and queries data fine however I am trying to make a page where I submit data to my sql database. I have been doing research on this and have...

Posted to Data Connections (Forum) by mock24 on 07-24-2008
How To Repair Xref tables in DBXL

An irreconcilable Xref error will typically resemble the following: Event Type: Error Event Source: Database Accelerator Event Category: None Event ID: 0 Date: 9/6/2007 Time: 12:15:54 AM User: N/A Computer: AUTONOMY4 Description: Caught exception deleting an item from the target database encountered...

Posted to Misc (FileGallery) by ErnestoM on 07-11-2008
Re: NaN Error, Calculating default value

I finally got it! It was the weirdest thing. I have my data in an SQL server and the pieces of data that were being pulled into the Discount boxes were set to "float" in SQL. I compared the values that were causing the error with the values that had no error and found that the "errored"...

Posted to Bugs / Errors / Workarounds (Forum) by Patrick on 07-09-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
Datatypes mismatch in SQL server and Infopath

Hi, I have a problem when trying to submit an Infopath form.The scenario is as follows: I have an infopath form which talks to SQL server via a webservice to query and submit data. I have SQL server 2005 database which has a table for services provided for a given studentID . Fileds and the data types...

Posted to General (Forum) by swetha on 07-02-2008
Re: Decrease the time it takes for a form to open in SharePoint

Hi Patrick, Thanks for your reply. I have been thinking about how to make this work a bit faster. Clay suggested I take a look at using a web service to pull my data, but unfortunately I have to exclude that option for this portion (but it's still a great way to receive data!). To reiterate, I have...

Posted to General (Forum) by Patrick on 06-25-2008

Page 1 of 7 (66 items) 1 2 3 4 5 Next > ... Last »