Code

Re: Reset form on submit using Visual Basic coding

ZhenYuan — Mon, 13 Sep 2010 02:59:19 GMT

Thanks again! It worked! But I put the catch line just before the delete line, I suppose the catch line was set to "start up" the data source so that it won't be null?

Regarding the re-query, I used by original buttons. Just that the rules went: 1) Query Data connection 2) Insert search query 3) Query Data connection. Previously, I only had 2) and 3) but now I've added 1) to re-initialize the data connection. An extra rule but a required one if I deleted the data connection on reset.

Re: Reset form on submit using Visual Basic coding

Potemkine — Sun, 12 Sep 2010 12:53:56 GMT

Hi, you can place your try catch just on the line to delete your secondary data connection, you can also make an if statemment like

if (test.innerxml !="")

.For your other issue, you have to Re query your dataconnection because you just delete it.You can set a rules or codes (the one on my last post)if you have an issue with that when you try it, please use a separate button with just a rule that query your dataconnection.

Re: Reset form on submit using Visual Basic coding

ZhenYuan — Sun, 12 Sep 2010 07:13:22 GMT

Hi Potemkine,

You mean place the try catch code in the reset button code or in the Query button code (the query button which did not work after the reset).

My form has a rest button as well as several Query buttons in the form where users can click to query our database based on certain inputs in the form. My aim is to have a form where users can reset the form after a wrong filling and the data sources are cleared for reuse.

Right now, if I click the reset button twice, a null error occurs. The separate issue is that after using the code to clear data source, my query button fails as well. It fails to perform its original task of connecting to the data source for data.

Re: Reset form on submit using Visual Basic coding

Potemkine — Sat, 11 Sep 2010 18:15:12 GMT

Hi, you have to query your data connection with rules or code to make them re-usable. You can make a try catch for your null exection

Me.DataSources["DATACONNECTION"].QueryConnection.Execute();

Re: Reset form on submit using Visual Basic coding

ZhenYuan — Sat, 11 Sep 2010 10:38:39 GMT

Hi,

This worked fine for the first time only. After which, if I try to reset again, I get a System.NullReferenceException error. I tried doing checks for nulls using:

XPathNavigator test = Me.DataSources["DATACONNECTION"].CreateNavigator();

If test.SelectSingleNode("dfs:myFields", Me.NamespaceManager).Value Is DBNull.Value Then

else

test.SelectSingleNode("dfs:myFields", Me.NamespaceManager).DeleteSelf()

End If

In any case, after the first deleteself, the data connection is unusable from then on! When I try to perform my query using the data connection, an error pops out:

Some rules were not applied. The parameter is incorrect.

Any clues to help? Thanks!

Re: Reset form on submit using Visual Basic coding

Potemkine — Fri, 10 Sep 2010 15:50:01 GMT

Hi ZhenYuan,

try this:

XPathNavigator test = Me.DataSources["DATACONNECTION"].CreateNavigator();
test.SelectSingleNode("dfs:myFields",Me.NamespaceManager).DeleteSelf();

Re: Reset form on submit using Visual Basic coding

ZhenYuan — Thu, 09 Sep 2010 15:59:33 GMT

Hi Potemkine, Now I need to go one better. Remember previously I wanted to reset all field values from my form via a button? That was settled. Now I want to reset even the secondary data connections. Can I use some code (Visual Basic) to clear my specific data connections?

My form has some search function whicn populates a listbox with its results. I noticed that resetting the form clears all the form fields but not the listbox because it is tied to a data connection that is holding data from the previous search.

Hope you have a solution?

Thanks!

Re: Reset form on submit using Visual Basic coding

Potemkine — Mon, 16 Aug 2010 15:43:23 GMT

Hi Zhen Yuan, if you use data validation instead of mandatory field you get an red mark on your textbox, the user can know exactly where the error is. You configure it on the text box not on the field, that why you won't have an issue on the submit for your reference field.

But If you prefer to replace your 12 fields it works too.

Re: Reset form on submit using Visual Basic coding

ZhenYuan — Mon, 16 Aug 2010 07:31:05 GMT

Hi,

Your first suggestion won't be good for my users. They would want to know exactly where the error is, ie, which field they keyed incorrectly. lf I were to put the error on submit, they would have to scroll and find the field. I'll get stick for this :(

For your second suggestion, how do you remove a reference? Are you suggesting: create 2 clones of form_container, one as the default form while the other has dummy data in the mandatory fields. On Reset, the default form clone refreshes the form while the dummy clone clones the default form clone (so that now there are no empty mandatory fields in the default form clone)?

Anyway, I used your replace field code to replace the refreshed form and it works fine. I have like 12 such lines of replacements but it suits my purpose just fine. Especially when this allows me to continuously reset the form.

Now for emailing the form as a template... my buttons went missing! Shall look for a related thread or post a new one soon!

Thanks!

Re: Reset form on submit using Visual Basic coding

Potemkine — Fri, 13 Aug 2010 16:04:02 GMT

Hi Zhen Yuan, if you have 10 mandatory fields it could be easier if you replace your mandatory field by data validation you just have your error message on the submit for your form_container node.

If you can't do that, you can create manually an xml node like your form_container and use it like your clone and remove the reference.

Re: Reset form on submit using Visual Basic coding

ZhenYuan — Fri, 13 Aug 2010 01:19:06 GMT

Hi,

I suppose your "my:Field1" refers to all my individual mandatory fields? Meaning if I have 10 such fields, I must individually setvalue to "" right? I tried for one field and it works. Just wondering if I am doing it right or doing it the long way.

Thanks again for your greatly appreciated help!

Re: Reset form on submit using Visual Basic coding

Potemkine — Thu, 12 Aug 2010 12:05:27 GMT

Hi, an easy way is to put some default value on your reference mandatory field. And modify your reset bouton to empty it when it clicked: add this code at the end of your function:

Me.CreateNavigator().SelectSingleNode("/my:myFields/my:Form_Container/my:Field1", Me.NamespaceManager).SetValue("")

Reset form on submit using Visual Basic coding

ZhenYuan — Thu, 12 Aug 2010 10:30:04 GMT

Hi,

I'm stuck again :(

My form has mandatory fields and since I cloned the container at the beginning, the clone has the empty mandatory fields! And of course, the form now fails to get submitted as the required fields are empty...

Is there a way to remove the clone using my submit button? I'm using DBXL's web service submit and thus my submit button has no code to alter. If I choose to alter the submit code, they give me a clean slate to code my submit and I have no idea how to code all those web service data connections, etc...

Attached is my sample form again with a mandatory field. Preview it, fill up the mandatory field and try to submit. You will see what I mean...

Thanks!

Re: Reset form on submit using jscript?

Potemkine — Thu, 12 Aug 2010 03:08:29 GMT

You're welcome !

Re: Reset form on submit using jscript?

ZhenYuan — Thu, 12 Aug 2010 02:13:58 GMT

Thank you so much! It works now!

Thanks again!