InfoPath Dev

I'm using Infopath against a SQL Server database, and am trying to write the VB code to execute custom SQL commands, like Updates and Deletes. When I test, if I don't add any new data to the form, then I get an error saying that no new data exists to submit, even though the code is an update statement to set the ...

 Patrick-  I know this site is to push your product, but unfortunately, my team doesn't have the budget and/or time to work on coming up to speed on a new Web Service piece.  We're just looking for Infopath to provide temporary solutions until a more structured source is used by our customers, but we need to provide them ...

 I have a normalized database that I'm trying to use InfoPath to submit to.  I know that it isn't possible to submit to tables using a join statement, so I thought to make a view and use an Instead of Insert trigger.  My thinking was that Infopath would just see it as one table, and submit, but I guess it just sees the view ...