InfoPath Dev

I'm confused: I have a data connection:

select distinct "FullName" from "employee" as "FullName" order by "FullName"

When I run this data connection from managed code, everything works fine. But when I put a 'where' statement in it, the result will always be "".

SELECT distinct FullName
FROM bi_employee
AS FullName
WHERE LogonName=N'blah'
ORDER BY "FullName"

When I exclude the "where" statement, everything works fine. the management studio performs the query without an error on manual try.


I assumed the XPath of the result set changed, but I just can't figure out to what. I tried everything I could imagine.

Can anybody help me?

Thanks a lot!!

Hi,
You are using single quote in the query string, database thinks single quote as a starting of the string.
You need to escape single quote with one extra single quote then it should work.

So your query should be
SELECT distinct FullName
FROM bi_employee
AS FullName
WHERE LogonName=N''blah''
ORDER BY "FullName"

Agni
INFOPATHdev India