Re: get username for sql data connection

Hilary Stoupa — Mon, 27 Aug 2012 22:37:13 GMT

We don't have dynamic SQL queries out of the box with InfoPath, unfortunately. Your options are writing code, building or buying a web service (DBXL, for example) or qRules also has commands for this.

get username for sql data connection

endear — Fri, 24 Aug 2012 09:26:01 GMT

I have a form that is connected with a database. In my DB I have records that contains the username of the user.

On load, the form has to load the information from the DB. That is working fine, now InfoPath load all the records.

But I only need the records of the current user.
How is it possible to do a query where I say that I only need the records where username = currentUser?
In InfoPath you can use username(), but how do I get it in my sql?

With in my sql, i mean: under Data > Data connections. modify the connection and click on "edit SQL"

General

Re: get username for sql data connection

get username for sql data connection