Posted by Jeroen Pluimers on 2014/01/22
A while ago, I came across an interesting post Bad Habits to Kick : Using AS instead of = for column aliases by Aaron Bertrand, a major contributor on SQLblog.com – The SQL Server blog spot on the web.
The last link indicates my problem with this “AS” versus “=”: it is SQL Server specific.
So, if you mainly use SQL Server, then it is OK (or even preferable) to use “=” for aliasing columns in human written SQL as it makes spotting the names used much easier. Read the rest of this entry »
Posted in Access, Database Development, DB2, Development, Firebird, InterBase, MySQL, OracleDB, Paradox, PostgreSQL, SQL, SQL Server, Sybase | Leave a Comment »
Posted by Jeroen Pluimers on 2011/11/29
A co worker at a client had trouble importing textual date strings into Microsoft access.
Since many databases like yyyy-mm-dd as a universal import date format, I suggested trying that and searching for some backing on the Internet.
Indeed this StackOverflow answer confirmed my gues.
Via: vba – Parse data and time string to Access Date value – Stack Overflow.
Posted in Access, Database Development, Development, Software Development | Leave a Comment »
Posted by Jeroen Pluimers on 2011/03/14
There are truckloads of differences in SQL between Microsoft Access and SQL Server.
This Convert Microsoft Access JET SQL to SQL Server T-SQL Cheatsheet helps you convert between the two.
It doesn’t cover the parenthesis thing that Access needs on joins, but you can read on that here, here and here.
Posted in Access, Database Development, Development, SQL, SQL Server | Leave a Comment »
Posted by Jeroen Pluimers on 2010/07/29
One of the toughest parts on creating a new CodePlex project is choosing a license.
As Jeff Attwood wrote a couple of years ago, choosing a license – any license – is important, because if you don’t, you declare an implicit copyright without explaining how others could use your code.
In addition to that, Jeff published a list of licenses with a one-line phrase describing them, so it becomes easier to start making a choice.
Last year, ShreevastaR extended that list in his answer to this StackOverflow.com question on CodePlex licensing.
Brian Campbell did the same a few months later on another StackOverflow question about CodePlex licensing.
There are many more StackOverflow.com threads like those 2, and they give similar results.
The reason I want to put up a CodePlex project, is to put my sample code for conferences, blog articles and course examples on-line so they are easier to share with other people.
Most is from Visual Studio or Delphi projects using languages C#, VB.NET and Delphi.
Some of it are batch-files, XSD, XSLT, or other small snippets to get stuff working. Read the rest of this entry »
Posted in .NET, Access, CodePlex, Database Development, Delphi, Development, Firebird, InterBase, Software Development, SQL Server | 4 Comments »
Posted by Jeroen Pluimers on 2010/03/17
Sometimes you wish there was some universal translation table to get the English error messages.
Just got this at a client:
Project Foo.exe raised exception class EOleException with message ‘De bewerking moet worden uitgevoerd op een query die kan worden bijgewerkt‘.
The English translation of the error message is “Operation must use an updateable query” (which is also wrong: the query is indeed updateable).
But not knowing that English translation beforehand, how do you find out the cause?
Read the rest of this entry »
Posted in Access, Database Development, Delphi, Development | 2 Comments »