McBean Information Technology

The Weird Syntax of SQL DELETE From a JOIN on May 22, 2009 in JOIN Syntax DELETE SQL Server SQL It is perfectly legal in most SQL dialects to DELETE records that come from a JOIN clause. However, I never remember the syntax because its kind of strange and I don't do it often.I wrote the following example in SQL Server 2005:delete from arledger...

Current Reading on Mar 6, 2009 in WPF Matthew MacDonald Visual Studio 2008 CSharp I'm currently reading Pro WPF in C# 2008 by Matthew MacDonald. So far it seems well written and I'm getting a good feel for WPF. I'm anxious to do my first WPF project but didn't want to just jump in without some background. However, ultimately you c...

Testing C# Class Properties With NUnit on Mar 5, 2009 in Unit Testing NUnut Properties CSharp TDD Pragmatic Programmer Classes In their book Pragmatic Programing Andrew Hunt and David Thomas argue that all programmers should adhere to the DRY principle. DRY stands for do not repeat yourself. Its a daily battle to keep my code library from descending into the usual cut and p...

Article on Setting Properties Dynamically on Mar 5, 2009 in Properties VB.Net Reflection For the previous post on NUnit and testing properties using reflection I was indebted to this article. The code examples in this article are in VB.Net.

Delphi: Iterating through components on Jan 1, 2009 in delphi7 delphi TComponent iteration TADOQuery pascal delphi is keyword The code example below shows how you can iterate through components in a Delphi form or data module, check the type of a hosted component and examine its properties. I wrote this as a unit test because the programmers were forgetting to remove their...

SQL Update with JOIN on Dec 30, 2008 in JOIN UPDATE SQL I was trying to remember how to do an SQL UPDATE statement using fields from a JOIN. Its one of those things I don't do very often, and the syntax is not exactly intuitive. Its a good example of the power of SQL.The general template for such a statem...