Guidelines, code

• Variables

  • Avoid class members if possible (pass variables as arguments)
  • Declare variables before loops
  • Cleanup variables if neccessary (close connections etc)
  • Avoid creating object instances before they are needed

• SQL

  • All SQL should be uppercase
  • All SQL should be platform independant
  • Think DB-performance when building your SQL
  • Do not retreive more data than you need

• No hardcoding

  • Use system settings to store application constants if possible
  • Use System.-methods to read platform dependant values

Notes: