Tip Bank

DevX - Software Development Resource

Double-Count in a SQL Query

Question: I want to create two count-variables in one SQL query based on GROUP BY signum_chef. Is that possible? I’ve tried something like this: SELECT DISTINCT signum_chef, Antal=(SELECT COUNT (*)),

DevX - Software Development Resource

Updating the End Date Field

Question: I have written the following SQL statement and want to update only the end date field (saaphy01.n5ajdd) in one file. How can I tell it in my query to

DevX - Software Development Resource

Track changes in system time and display resolution

Whenever the system time or the display resolution changes, Windows sends all the top-level windows (forms, in VB jargon) the WM_TIMECHANGE or WM_DISPLAYCHANGE message, respectively. Therefore, you can easily determine

DevX - Software Development Resource

Optimized Paint procedures with subclassing

The Paint event doesn’t provide with information about which region of the form must be actually repainted, and therefore forces the programmer to repaint the entire client area, which in