Making a function public to pass XDocument.DOM to another form

[Steve]

I would like to create an auxiliary form that gathers data for my main form.
In order to do this, I need to pass a reference of the main form to the
auxiliary form. Then the auxiliary form would be able to gather data to send
back to the main form. I tried the following but couldn't call the function
on the auxiliary form (2nd line of code). Is there something I have to do to
make the function public to external objects?

function search_values::OnClick(eventObj)
{
searcher = Application.XDocuments.NewFromSolution("searcherType.xsn");
searcher.accept_parent_form (XDocument.DOM);
// searcher stores XDocument.DOM in a global
// variable for later processing
}


In case my approach is entirely wrong, here is the situation that drove me
here. I needed a drop-down list of 50K records but InfoPath takes 15 minutes
to process the drop-down choice. I found that a query on an auxiliary form
finds the needed data almost immediately, so I decided to use the auxiliary
form to pick the data and send it back to the main form. If you know of a
better approach, please let me know.

 

[Clay Fox]

There is a better approach.

Use a webservice to connect to your data and you can query your 50K table.
This will be the best performance and be seemleess for the user.

Check out the Database Accelerator package of web services from
http://www.qdabra.com
That includes everything you need to both query and submit data to SQL.

--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com

 

[Steve]

Thanks, Clay. InfoPath seemed like a great solution when I saw the e-mail
integration with the database. But when I found InfoPath forms cannot seem
to communicate with each other and they cannot be used with Oracle databases
-- where our corporate data lies -- I got pretty discouraged. Can qdabra
talk to Oracle, or am I stuck with MS Access forms?

Thanks,

--Steve

 

[Clay Fox]

The webservices should be able to work with Oracle for Queries. The
webservices themselves require SQL and IIS. But I believe then you could
interact with your Oracle Data. You can use SQL Express too. Typically
though it is simpler and easier to use DTS to move data from Oracle into a
front side SQL DB and work with it directly.

InfoPath design and the functionality is so much nicer than Access forms.
You can have InfoPath be the front end to an Access Db but obviously it is
not best practice for an enterprise solution.

If you would like a demo or to discuss this further you can email me here.
http://www.infopathdev.com/members/clayfox.aspx
--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com