Posted January 27th, 2010 by Wesley
When I stumbled upon this error “parameter @columnName has no default value”, first thing I tried was Google, of course. When googling, I found lots of answers for this problem, but they all resulted in the following solutions:
Parameter name is different in the query and when declaring the parameter (wrong columnName, or wrong parameter assigned [...]
Tags: ado.net, DbCommand, nullable, OleDbCommand, prepared statement
Posted March 12th, 2009 by Wesley
When you are (still) using ODBC or ADODB to update memo fields in a FoxPro table, you might run into the problem that all of your rows are updated instead of just the one when using AppendChunk. This is probably caused by the fact that memo’s are stored in a separate FPT file, organized in [...]
Tags: adodb, appendchunk, command, foxpro, memo, odbc
Posted September 25th, 2008 by Wesley
I encountered something weird yesterday evening. In a MaskedTextBox, I wanted to select the entire text when a user enters the box, using the SelectAll method in an Enter event handler. It didn’t work…
Fortunately, we have Google! After a quick search I found someone with the same problem and a solution. By simply invoking (and [...]