 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / August 2006xDocument - using Set command in vbscript
I am trying to learn infopath. We are currently using another product for online forms, and are looking at moving to Infopath. My question is, when we perform any functions with our form, we do all our editing, and navagation using object (script) code. I noticed on Infopath, that you need to use the "set" command (i.e. Set txtAward_To = XDocument.DOM.selectSingleNode("//my:txtAward_To") ). It seems that this is needed to link the fields in the script with the ones on the form. This works ok with small forms, but when I try to work with a complex form (over 75 fields), the script seems to "forget" and I have to use the "Set" command multiple times at different places in the script for the processing to work. Is there an easier way to link the fields in the infopath form to the fields in the object using vbscript? any suggestions would be appreciated. It is not clear to me what the issue is. "Set" in VBScript is used to set the value of an object. If "the script seems to forget" you're probably reassigning the variable you previously set to one or more other objects. Use a different variable for each XML node you're retrieving and want to access in your code. --- S.Y.M. Wong-A-Ton > I am trying to learn infopath. We are currently using another product for > online forms, and are looking at moving to Infopath. My question is, when we [quoted text clipped - 8 lines] > Is there an easier way to link the fields in the infopath form to the fields > in the object using vbscript? any suggestions would be appreciated. I'm sorry, maybe I didn't make myself clear. In the project I'm working on, I'm using the Infopath for a form. The object (script) is used to take the data entered on the form and submit it to the SQL table assigned to the form. I have been able to make this work, but, like I said, the vbscript seems to forget about the linkage between the form and the script. There is one script for each form. I am trying to retrofit the script from Accelio, where the script works with no problem using vbscript. The SQL side works fine, we are using views for security. > It is not clear to me what the issue is. "Set" in VBScript is used to set the > value of an object. If "the script seems to forget" you're probably [quoted text clipped - 16 lines] > > Is there an easier way to link the fields in the infopath form to the fields > > in the object using vbscript? any suggestions would be appreciated. I still don't understand what you mean, but it sounds like you're taking code from somewhere else and trying to plug it into InfoPath? And I'm unfamiliar with Accelio. Sorry I cannot be of more help to you at this time. --- S.Y.M. Wong-A-Ton > I'm sorry, maybe I didn't make myself clear. In the project I'm working on, > I'm using the Infopath for a form. The object (script) is used to take the [quoted text clipped - 25 lines] > > > Is there an easier way to link the fields in the infopath form to the fields > > > in the object using vbscript? any suggestions would be appreciated.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.