Newbie Questions

Re: Connection to SQL Server

Hilary Stoupa — Tue, 19 Jun 2012 14:44:48 GMT

Hi - unfortunately, it isn't possible in InfoPath to use field values or functions in your SQL queries. You'd need to use code, use a web service connection instead of a SQL connection (our web service, DBXL, can query SQL DBs with form values) or you could try qRules which has a command that can do this. Sorry that there isn't an out of the box way.

Re: Connection to SQL Server

Gennady Vanin (Геннадий Ванин, Новосибирск) — Tue, 19 Jun 2012 14:29:07 GMT

I advise you to reformulate your question.

At least to me it is not comprehensible

Connection to SQL Server

Firetux2012 — Tue, 19 Jun 2012 12:48:30 GMT

Hi guys,

i have to design a new sharepoint list form.

in this form i musst select data from another database.

In the connection wizard i've to declare my sql script to fetch the data. Is it possible to use
the function userName() in this dialog? or how can i use my textfields from my form in the sql statement?

thanks for help!

greets