McBean Information Technology
Blog URL http://mcbeanit.blogspot.com/
Located Calgary, Alberta Canada
Tags software, programming, information, database, .net, csharp, crystal reports, sql
Information Technology Blog. Programming,Software Development and other stuff
Latest Blog Posts
- 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...
