Access VBAcode blocks are surrounded by statement ending keywords that all use End such as End Sub, End If, and WEnd.

Sub x

End Sub

If x Then

End If

While x

WEnd

Microsoft's official Access home page.

UML is a modeling language for specifying, visualizing, constructing, and documenting the artifacts of a system-intensive process. This guide introduces you to the 9 standard diagrams in the UML 1.4 specification. These diagrams can be divided into two groups: Structural diagrams, which model the organization of the solution, and Behavioral diagrams, which model the functionality of the solution.

When an object instance is created from a class, ASP calls a special parameter-less sub named Class_Initialize. Since you cannot specify parameters for this sub, you also cannot overload it.

When a class is destroyed, ASP calls a special sub called Class_Terminate.

Class Cyborg
  Public CyborgName
 
  Public Sub Class_Initialize
   Response.Write "<br>Class created"
   CyborgName = "Cameron"
  End Sub 

End Class

What is the syntax in ASP Classic for using an associative array?

Use a dictionary:

Dim StateList

set StateList = Server.CreateObject("Scripting.Dictionary")
 

StateList.Add "CA", "California"

Response.Write "NV is " & StateList("NV")

For more examples, refer to our ASP Classic Associative Array (Scripting.Dictionary) article.

Boxing is the conversion of a value type to the object type (or to any interface type that is implemented by the value type). Unboxing is the conversion from an object type to a value type (or from an interface type to any value type that is implemented by the value type).

In C#, a constructor is called whenever a class or struct is created. A constructor is a method with the same name as the class with no return value and you can overload the constructor. If you do not create a constructor, C# will create an implicit constructor that initializes all member fields to their default values.

Constructors can execute at two different times. Static constructors are executed by the CLR before any objects are instantiated. Regular constructors are executed when you create an object.

C# supports both static members and static classes using the static keyword. You can add a static method, field, property, or event to an existing class. Also, you can designate a class as static and the compiler will ensure all members in that class are static. You can add a constructor to a static class to initialize values.

The CLR automatically loads static classes with the program or namespace.

//Static Class Example
public static class MyStaticClass
{

  //Static Method Example

  public static void MyStaticMethod()
  {
  // static method code
  }

}

Microsoft portal site for the ASP.NET development community.

Can I use a Win32 DLL in my Visual Studio.Net application?

Yes. The trick is to use the [DllImport] attribute, followed by declarations for each of the DLL's functions and procedures.

Same as standard C++. For C++, Java, JavaScript, and PHP, I prefer to put the first { at the end of the first line of the code block as in the example above because I see more C++ formatted that way.

int Dog::Bark() {
 cout << "My first class method!" << endl;
 return 0;
};

Lots here!  C++Builder TV is part of CodeGear's developer network. Contains both audios and videos.

Yes, you can build .Net runtime applications with Microsoft's Visual C++ as well as building native code Win32 applications and rich 2D and 3D games with The Game Creators SDK. You can use it to create other types of applications too including MFC and Smart Devices applications.

some tips for data migration, especially with bitfield, or "logical" field types.

by Jeffrey K. Tyzzer. In 1970, Dr. E.F. Codd's seminal paper "A Relational Model for Large Shared Databanks" was published in Communications of the ACM. This paper introduced the topic of data normalization, so-named because, at the time, President Nixon was normalizing relations with China.

Data normalization is a technique used during logical data modeling to ensure that there is only one way to know a fact, by removing all structures that provide more than one way to know the same fact as represented in a database relation (table). The goal of normalization is to control and eliminate redundancy, and mitigate the effects of modification anomalies -- which are generally insertion and deletion anomalies. (Insertion anomalies occur when the storage of information about one attribute requires additional information about a second attribute. Deletion anomalies occur when the deletion of one fact results in the loss of a second fact).

Normalization
There are six generally recognized normal forms of a relation: first normal form, second normal form, third normal form, Boyce/Codd normal form, fourth normal form, and fifth normal form, also called projection/join normal form. Other normal forms (e.g., Domain/Key) exist but will not be discussed here. The normal forms are hierarchical, i.e., each normal form builds upon its predecessor. Although many people consider a relation to be normalized only when it is in third normal form, technically speaking, a relation in only first normal form can be considered...

When we create applications, we usually need one or more icons. We'll definitely want a main program icon - in several sizes. We may also want another icon for our setup program.

Sometimes our client supplies icon files, but often they do not.

There are some great tools available for creating and managing Icons. One of my favorites, IconLover, is available at the site this link is about.

But most out-of-the-box, general purpose graphics editors lack support for the Windows .ICO file format. The solution is at this link, and it's free: It's a plug-in for Photoshop and Paint Shop Pro (even some version of Photoshop Elements).

At the bottom of this link's page, you'll find an entry for "Icon Plug-In for PhotoShop." Simply download the zip file, unzip, and follow the instructions in the ReadMe.txt file.

Your favorite, general purpose graphics editor will now be able to deal with ICO files!

A Char field is a text field of a specific length. For example, a Char(50) field takes up 50 characters of storage in most databases even if you only store 1 character in it., or even none. 

A VarChar field is a text field of variable length. For example, a VarChar(50) field can be up to 50 characters but if less is stored, the length of the field is somewhat less than 50. If you only store 1 character in a VarChar, then generally only 1 character of space is taken up in storage.

The "N" in NChar and NVarChar stands for National character which means you can store unicode text. NChar and NVarChar take up twice as much storage space.

In this first installment of a New Knowledge Base Series I'll discuss The TForm.OnCloseQuery Event which too frequently goes unhandled.

Delphi is a hybrid language so you can create either class methods (functions and procedures) or you can create global functions and procedures. When a function or procedure is part of a class, it is a class method.

[function/procedure] RoutineName : ReturnType;

As with C++, your custom routine must come before it's first usage or you have to prototype it in the Interface section.

Note: Contrast Delphi with Delphi Prism which is an OOP language (everything is within a class). Both Delphi and Delphi Prism are based on Object Pascal but implement OOP features differently and have some syntax differences too.

procedure SayHello(pName: String);
begin
  ShowMessage('Hello ' + pName);
end;

function Add(p1, p2 : Double): Double;
begin
  Result := p1 + p2;
end;

Italian writer who also writes quite a bit in english. He now contributes articles mainly to PDJ and to his own web site.

Use the public methods ForegroundColor and BackgroundColor. For example, in the OnChange event of a ColorGrid component you could do the following:

procedure TForm1.ColorGrid1Change(Sender: TObject); 

begin

   Edit1.Font.Color := ColorGrid1.ForegroundColor;

   Edit1.Color := ColorGrid1.BackgroundColor;

end;

None of the components on the "Samples" page are documented.

Implementing design patterns can be difficult and little sample code exists that walks you through the process. The purpose of this article is to walk through the implementation of a program that uses the Composite and Visitor design patterns. The sample project is written in the object-oriented language, Java, but it could just as easily have been written in C++.

Java String Cancatenation

In Java, you use either the String concatenation + operator or StringBulder class methods such as append. Since Java compilers frequently create intermediate objects when the + operator is used and don't when StringBuilder.append is used, the append method is faster than the + operator.

In general, use the convenience of a + operator when speed is not an issue. For example, when concatenating a small number of items and when code isn't executed very frequently. A decent rule of thumb is to use the + operator for general purpose programming and then optimize the + operator with StringBuilder.append as needed.

Simple + operator example:

System.out.println("Hello" + " " + "Mike.");

Using StringBuilder example:

StringBuilder myMsg = new StringBuilder();
 

myMsg.append("Hello ");

myMsg.append("Mike.");

 
System.out.println(myMsg);

The Eclipse IDE for Java EE Developers contains everything you need to build Java and Java Enterprise Edition (Java EE) applications. Considered by many to be the best Java development tool available, the Eclipse IDE for Java EE Developers provides superior Java editing with incremental compilation, Java EE 5 support, a graphical HTML/JSP/JSF editor, database management tools, and support for most popular application servers.

Lots here!  JBuilder TV is part of CodeGear's developer network. Contains both audios and videos.

Implements replaceAll in javascript. This is achieved using prototype.js

Add this between the head tags (replace [[ with < and ]] with >):

[[script type="text/javascript" src="prototype.js"]] [[/script]]

Here's the code (replace [[ with < and ]] with >):

[[script type="text/javascript"]]

// define your replace all function like this 

String.prototype.replaceAll=function(s1, s2) 

{return this.split(s1).join(s2)}; 

// use your replaceAll function like this

var replacedText = text2replace.replaceAll("-what to replace-",

		" -with what to replace- "); 

[[/script]]

JavaScript is useful for adding interactivity to the World Wide Web because scripts can be embedded in HTML files (i.e., web pages) simply by enclosing code in a tag pair. All modern browsers can interpret JavaScript -- albeit with some irritating caveats. (More about them below.)

In practice, JavaScript is a fairly universal extension to HTML that can enhance the user experience through event handling and client-side execution, while extending a web developer's control over the client's browser. And that's worth a FAQ.

ObjectPAL logical operators:

and	and, as in this and that
or	or, as in this or that
Not	Not, as in Not This

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

if Not (a and b) and (c or d) then

  ;Do something.

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 Mark Bannister. A compilation of rules and tips scoured from the Paradox Community.

How can I purchase Paradox?

Answer from Corel...

Paradox was not updated from Paradox 10. It was given a new look, but the functionality remains mainly the same. Paradox 11 is available in the WordPerfect Office Professional version and can be purchased through Corel's online store or by calling us [Corel].  Paradox is also available as a standalone if you already own WordPerfect Office, and is [available] through our licensing program.  Within North America, please call 1-800-772-6735, Corel's Customer Support Services, to purchase the Paradox upgrade. We are open from Monday - Friday, 9:00 am - 7:00 pm E.S.T. and would be happy to serve you. For customers outside of North America, please visit www.corel.com/contact to locate a Corel Customer Support Services Center nearest you.

Common comparison operators:

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

#Does Perl evaluate the math correctly? No!

if ((.1 + .1 + .1) == .3) {
  print("Correct<br>");
} else {
  print("Not correct<br>");
}

ActivePerl is the industry-standard Perl distribution, available for Windows, Linux, Mac OS X, Solaris, AIX and HP-UX. Developers worldwide rely on ActivePerl's completeness and ease-of-use, while corporate users protect their infrastructure and stay competitive with quality-assured ActivePerl business solutions.

Includes core Perl, popular modules, the Perl Package Manager (PPM), and complete documentation. The Windows version provides additional features that have made ActivePerl the worldwide standard for Perl on Windows.

An Introduction to PHP. Installing PHP on Your Computer and Running your First Script.

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.

};

Overview and introduction by Nick Hodges (Delphi for PHP product manager).

What PHP version does Delphi for PHP support?

Delphi for PHP is based on PHP version 5. Meaning, the VCL for PHP extends the standard libraries that ship with PHP 5. This also means you can deploy your Delphi for PHP website on any hosted website that has PHP 5 installed.

Note: You can deploy your Delphi for PHP websites on the hosted websites we offer on our http://www.prestwoodhosting.com web hosting services website.

Member points information.

The Prism unary operators are:

+
-
Not

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).

In Prism, the Object keyword is an alias for the base System.Object class and is the single base class all classes ultimately inherit from.

//Specify both namespace and class:

Cyborg = class(System.Object)
end;

//Use Object keyword for System.Object.

Cyborg = class(Object)

end;

//When none, default is System.Object.

Cyborg = class

end;

This page provides a summary of Delphi Prism syntax differences for customers familiar with Win32 Delphi.

How close is the syntax for Delphi for Win32 and Delphi Prism?

Pretty close. You will definately be comfortable but there are differences. Delphi Prism includes a "compatibility" switch you can use that will enable certain "Delphi for Win32" language features so you can increase your comfort level. This option can be set on a per-project basis as part of the project options tab.

Although I'm just getting started, I will be documenting differences in my Delphi and Prism Cross Reference Guide. This guide will help when you switch from one language to the other.

They don't really. In PSDP Online, you set the PSDP Phase of tasks and their two sub-types defects and artifacts only. Requirement Items, Design Items, and Test Scripts do not use the concept of PSDP Phases because they are documentation-only items. You add various development tasks set to the appropriate phase to create, flesh out, and use them to build and test but they do not contain workflow themselves.

The PSDP Phase of Defects is always Phase 6 Testing & Rework. Although Tasks and PSDP Artifacts can be set to any PSDP Phase, their default is Phase 2 Requirements. For PSDP Artifacts, most of the time you will leave it set to it's default. On the other hand, you will set tasks to whatever phase the task belongs to.

Do I need different connectors for Cat 6 then what I'm currently using for Cat 5?

No, Cat 5, 5e, 6, and 6a all use the same RJ-45 connectors and are downward compatible. Meaning you can use a Cat 6 cable in a Cat 5 network. The difference is in the quality of the cable. Cat 5e is rated higher than Cat 5, Cat 6 is rated higher than Cat 5e, etc.

However, when building a Cat 5 or Cat 6 cable, you have to use the correct type of connector. Meaning, Cat 6 connectors are built differently even though you can use already made cables.

Converts HLP files to many formats including PDF, RTF, HTML, DOC, CHM, TXT, DBF, XML, CSV, XLS, MDB, MCW, etc.

Help and Manual is a mature, and reasonably-priced, authoring tool for WinHelp, Compiled HTML Help (CHM); plus PDF, and Word documentation.

Under the covers, your authoring project is maintained in XML.

It can convert existing help and documentation from a number of formats, and it is very author-friendly.

Crystal Reports was very popular with VB Classic developers and came bundled with Visual Basic 3 through 6. VB6 offers both Crystal Reports and the new Microsoft Data Report Designer.

Declare and implement VB.Net classes after the form class or in their own .vb files. Unlike VB Classic, you can have more than one class in a .vb class file (VB classic uses .cls files for each class).

VB.Net supports abstract class members and abstract classes using the MustInherit and MustOverride modifiers.An abstract class is indicated with a MustInherit modifier and is a class with one or more abstract members and you cannot instantiate an abstract class. However, you can have additional implemented methods and properties. An abstract member is either a method (implicitly virtual), property, indexer, or event in an abstract class. You can add abstract members ONLY to abstract classes using the MustOverride keyword. Then you override it in a descendant class with Overrides.

VB.Net logical operators:

And	and, as in this and that
Or	or, as in this or that
Not	Not, as in Not This
Xor	either or, as in this or that but not both

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

If Not (a and b) and (c or d) Then

  'Do something.

End If

How do you launch a Windows application in VB.Net? How do I open the default browser to a specific URL?

'Launch a Windows application.
System.Diagnostics.Process.Start("notepad.exe")

'Or just...

Process.Start("calc.exe")

'Open a website with the default browser.
System.Diagnostics.Process.Start("http://www.prestwood.com")

There is a way to configure your ASP.NET website with one configuration for your internal development environment and another for your online website - and still be able to publish your site without hand editing the web.config.

DHTML Menu Builder is the tool of choice for building Javascript menus for our Prestwood family of websites.

Complete dhtml menus can be built, in a matter of minutes, without writing a single line of code.
No special plugins and no programming or HTML knowledge required, with just DHTML Menu Builder you'll be able to create great looking and functional dhtml menus for all your web sites.

Why do images sometimes resize smaller well, and sometimes not? Sometimes when I resize an image to a small 100 pixel width or less image it looks great and sometimes it's very choppy.

1. You probably need to increase the number of colors prior to resizing. Some programs will do this for you automatically and some don't. For example, when working with a transparent GIF or PNG, the color palette is set to 256. If you shrink a transparent GIF or PNG, it will likely look choppy. However, if you increase the number of colors to 16-bit or higher, than resize, it looks great. Of course, you'll have to reapply transparency.

2. Various programs use various algorithms to resize images, make sure you try them all.

This is our security and privacy policy. You are welcome to use it for your website. You will most likely want to update it a bit as it's pretty specific to our website.

With the size of applications and data, my belief is that you need a minimum of 1 GB of RAM but 2 GBs is better. Unless you run lots of applications at the same time, there is no real need for more than 3 GBs of RAM.

By the way, in Windows Vista, the caching scheme changed. Vista's SuperFetch built on and replaced Prefetch. Unlike Prefetch, SuperFetch will use up ALL memory for caching you give it so you want as much memory on Vista as you can afford and your hardware will allow. Vista 32-bit has a general limit of 4 GB and Vista 64-bit has a general limit of 128 GB.