Programming

Just a simple function to get the week number from a date.

The problem: On a windows form there is a FolderBrowserDialog added. There is a button to use the FolderBrowserDialog. Wen you click the button the FolderBrowserDialog is used. All word fine. Until it is deployed, then the dialog screen comes up with no tree to browse or select a folder. Why? How?

The event to use is ColumnDividerDoubleClick. Yes this works BUT there is one problem. If you use the event DoubleClick (or similar) then it is possible that you will not will not see the ColumnDividerDoubleClick event triggered.

This error is a bug. See BUG: “Old format or invalid type library” error when automating Excel. There are 3 workarounds i choose for this one:

Neither Hide() nor setting Visible=False will work with TabPages. You can remove them through the TabControl’s Controls collection or the TabPages collection using the Remove method.

How do you alter the columns of the table? Think off NULL vs NOT NULL, or Char(1) –> Char(2)

Do you have this problem: Error: “Cannot bind to the new display member. Parameter name: newDisplayMember”, while filling the ValueMember

Some problems with DbProviderFactories.GetFactory and Firebird (embedded) i found a solution.

Make these folders unversioned by exporting them to themselves. That is: Tortoise SVN context menu export, select folder, select the folder the files are allready in, Tortoise SVN will ask for a confirmation.

EXECUTE PROCEDURE TOWN_I (‘TownA’); if TownA is in the db the returnvalue will be 999 else it will be 998.