hstatus | hStatus : An open source status page you can host on S3

You can add WS_CLIPCHILDREN window style to your MainWindow:

Could you attempt to JOIN the tables rather than doing an subquery for count like so:

WM_ERASEBKGND : Sent when the window background must be erased (for example, when a window is resized). The message is sent to prepare an invalidated portion of a window for painting.

The simplest solution： delete WM_ERASEBKGND message or add return DefWindowProc(hWnd, message, wParam, lParam) in the WM_ERASEBKGND message if you do not want delete WM_ERASEBKGND.

The SERVICE_TABLE_ENTRY structure array requires the last member to be NULL, which we call "Sentinel" (all values are NULL), it indicates the end of the service table. Once a service is started, StartServiceCtrlDispatcher() is called to notify the service controller that the service is executing and to provide the address. StartServiceCtrlDispatcher() requires only an array of at least two SERVICE_TABLE_ENTRY structures.

This is why access violations occur. When your program executes to StartServiceCtrlDispatcher(entrytable), It will acess the second element ofSERVICE_TABLE_ENTRY, but your array definition has only one element, so it results in access violation.

Your ServiceMain() and ControlHandler() functions are declared wrong, but you are using type-casts to stop the compiler from complaining. Any time you have to resort to using a type-cast to quiet the compiler, think about what your code is trying to do, as it is likely doing something wrong.

Also, the SERVICE_TABLE_ENTRY[] array that you are passing to StartServiceCtrlDispatcher() is incomplete - you are not NULL-terminating the array, like the documentation says to do.

For that matter, you claim that your service works when compiling for Unicode, but the code you have shown won't actually compile under Unicode, because the ServiceTable[0].lpServiceName field will be expecting a Unicode string but the code shown is assigning an ANSI string instead, which is an error.

I suggest you read Microsoft's documentation, and pay close attention to the examples it gives:

Service Program Tasks

The following tasks are performed by service programs:

• Writing a Service Program's main Function
• Writing a ServiceMain Function
• Writing a Control Handler Function

Related Topics

The Complete Service Sample

With that said, try something more like this:

I have been taught to understand that any arrangement (collection, selection, positioning etc.) of data is inherently information independent of the thing behing arranged.

The relevance of the above is that the columns and relationships represented by your various queries presumably critical to the understanding your database/application.

This means that you should be commenting and documenting them appropriately and likely separately as well.

I generally prefer to design databases (as best as I can) in a way that minimizes the amount of description necessary for future developers etc.

To do so I find that creating views based on queries such as those used in your example, naming them appropriately as well as naming the resulting columns and columns appropriate for where criteria appropriately very intuitive and easy to maintain.

In terms of performance I can't confidently advise or inform either way although I assume that it will be more influenced by the database design than sproc VS view.

conclusion: there is no 'better' way to accomplish this task independent of the broader contextual design strategy and requirements

You could try this:

document.getElementById("demo").innerHTML = obj.data.status;