# Named Query Won't execute

**URL:** <https://forum.inductiveautomation.com/t/named-query-wont-execute/24444>\
**Category:** Ignition\
**Created:** [April 28, 2019, 1:37am UTC](https://forum.inductiveautomation.com/t/named-query-wont-execute/24444 "2019-04-28T01:37:48Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![dcamp1](https://avatars.discourse-cdn.com/v4/letter/d/dc4da7/32.png) [@dcamp1](https://forum.inductiveautomation.com/u/dcamp1)\
**Post date:** [April 28, 2019, 1:37am UTC](https://forum.inductiveautomation.com/t/named-query-wont-execute/24444/1 "2019-04-28T01:37:48Z")

</div>

I am trying to create my first named query. I can see the database table that I created in SQLEXPRESS

All I want to do is a simple query.  
‘’‘Select id, filename from locdocs  
‘’’  
But when I goto testing and execute nothing happen.

I have also tried using the table name locdocs.id, locdocs.filename but still nothing happens.

I must be missing something.

Thanks

---

<div class="post-metadata">

**Author:** ![Paul.Scott](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul.scott/32/4578_2.png) [@Paul.Scott](https://forum.inductiveautomation.com/u/Paul.Scott)\
**Post date:** [April 29, 2019, 8:55pm UTC](https://forum.inductiveautomation.com/t/named-query-wont-execute/24444/2 "2019-04-29T20:55:29Z")

</div>

Are there any error boxes hiding in the background? If you check the designer’s console (Tools on the menubar \> Console) do you see any relevant errors?

---

<div class="post-metadata">

**Author:** ![dcamp1](https://avatars.discourse-cdn.com/v4/letter/d/dc4da7/32.png) [@dcamp1](https://forum.inductiveautomation.com/u/dcamp1)\
**Post date:** [April 30, 2019, 9:19pm UTC](https://forum.inductiveautomation.com/t/named-query-wont-execute/24444/3 "2019-04-30T21:19:27Z")

</div>

Thanks for your reply. I did get it solved! Let me explain.

No there was NO error’s showing, it was just like nothing was happening.

Come to find out it was my “Windows Defender Firewall” after I figured out this was my problem, I was able to make soime PC adjustment and now everything is working.

This was a time consuming ordeal.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [April 30, 2019, 9:46pm UTC](https://forum.inductiveautomation.com/t/named-query-wont-execute/24444/4 "2019-04-30T21:46:33Z")

</div>

> [@dcamp1](#):
>
> Windows

Ah, operator error. Failure to select Linux for your computing environment.

---

<div class="post-metadata">

**Author:** ![dcamp1](https://avatars.discourse-cdn.com/v4/letter/d/dc4da7/32.png) [@dcamp1](https://forum.inductiveautomation.com/u/dcamp1)\
**Post date:** [May 1, 2019, 1:12am UTC](https://forum.inductiveautomation.com/t/named-query-wont-execute/24444/5 "2019-05-01T01:12:38Z")

</div>

You may be right, it seems like Windows is moving more toward a “Social Media” environment, and forgetting the commercial use of a computer operating system.

Thanks for the tip.