point me to the right website

[Eric]

I read once on the website where infopath can check to see if the database
that it's source is from, and if it is not available, will display a dialog
box and then disappear. I know that you code it in the onLoad event, but I
cannot seem to find the instructions on how to do it.

Does anyone know where that is explained?

Thanks
me

 

[agni]

Hi,
Checking has to be done in the onload method.
When you are crating the dataconnection, in the last dialog there will be a
check box which asks to query the dataconnetion in onload, you just uncheck
that checkbox and click ok.
Once you do this you can query the dataconnection via tha code. The code
which you write should be written inside a "try catch" block.

There are various posts regarding quering the dataconnection at
www.autonomysystems.com

-Agni
www.autonomysystems.com

 

[Eric]

Thanks

can you supply a web address from your site that explains how to do it, as a
search on your site does not add any new light to the subject.

 

[Eric]

I also went through a new dataconnection wizard, and in no place is there a
place (checkmark box) to query the dataconnection in onload.

Are you sure what you posted is correct?

 

[Eric]

Has anyone seen a blog or website that walks you through coding the
connectivity to a database, and if the connection does not exist, gives a
dialog box stating that the database is unavailable and closes?

Thanks,
Eric