Access VBA is not case sensitive. Like VB Classic, if you type any other case for command or variable names, Access VBA will change it to the "accepted" or "defined" case. For example, if you type msgbox it is converted to Msgbox.

The following code works:

MsgBox ("hello")

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.

To redirect from http to https, check the Request.ServerVariables HTTPS field and then use Response.Redirect if set to "off".

Commenting Code
ASP Classic, like all the VB-based languages, uses a single quote (') or the original class-style basic "REM" (most developers just use a quote). ASP Classic does NOT have a multiple line comment.

Preprocessor Directives - @ and #
An @ is used for preprocessor directives within ASP code (within <% %>) and a # is used for HTML-style preprocessor directives.

Note: ASP Classic does not support VB Classic's #If directive.

'Single line comment.

REM Old school single line comment.

Common Preprocessor Directives include:

<%@LANGUAGE=VBScript%>

<!-- #Include File="includes.inc" -->

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.

C# supports abstract class members and abstract classes using the abstract modifier. An abstract class 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 abstract keyword.

With C#, use the sealed keyword to prevent a class from being inherited from and to prevent a method from being overridden.

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

public class Machine : System.Object
{
  public virtual void Speak(String pSentence)
  {
    MessageBox.Show(pSentence);
  }
}
    
public class Robot : Machine
{
  public sealed override void Speak(String pSentence)
  {
    MessageBox.Show(pSentence);
  }
}

public sealed class Cyborg : Robot
{ 
}

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.

C++ logical operators:

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

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

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

  //Do something.

}

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.

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

Like our community, they cover many databases and languages. The focus of this website is on databases - both desktop and server.

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.

Common source code file extensions include:

• .BDSPROJ - Project, Borland Developer Studio project file holds compiler options, etc. This is the file you open.
• .DCU - Delphi Compiled Unit file.
• .DFM - Delphi Win32 form file (a text resource file).
• .DPR - Delphi project file. Primary project "source" file.
• .PAS - Delphi unit source file.

You specify an interface in the type block just like you do for a class but you use the interface keywoard instead of the class keyword and in the interfaces section only. Since interfaces, by definition, do not have any implementation details, all you do is specifiy it in the type block.

Common comparison operators:

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

//Does Delphi evaluate the math correctly? Yes!

//Refer to math.pas MaxSingle for more info.

if (0.1 + 0.1 + 0.1 = 0.3) then
  ShowMessage('correct')
else
  ShowMessage('not correct')

Private visibility means members are invisible outside of the unit. In OO terms, this is how Object Pascal implements friendly classes (visibility to the private members of another class). To implement true private members in Delphi 1-7, put each class in a separate unit (most developers didn't bother).

Strict Private visibility means that private members within a class are visible ONLY within the class declared. In OO terms, this is true private visibility.

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

Because java is an OOP language, all custom routines belong to a specific class and are therefore referred to as methods.

All methods in Java must return something so even with procedures, you return a "void".

public void sayHello(String pName) {
  System.out.println("Hello" + pName);
}

 

public int add(int p1, int p2) {

  return p1 + p2;

}

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.

JavaScript uses functions and loosely typed parameters. Function definitions must come before their usage so the usual preference when adding JavaScript to HTML pages is to include them between the head tags.

In JavaScript, using a semicolon at the end of statements is optional. You might think a semicolon then is just another comment specifier but it is not. The semicolon is an optional end of statement specifier. To put two statements on a single code line, you must use a semicolon. However, the semicolon is optional, but probably confusing, when you break a single statement into multiple code lines.

document.write("Hello1");
document.write("Hello2");
 
//Semicolons are optional:
document.write("Hello3")
document.write("Hello4")
 
//This works too but only if you use a semicolon:
document.write("Hello5");  document.write("Hello6");
 
//Two lines also works:
document.write
  ("Hello7")

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.

For maximum compatibility, use compatibility mode and adjust settings (640x480, and run in a Window, etc.).

Declaring variables is optional unless you click Program | Compiler Warnings while in the ObjectPAL editor for every form, script, and library you create. Using Compiler Warnings is strongly recommended to avoid incorrectly typing an existing variable and to avoid any confusion about variable scope. Also recommended is turning on Compile with Debug for every form, script, and library too for tighter, cleaner code.

Undeclared variables are AnyType variables. Common data types include Currency, Date, Datetime, Logical, LongInt, Number, SmallInt, String, and Time.

Declare local variables within a method. If you want a local static variable (retains it's value because it is not destroyed), declare the varialbes above the method. Variables declared in an object's Var window are visible to all methods attached to that object, and objects that it contains.

var
    FullName String
    Age SmallInt
    Weight Number

endVar

FullName = "Mike Prestwood"
Age = 32
Weight =154.4

msgInfo("", FullName + ", age=" + String(Age) 

             + ", weight=" + String(Weight))

An advanced multi-tabbed text editor for source code and plain text. Includes advanced features for home users and developers including projects, line numbers, spell checking, full color syntax highlighting and code handling features.

Products / Languages Supported

ANSI C, Batch files, C, C++, Delphi, HTML, Informix, INI files, Java, MS SQL, ObjectPAL, Object Pascal, Oracle, Paradox, Perl, PL/SQL, SQL, Sybase, and Visual Basic.

Maintained by Steven Green. This link takes you directly to his used Paradox titles where you can buy older versions of Paradox.

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.

PHP

• Operator - No.
• Method -

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.

Prism supports a full suite of member modifiers. Prism virtuality modifiers are virtual, override, final, and reintroduce. Prism general modifiers are abstract, empty, async, external, locked, unsafe, implements, and iterator. Not all member types support all member modifiers. For example, member fields support only readonly and implements.

Delphi uses // for a single line comment and both {} and (**) for multiple line comments. Although you can nest different types of multiple line comments, it is recommended that you don't. Commenting code generally has three purposes: to document your code, for psuedo coding prior to coding, and to embed compiler directives. Most languages support both a single line comment and a multiple line comment. Some languages also use comments to give instructions to the compiler or interpreter. A special comment. Delphi compiler directives are in the form of {$DIRECTIVE}. Of interest for comments is using the $IFDEF compiler directive to remark out code.

//This is a single line comment.

 
{

Multiple line

comment.

}

 
(*
This too is a
multiple line comment.
*)

 
{$IFDEF TEMPOUT}
  //...code here
{$ENDIF}

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.

By Reference or Value
For parameters, you can optionally specify ByVal or ByRef. ByRef is the default if you don't specify.

Function SomeRoutine(ByRef pPerson, ByVal pName, Age)

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.

General Info: Programming Literals

A value directly written into the source code of a computer program (as opposed to an identifier like a variable or constant). Literals cannot be changed. Common types of literals include string literals, floating point literals, integer literals, and hexidemal literals. Literal strings are usually either quoted (") or use an apostrophe (') which is often referred to as a single quote. Sometimes quotes are inaccurately referred to as double quotes.

Languages Focus: Literals

In addition to understanding whether to use a quote or apostrophe for string literals, you also want to know how to specify and work with other types of literals including floating point literals. Some compilers allow leading and trailing decimals (.1 + .1), while some require a leading or trailing 0 as in (0.1 + 0.1). Also, because floating point literals are difficult for compilers to represent accurately, you need to understand how the compiler handles them and how to use rounding and trimming commands correctly for the nature of the project your are coding.

Console.WriteLine("Hello")
Console.WriteLine("Hello ""Mike"".")

'Does VB.Net evaluate this simple

'floating point math correctly? No! 

If (.1 + .1 + .1) = 0.3 Then
  MsgBox "Correct"
Else
  MsgBox "Not correct"
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")

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.

Don't reinvent the wheel. Use one of the many menu builders on the market. 

I use a product called DHTML Menu Builder. He's worked out all the problems and it really didn't seem worth my time since someone else had already worked out all the issues between different browsers and browsers on different OSes. His menus still aren't perfect, but boy, they sure are close.

The software is located at http://software.xfx.net/

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 2 GB of RAM not because it's required, but because Vista will use it. In Windows Vista, the caching scheme changed. Vista's SuperFetch built on and replaced Prefetch. Unlike Prefetch, SuperFetch will use up ALL memory you give it so you want as much memory on Vista as you can afford. My current Vista system has 3 GB of RAM with an additional 4 GB ReadyBoost compliant USB flash drive.