Data Connections

Re: Compare Username Field from InfoPath with Username Field from DB and display Namefield

partysan — Tue, 09 Feb 2010 08:09:03 GMT

Thank you Hilary but I found another way to solve this problem,

I get the information from LDAP.

http://msdn.microsoft.com/en-us/library/bb952744.aspx#ip2007GettingUserInformationActiveDirectory_ReadIt

regards

Philipp

Re: Compare Username Field from InfoPath with Username Field from DB and display Namefield

Hilary Stoupa — Sat, 06 Feb 2010 01:12:38 GMT

Hi -- are you talking about using the a form field in your form as part of the SQL query in your data connection? If so, I'm afraid your choices are code or web services (we sell a great one that does this, and you can get a free trial here).

Compare Username Field from InfoPath with Username Field from DB and display Namefield

partysan — Fri, 05 Feb 2010 15:40:59 GMT

Hello!

Im very interessted to solve the following problem:

I have a Database (*.mdb) with two fields.

Username and Name.

Furhtermore a Infopath form with two fields.

Username ( fieldname: UsernameAusSystem; value: userName())

Name (fieldname: NamenAusDB; value: @Name->get the Name field from the Dataconnection)

Database and Infopath Form are connected with a simple dataconnection.

The goal is compare the Username field from Infopath with the Username field from the DB

and if its machted then put the value from the Database Name field into Infopath Name field.

The following SQL-Code doesnt work:

select [ID],[Usernamen],[Name] from [UsernameAusDB] as [UsernameAusDB]
where [Usernamen] like [UsernameAusSystem]

I think it is a little problem, if i write:

select [ID],[Usernamen],[Name] from [UsernameAusDB] as [UsernameAusDB]
where [Usernamen] like "JohnSmith"

and JohnSmith is a value in the database, it works.

Can anybody write me the write syntax?

Regards

Philipp