InfoPath Dev

Hello,

I am trying to update the SQL in data connection and want to filter
it for a value in the screen I am using this syntax:

shape
{select "DB_ID","DB_Name","DB_StD_Status_ID" from "dbo"."Dic_Databases" as "Dic_Databases" where "DB_Name" = '/dfs:myFields/dfs:dataFields/d:Dic_Databases/@DB_Name.txt'} as "Dic_Databases"

I don't have any error but it seems that it don't take in account the value in the combo box called DB_Name. Any one have a solution ?

Thanks for your help.

Is your attribute actually named "@DB_Name.txt" or "@DB_Name"? You probably need to reference it according to its actually name... which likely does not include the ".txt" portion.