May 13, 2000

Null values in WHERE clauses

A SELECT query returns all the rows for which the WHERE clause returns True. However, many developer – especially those accustomed to other programming languages, such as VB – get

Out-of-date dependency file for COMCTL32.OCX

Have you ever read a message like “Dependency file for COMCTL32.OCX is out of date” during the package creation process? The cause of this problem is simple: you have installed

Don’t use = operator on Date values

Date variables store values in floating point format, much like Double variables, with the integer part for dates and the fractional part for the time portion. Being floating point values,