Check out this article:
http://enterprise-solutions.swits.net/infopath/query-access-database-list-numbers.htm
While it doesn't give you all the answers, it will help you get started with
retrieving the data connection in code and modifying the SQL statement to
retrieve the information you want to retrieve from the database.
Also, search this newsgroup, since there are many examples listed on how to
get this done.
---
S.Y.M. Wong-A-Ton
"william" wrote:
[Quoted Text] > I'm trying to create a query in InfoPath that takes a users login credentials
> and queries an SQL Database to retrieve values such as FirstName, LastName,
> Email, Phone, etc. I have created the Data Connection to the database, but
> I'm still new to the scripting. I want to create the script to run OnLoad.
> So that as soon as it opens the fields are already populated with the proper
> information.
|