SQL Database Integration

Re: Submit code

Matt Faus — Tue, 06 Feb 2007 18:16:16 GMT

Hi Steve and welcome to the forums!

It sounds like this is a perfect scenario for our Database Accelerator! We have created countless forms that follow this exact scenario. With DBXL (our acronym for Database Accelerator) you can have each row in the repeating section be a Document and then provide buttons to edit and delete. If you create a mapping it will reflect these changes in the database.

Also, if you use the new Base Form that we have created you will get a host of extra features such as built-in email workflow, tagging ability, and others! Try downloading the free developer version of DBXL and then let us know if you have any questions!

http://www.qdabra.com/proddetail.asp?prod=QDBXL1

Submit code

stevedude652@yahoo.com — Sat, 27 Jan 2007 18:23:39 GMT

All,
I have an IP form that is simple: it has one repeating section
that holds all of the data. The issue is that the repeating section
gets it's data from a Data Connection that is a View and thus IP will
not let me submit using the default submit means. Thus, I have to code
my own submit.

However, since it does have a repeating section, the user can edit
multiple items at one time before submiting including deleting. I know
there is an IsDirty flag on the XDocument, but is there a way to
determine if each repeating item has been modified, inserted or
deleted? The automatic submit has to keep this information somehow?

This is really holding me up and any help is much appreciated.

Thanks,

Steve