Access VBA is a non-OOP language with some OOP features. It offers both Subs and Functions. A Sub does not return a value while a Function does. When Subs and Functions are used in a class module, they become the methods of the class.

Save as VB Classic.

//Does Access evaluate the math correctly? No!

If 0.1 + 0.1 + 0.1 = 0.3 Then
  MsgBox "correct"
Else
  MsgBox "not correct"
End If

Store the image outside of your MDB Access database. There are many benefits to storing it outside of Access including the following:

• More easily work with all the images at once.
• avoid the overhead of an OLE server
• decrease the size of your MDB file
• easily reuse images with other development tools such as a website, VB, VS.Net, etc.
• Metadata is preserved

If the analyst is qualified sure, but if they're not, don't push it. Many times a resource was made the analyst not because they are a great analyst but because they have great people skills, know the domain well, and can document process well. Under that scenario, I prefer a programmer analyst work with the business analyst to identify entities and attributes. If the analyst is not good at documenting process, find a new analyst.

In PSDP, we overcome this problem by creating the database and GUI prototype during the requirements phase. By forcing the creation of the database while discovering what the client wants, you force the identifying of entitities and attributes.

In UML, sometimes analysts create class diagrams to create the database. The Data Model is a much better choice.

The End If is optional if you put your code on a single line.

The member visibility modifiers are Private and Public. If not specified, the default is Public. Private and Public have the usual meaning. Private members are visible only within the class block. Public members are visible within the class and outside of the class.

Literals are quoted as in "Prestwood".  If you need to embed a quote use two quotes in a row.

Response.Write "Hello"

Response.Write "Hello ""Mike""."

'Does ASP evaluate this simple

'floating point math correctly? No! 

If (.1 + .1 + .1) = .3 Then
 Response.Write "Correct"
Else
 Response.Write "Not correct"
End If

Although this question really depends on the provider, in general, the answer is no to MS Access views and yes to MS SQL Server views so long as you open the RecordSet editable.

A quick example to demonstrate the yield keyword in the .NET Framework

Method overriding allows you to define or implement a virtual method in a parent class and then replace it in a descendant class. In C#, you specify a virtual method with the virtual keyword in a parent class and replace it in a descendant class using the override keyword.

Classes and structs can inherit from interfaces in a manner similar to how classes can inherit a base class or struct, but a class or struct can inherit more than one interface and it inherits only the method names and signatures, because the interface itself contains no implementations.

class MyClass: IMyInterface

{  

  public object Clone()
  {
  return null; 
  }  

// IMyInterface implemented here...
} 

interface IMyInterface

{

  bool IsValid();

}

General Info: Round Floating Point Numbers

When comparing floating point numbers, make sure you round to an acceptable level of rounding for the type of application you are using.

Languages Focus: Comparison Operators

A comparison operator compares two values either literals as in "Hello" and 3 or variables as in X and Counter. Most languages use the same operators for comparing both numbers and strings. Perl, for example, uses separate sets of comparison operators for numbers and strings.

//C++Builder example (ShowMessage is a VCL method).

//Does C++Builder evaluate the math correctly? No!

If (.1 + .1 + .1 == .3)
  ShowMessage("correct");
else
  ShowMessage("not correct");

You turn on ASPX in your control panel. Depending on what O/S and version of IIS there are slightly different steps required but essentially you go to the Add/Remove Programs, Alter Windows Components, and make sure ASPX is checked in the Application Server or Application Development Services.

More Info / Details - http://support.microsoft.com/default.aspx?scid=kb;en-us;332124&Product=winsvr2003

This page is a reference of the various Microsoft Certifications available to developers.

• Microsoft Certified Technology Specialist - Microsoft Certified Technology Specialist (MCTS) certifications enable professionals to target specific technologies and to distinguish themselves by demonstrating in-depth knowledge and expertise in the various Microsoft technologies with which they work.
• Microsoft Certified Professional Developer - The Microsoft Certified Professional Developer (MCPD) credentials distinguish you as an expert Windows Application Developer, Web Application Developer, or Enterprise Applications Developer.  These credentials demonstrate that you can build rich applications that target a variety of platforms using .NET Framework 2.0.
• Microsoft Certified Architect Program - Microsoft Certified Architect Program targets practicing solutions architects and infrastructure architects who successfully apply frameworks and methodologies to create an architecture through the entire IT lifecycle.
• Microsoft Certified Learning Consultant - The Microsoft Certified Learning Consultant (MCLC) credential recognizes MCTs whose job roles have grown to include frequent consultative engagements with customers. These MCTs are experts in designing and delivering customized learning solutions.
• Microsoft Certified Database Administrators - Microsoft Certified Database Administrators (MCDBA) design, implement, and administer Microsoft SQL Server Databases.
• Microsoft Certified Trainer - Microsoft Certified Trainers (MCT) are qualified instructors certified by Microsoft to deliver Microsoft training coursesto IT professionals and developers.
• Microsoft Certified Application Developers - Microsoft Certified Application Developers (MCAD) use Microsoft technologies to develop and maintain department-level applications, components, Web or desktop clients, or back-end data services.
• Microsoft Certified Solution Developers - Microsoft Certified Solution Developers (MCSD) design and develop leading-edge business solutions with Microsoft development tools, technologies, platforms, and the Windows architecture.

BLOBs (Binary Large Objects) are collections of data that can be stored as a single entity in a database. In Microsoft SQL Server, BLOBs are stored using the text, ntext, and image data types.

• The text data type stores a variable length of non-unicode data up to 2³¹ - 1 characters.
• The ntext data type stores a variable length of unicode data up to 2³⁰ - 1 characters. The storage size, in bytes, is twice the amount of characters.
• The image data type is used to store image files smaller than 2³¹ - 1 bytes.

In Delphi, you define constants similar to how you define variables but use the Const keyword instead of the Var keyword. Declare global constants in a unit's interface section and unit constants (scope limited to unit) in the implementation section. Declare local constants above the begin..end block.

How often have you started a new Delphi project, then spent some time fleshing out the default main form provided by Delphi?

This task only needs to be done once or twice. Delphi then allows us to re-use this work at the start of each new project.

Source code is included.

Declare global variables in the interface section of a unit, variables declared within the implementation section (but not within a method) have a scope limited to the unit. You declare local variables in a var block outside (above) your begin..end code block. You cannot declare variables in-line (inside begin..end). You can initialize global and unit variables but you cannot initialize local variables. Delphi offers many variable types. Some common variable types include String, WideString, PChar, Integer, Boolean, Single, Double, Pointer, and Variant.

procedure SomeProcedure;

var
  Fullname: String;
  Age: Integer;

  X, Y, Z: Double;

  MyArray: array [1..100] of Char;

begin

end;

//You can initialize global variables.

var

  ClickCounter: Integer = 0;

Can I call a DotNet DLL from my Delphi Win32 application? For example, with Delphi 7 or Delphi 2010?

It's not easy because the .NET RTL resides in a different process. You can wrap up the DotNet DLL into an ActiveX control and call it or have both your app and the DotNet DLL write to the registry, a file, etc. By the way, you CAN wrap up a Win32 DLL in a DotNet DLL and call it from DotNet.

Java is case sensitive.

Customary casing:

• Classes - Initial Caps (Pascal Casing)
• Variables - Initial lowecase (Camel case)
• Methods - Initial lowecase (Camel case)

Creating classes in JavaScript is not really OOP, but rather a super type. That is, a type that has some class-like features but is missing the necessary OOP requirements.

There is nothing in Javascript to stop you from accessing the functions within your class outside of the class so this is not fully OOP but is usable.

//Class definition.

function Person() {
this.name = 'unknown';
this.age = 0;
}

//Use object created from class.

var Lisa = new Person();

Lisa.name='Lisa';

Lisa.age=28;

Exploring ObjectPAL's TCursor object type.

Using Paradox internet features. Content from chapter 25 of my "Paradox Power Programming: The Official Guide" book.

Common comparison operators:

=	equal
<>	not equal
<	less than
>	greater than
<=	less than or equal
>=	greater than or equal

'Does ObjectPAL evaluate the math correctly? No!

If .1 + .1 + .1 = .3 Then
  msgInfo("", "correct")
Else
  msgInfo("", "not correct")
endIf

Contains downloads for Paradox for DOS, Paradox for Windows, and BDE. Lots of good stuff to download including runtimes and service packs.

Maintained by Lance Leonard and contains a wealth of information. I remember Lance from back when I worked at Borland in the mid-90s. His website covers Paradox, Delphi, and other technologies.

Does Paradox for DOS' CPUTest.EXE run on Vista?

Ok, that's a bit of a silly question, but yes it does. It may not appear to run but if you tell Windows not to close on exit, it works just fine.

1. Right click on CPUTEST.EXE, select Properties.
2. From the Program tab, uncheck Close on exit.

By the way, my dual core 2 GHz CPU passed.

Perl logical operators:

&& or and	and, as in this and that
|| or or	or, as in this or that
!	Not, as in Not This

#Given expressions a, b, c, and d:

if !((a && b) && (c || d)) {

  #Do something.

}

PHP logical operators:

and, &&	and, as in this and that
or, ||	or, as in this or that
!	Not, as in Not This
Xor	either or, as in this or that but not both

#Given expressions a, b, c, and d:

if !((a && b) && (c || d)) {

  #Do something.

};

Hear David I discuss software development on a nationally syndicated radio show. I posted this to the PHP group because he focused a bit on Delphi for PHP and PHP in general.

Can I share code between a Delphi and a Dephi Prism project? I want to have a single source Win32 and .Net application.

Same as Delphi. In Prism, you specify a virtual method with the virtual keyword in a parent class and replace it in a descendant class using the override keyword. Call Inherited in the descendant method to execute the code in the parent method.

With Prism, you use the Interface keyword to define an interface and then you include one or more interfaces where you specify the single class inheritance (separated by commas).

//Interface section of unit.
IHuman = public interface
  //Specify interface methods and properties here.
end;
  
TCyborg = public class

end;

TCyborgHuman = public class(TCyborg, IHuman)
  //Specify each here and implement in 
  //implementation section.

end;

Oxidizer is a free tool that (in combination with ShineOn) is provided to help to port Delphi (Win32 and .NET) projects to the Delphi Prism language. Oxidizer is a command line tool that will adjust your .pas source files for common differences between the two languages.

This wiki is provided as a central live source of information about Delphi Prism and will be updated in an ongoing process.

This change management procedure is specific to Prestwood Software Development Process (PSDP).  PSDP is our free process we maintain and distribute as well as use with our own clients. Althought this is specific to PSDP, you can read it with an eye toward your own change management procedure. Do you use version control software? Do you use promotion groups?

The key aspects of learning evolve by sharing or exchanging information with your peers. For a technical writer, it is very much important to focus/target towards a technical topic. This article presents a short information about the key aspects of learning and the methods/techniques used to enable the learning curve.

We're all familiar with program help systems. At Prestwood, of course, we need to author them for many of the applications we create.

There are many help authoring tools available, and HelpScribble is one of my two favorites.

Now, even though you may not need to create program help systems, help files, on their own, can be a great way to organize and convey all manner of information. Because they can contain a table of contents, an index, search capabilities, hyperlinks from one topic to another, and embedded graphics, they can be a wonderful way to document many kinds of complex information - say a training manual for new workers - in just about any industry.

The people at Just Great Software like to say that, "If you can scribble, you can create help systems." They're right: HelpScribble makes it about as easy as it could get. Naturally, HelpScribble includes an extensive help system of its own, which will teach you everything you need to know.

HelpScribble can produce

• WinHelp (.hlp files),
• Compiled HTML Help (.chm files),
• Rich Text Format (.rtf files) for printed manuals, and
• Multi-page HTML output - suitable for web help.

At only $99, this is one of the best software bargains I've encountered.

You can read all about HelpScribble, and download a free trial here:
http://www.helpscribble.com/

VB Classic is a non-OOP language with some OOP features. It offers both Subs and Functions. A Sub does not return a value while a Function does. When Subs and Functions are used in a class module, they become the methods of the class.

Literals are quoted as in "Prestwood". If you need to embed a quote use two quotes in a row.

MsgBox ("Hello")

MsgBox ("Hello ""Mike"".")

'Does VB evaluate this simple

'floating point math correctly? No! 

If (.1 + .1 + .1) = 0.3 Then
  MsgBox "Correct"
Else
  MsgBox "Not correct"
End If

In VB.Net, you specify a virtual method with the Overridable keyword in a parent class and extend (or replace) it in a descendant class using the Overrides keyword.

Use the base keyword in the descendant method to execute the code in the parent method, i.e. base.SomeMethod().

With VB.Net, use the NotInheritable keyword to prevent a class from being inherited from and use the NotOverridable keyword to prevent a method from being overridden.

A method marked NotOverridable must override an ancestor method. If you mark a class NotInheritable, all members are implicitly not overridable so the NotOverridable keyword is not legal.

Public Class Machine

  Public Overridable Sub Speak(ByRef pSentence As String)
    MessageBox.Show(pSentence)
  End Sub
End Class

Public Class Robot
  Inherits Machine

  Public NotOverridable Overrides Sub Speak(ByRef pSentence As String)
    MessageBox.Show(pSentence)
  End Sub
End Class

Public NotInheritable Class Cyborg
  Inherits Robot
End Class

Do you want free software? You know you do!

Did you know that Microsoft offers tons of free software? Most of us know of a few free titles, like the Express editions of Visual Studio and SQL Server.

But there's more, much, much more.

At this link you'll find a great compilation of free software offerings from Microsoft.

For similar Vista offerings, see the link below.

Windows Update installs new operating system features and fixes. Microsoft Update does that too but also updates some Microsoft products such as Office updates. Depending on which operating system you are using, you may already be using Microsoft Update. To check, go to Windows Update and check the settings for a Use Microsoft Update option or a checkbox that asks you if you wish to stop using Microsoft Update in favor of just using Windows Update.