Data Connections

Re: Save Query

Douglas Filipe — Thu, 12 Mar 2009 15:03:56 GMT

Good! I will try to use this product.

Thanks for help me Hilary!!!

[]'s

Re: Save Query

Hilary Stoupa — Thu, 12 Mar 2009 14:54:52 GMT

We have a free product called qRules that has that functionality, so you wouldn't have to code. Download is available here. If you are using IP 2007, you can use VSTA with InfoPath and write C# or VB.Net code as well.....

Re: Save Query

Douglas Filipe — Wed, 11 Mar 2009 11:30:33 GMT

So I believe that a button with the function to copy to another repeating table would be ideal, but I not infopath dev, I think it dev in VBA would be more easier.

Re: Save Query

Hilary Stoupa — Tue, 10 Mar 2009 15:44:59 GMT

So you want to be able to use the 'Query' functionality while you have a new item added that hasn't been submitted? I think I still may be a little confused. Perhaps you could add another button that would first run a submit to the database to add your new item, then query again. The reason your new row gets removed is because it doesn't meet the query filter you've added of the registration number. With a database bound form, there are some innate behaviors and restrictions that can be a little tough to work around.

Re: Save Query

Douglas Filipe — Fri, 06 Mar 2009 11:28:08 GMT

Hi Hilary! thanks for reply

This is my form

This is a query result

I insert a new item

But when I make a new query all changes are clean, look this message

Translating: this action deletes all information from the current form

My need is simply, save the query result and continue inserting new item. Could copy to another repeating table, but how?

This form will be published in MOSS Foms Service.

Thanks for your attention

Re: Save Query

Hilary Stoupa — Fri, 06 Mar 2009 02:45:58 GMT

Hi:

Not to be slow -- I don't quite understand what you wish to accomplish. Can you provide a little more detail, please?

Save Query

Douglas Filipe — Wed, 04 Mar 2009 14:37:08 GMT

Hi everyone!
I created a form based in a table SQL Server, the query is done successfully is returned in repeating table, I would like to save this query in other repeating table.
how can I do that?