Sure, just set `IsHitTestVisible=&quot;False&quot;` on the control. Mouse events will pass through it.

I usually solve these kind of issues by adding handlers of child controls to the parent at construction. This way the &#39;click&#39;-event for example activates a method that raises the &#39;click&#39;-event of the parent.

I am using mysql and mysql workbench. I created 5 tables with innodb engine. I checked their engine and it was innodb before I insert data into them. I inserted data from 5 MyISAM tables and now my innodb tables are MyISAM. I can&#39;t change them. I used the alter table engine=innodb but it doesn&#39;t work.


Changing Table Engine in MySQL

What is the best way to include an input param in the `WHERE` clause but exclude it if it is null?

There are a number of ways I believe, but I can&#39;t seem to remember then.

Also could I use the `COALESCE()`? But I think this is only for SELECTing values?

Edit
---

To clarify, let&#39;s say a variable called `@code =&quot;1&quot;` then my where would be `Where type=&#39;B&#39; AND code = @code` but if `@code is null` then I only want `Where type=&#39;B&#39;` - notice the missing `code = @code`.


Checking an input param if not Null and using it in where in SQL Server

Is there a way that I can let mouse events pass through to controls behind?

Is there a way to make controls transparent to mouse events in WPF?

<p>Is there a way that I can let mouse events pass through to controls behind?</p>


The reason why I am asking this is because I was recommended by @Greg D (from [this question][1]) to use `SetCurrentValue()` instead, but a look at the docs and didn&#39;t see whats the difference. Or whats does &quot;without changing its value source&quot; mean?

[**`SetValue()`**][2]

&gt; Sets the local value of a dependency property, specified by its
&gt; dependency property identifier.

[**`SetCurrentValue()`**][3]

&gt; Sets the value of a dependency property without changing its value
&gt; source.


  [1]: https://stackoverflow.com/questions/4225331/is-there-something-wrong-with-my-dependency-property-content-not-set-with-bindin
  [2]: https://msdn.microsoft.com/en-us/library/ms597473.aspx
  [3]: https://msdn.microsoft.com/en-us/library/system.windows.dependencyobject.setcurrentvalue.aspx

What&#39;s the difference between Dependency Property SetValue() &amp; SetCurrentValue()

In my project I&#39;m using some third-party libraries. I include them using the references folder in Visual Studio.

But where should I save the DLL files? They are referenced from a path in the file system, but it would be nice if I can include it into the project. But how?


Where to store external DLL files?

I want to know the difference between `ObservableCollection` and `BindingList` because I&#39;ve used both to notify for any add/delete change in Source, but I actually do not know when to prefer one over the other.

Why would I choose one of the following over the other?

    ObservableCollection&lt;Employee&gt; lstEmp = new ObservableCollection&lt;Employee&gt;();

or 

    BindingList&lt;Employee&gt; lstEmp = new BindingList&lt;Employee&gt;();

Difference between ObservableCollection and BindingList

How to set Dialog&#39;s position that came from  `.ShowDialog();` to show at the center of the mainWindows.

This is the way I try to set position.

    private void Window_Loaded(object sender, RoutedEventArgs e)
    {        
        PresentationSource source = PresentationSource.FromVisual(this);
        if (source != null)
        {
            Left = ??
            Top = ??
        }
    }

WPF : How to set a Dialog position to show at the center of the application?

What can a `DockPanel` do that a `StackPanel` cannot? If anyone has an image of something that can be achieved with a `StackPanel`, but not a `DockPanel`, than that would be great.

What is the difference between a StackPanel and DockPanel in WPF?

I was hoping to craft a control where a user could click inside a div, then drag the mouse, then let up on the mouse in order to indicate how long they want something to be.  (This is for a calendar control, so the user will be indicating the length, in time, of a certain event)

It looks like the best way to do this would be to register a &quot;mousedown&quot; event on the parent div that in turn registers a &quot;mousemove&quot; event on the div until a &quot;mouseup&quot; event is triggered.  The &quot;mousedown&quot; and &quot;mouseup&quot; events will define the start and end of the time range and as I follow &quot;mousemove&quot; events, I can dynamically change the size of the range so that the user can see what they are doing.  I based this off of how events are created in google calendar.

The issue I&#39;m having is that the jQuery event seems to only provide reliable mouse coordinate information in reference to the whole page.  Is there any way to discern what the coordinates are in reference to the parent element?



**Edit:**

Heres a picture of what I&#39;m trying to do:
![alt text][1]


  [1]: http://i.stack.imgur.com/geTtf.gif

jQuery get mouse position within an element

I have this `a` and I don&#39;t know that I need to insert into the &quot;onmouseover&quot; so that the cursor will change to finger pointer like a regular link:

    &lt;a class=&quot;menu_links&quot; onclick=&quot;displayData(11,1,0,&#39;A&#39;)&quot; onmouseover=&quot;&quot;&gt; A &lt;/a&gt;

I read somewhere that I need to put:

    onmouseover=&quot;cursor: hand (a pointing hand)&quot;
But it&#39;s not working for me. 

Plus I&#39;m not sure if this is considered JavaScript, CSS, or just plain HTML.

change cursor to finger pointer

We&#39;re making a user-space device driver for OS X that moves the cursor using Quartz Events, and we ran into a problem when games — especially ones that run in a windowed mode — can&#39;t properly capture the mouse pointer *(= contain/keep it within the boundaries of their windows)*. For example, it would go outside the game window and click on the desktop or nearby inactive applications.

We could fix this if only we could detect when an active application calls CGAssociateMouseAndMouseCursorPosition.

How would you do this? Any ideas are appreciated.

Detecting CGAssociateMouseAndMouseCursorPosition

We&#39;ve stumbled upon a performance problem with Quartz Events, more specifically CGEventPost: during heavy GPU load CGEventPost can block. We&#39;ve created [a small benchmark application to demonstrate the issue][1]. This application is just a loop that creates, post and releases events.

Below you can see the results of running the application. The first run is on an idle system. The second run is with FurMark (GPU stress test) with the dials cranked up as much as possible.

* Inner is how long the inner loop takes, basically just creating, posting and releasing an event with Quartz Events.
* Outer is how long our program is waiting to be woken up (a sleep). Should be close to the time we sleep, but if the system is under pressure it could be delayed.
* Post is how long the event post takes.

&amp;nbsp;

	18:58:01.683 EventPerformance[4946:707] Measurements: (outer should be close to 10)
	18:58:01.684 EventPerformance[4946:707] inner (ms): 0.04, outer (ms): 11.02, CGEventPost (ms): 0.03
	18:58:01.684 EventPerformance[4946:707] inner (ms): 0.04, outer (ms): 11.02, CGEventPost (ms): 0.03
	18:58:01.685 EventPerformance[4946:707] inner (ms): 0.07, outer (ms): 10.26, CGEventPost (ms): 0.03
	18:58:01.685 EventPerformance[4946:707] inner (ms): 0.06, outer (ms): 10.85, CGEventPost (ms): 0.05
	18:58:01.686 EventPerformance[4946:707] inner (ms): 0.07, outer (ms): 10.41, CGEventPost (ms): 0.04
	18:58:01.686 EventPerformance[4946:707] inner (ms): 0.04, outer (ms): 10.39, CGEventPost (ms): 0.03
	18:58:01.686 EventPerformance[4946:707] inner (ms): 0.05, outer (ms): 11.02, CGEventPost (ms): 0.03
	18:58:01.687 EventPerformance[4946:707] inner (ms): 0.03, outer (ms): 10.67, CGEventPost (ms): 0.03
	18:58:01.687 EventPerformance[4946:707] inner (ms): 0.08, outer (ms): 10.09, CGEventPost (ms): 0.05
	18:58:01.688 EventPerformance[4946:707] Averages: (outer should be close to 10)
	18:58:01.688 EventPerformance[4946:707] avg inner (ms): 0.05, avg outer (ms): 10.64, avg post (ms): 0.03


Here we can see that posting the event takes about 0.03 ms on average. Also the thread seems to be woken up around 0.5ms too late. No spikes in CGEventPost.

	19:02:02.150 EventPerformance[5241:707] Measurements: (outer should be close to 10)
	19:02:02.151 EventPerformance[5241:707] inner (ms): 0.03, outer (ms): 10.23, CGEventPost (ms): 0.02
	19:02:02.151 EventPerformance[5241:707] inner (ms): 0.02, outer (ms): 10.54, CGEventPost (ms): 0.02
	19:02:02.151 EventPerformance[5241:707] inner (ms): 0.02, outer (ms): 11.01, CGEventPost (ms): 0.01
	19:02:02.152 EventPerformance[5241:707] inner (ms): 0.02, outer (ms): 10.74, CGEventPost (ms): 0.01
	19:02:02.152 EventPerformance[5241:707] inner (ms): 0.02, outer (ms): 10.20, CGEventPost (ms): 0.01
	19:02:02.152 EventPerformance[5241:707] inner (ms): 10.35, outer (ms): 11.01, CGEventPost (ms): 10.35
	19:02:02.152 EventPerformance[5241:707] inner (ms): 0.03, outer (ms): 10.02, CGEventPost (ms): 0.02
	19:02:02.153 EventPerformance[5241:707] inner (ms): 58.90, outer (ms): 10.11, CGEventPost (ms): 58.90
	19:02:02.153 EventPerformance[5241:707] inner (ms): 0.03, outer (ms): 10.12, CGEventPost (ms): 0.02
	19:02:02.153 EventPerformance[5241:707] Averages: (outer should be close to 10)
	19:02:02.371 EventPerformance[5241:707] avg inner (ms): 7.71, avg outer (ms): 10.44, avg post (ms): 7.71

When the system is under heavy GPU load, posting an event can take (spikes) milliseconds instead of microseconds. Under extreme GPU stress (&lt; 1 FPS), this value can take seconds. CGEventPost _sometimes_  seems to be waiting for the GPU to finish some work before returning. Our thread is still scheduled normally with no noticeable delay/spikes (outer).

Any ideas are appreciated.


  [1]: http://smoothmouse.com/storage/EventPerformance.zip

Weak performance of CGEventPost under GPU load

I&#39;m trying to learn JS and got an issue.

I tried many things and googled but all in vain. Following piece of code doesn&#39;t work as expected. I should get value of `i` on click but it always returns 6. I&#39;m pulling my hair out; please help.

    for (var i = 1; i &lt; 6; i++) {
    
        console.log(i);
    
        $(&quot;#div&quot; + i).click(
            function() {
                alert(i);
            }
        );
    }

[**jsfiddle**][1]


  [1]: http://jsfiddle.net/rmXcF/

Content Type	Original Author	Original Content on Stackoverflow
Question	Jordan	View Question on Stackoverflow
Solution 1 - Wpf	Rachel	View Answer on Stackoverflow
Solution 2 - Wpf	Geoffrey	View Answer on Stackoverflow

Is there a way to make controls transparent to mouse events in WPF?

Wpf Problem Overview

Wpf Solutions

Solution 1 - Wpf

Solution 2 - Wpf

Checking an input param if not Null and using it in where in SQL Server

Changing Table Engine in MySQL

Attributions