Re: Browser Forms Posting to SQL Server Databases

sachin — Fri, 30 May 2008 09:30:15 GMT

Thanks for the reply Clay but our client wants us to develop the solution for them rather than buying a ready made one.

Re: Browser Forms Posting to SQL Server Databases

Clay Fox — Thu, 29 May 2008 20:00:42 GMT

There is a packaged solution for this.

Check out www.qdabra.com or email Sales@qdabra.com and you can see a demo.

Browser Forms Posting to SQL Server Databases

sachin — Thu, 29 May 2008 16:56:15 GMT

Hi all,

I have a very specific requirement from a client and I shall describe it in what follows. I need to create browser based forms to be filled out and placed in a forms library (simple so far) but the data in the filled out forms should not only be placed in SharePoint (which I do know puts that data into a SQL Sever database) but should be placed also (duplicated in some way) into another SQL Server database. I don't mean that I need to parse SharePoint's internal database and place the data I get back into another database - that sounds very complex! What I do mean is I need to take all the information the user typed into the form and place it in a separate SQL Server database. So typically there will be a single table per form with n columns for n fields in that form. Simple really. This is duplication I guess but it is a requirement. Also if a form is edited it's corresponding entry in our database would also need to change and if a form is deleted the corresponding entry would also need to be deleted. In some detail does anyone know how this may be achieved. I have a vague idea that I may be able to use event handlers or workflows in some way but I really would not know how exactly that may work. Would there be a simpler way to do this?

Any help would be much appreciated.

Thanks.

Sachin

SharePoint Integration

Re: Browser Forms Posting to SQL Server Databases

Re: Browser Forms Posting to SQL Server Databases

Browser Forms Posting to SQL Server Databases