IT SOLUTIONS
Your full service technology partner! 
-Collapse +Expand
mprestwood
Mike Prestwood
-Collapse +Expand Profile
Member Info
Member Narration

POSTS:
MB Posts (1410)
KB Posts (1805)
KB Comments (53)
Blog (4 Topics)

KBPOSTSBYTYPE:
Tech Articles◄╣
FAQ Page (118)
Tips Page (70)
Definitions Page (96)
Code Snippets (506)
Errors Library (15)
Resource Links (73)
File Library (49)

Search mprestwood:

Advanced

   ► KBProfile: mprestwood  Print This     
Mike Prestwood

Mike Prestwood's Articles Page

434 Articles (full articles, general posts, and/or blog topics).

These Articles are organized by our community groups then by our knowledge base sub-topics.

Group: Linux Users


Topic: Linux Applications

Paradox for Linux resources here and on the net.
Posted By Mike Prestwood, Post #101088, KB Topic: Linux Applications
  +Add Comment  (1 Comments)




Group: C++





Topic: C++ Language Basics

C++ is a hybrid language and as such offers global functions and class methods. A function must come before it's usage or you can prototype the function.

Posted By Mike Prestwood, Post #101632, KB Topic: C++ Language Basics
  +Add Comment  (2 Comments)




Topic: Standard C++

Using cin and cout in C++ to output values.
Posted By Mike Prestwood, Post #100152, KB Topic: Standard C++
  +Add Comment




Group: Pascal and Delphi Coding





Topic: BDE

This KB Post addresses accessing Paradox tables through the BDE using TDatasource, TTable, and TDBGrid. This tutorial was updated for Delphi 2009 but applies to all versions of Delphi.

Posted By Mike Prestwood, Post #100147, KB Topic: BDE
  +Add Comment  (2 Comments)

Description of the Borland Database Engine (BDE).
Posted By Mike Prestwood, Post #100159, KB Topic: BDE
  +Add Comment  (3 Comments)




Topic: Coding Tasks

This code snippet shows you how to get your NIC MAC address using Borland Delphi.

Posted By Mike Prestwood, Post #100258, KB Topic: Coding Tasks
  +Add Comment  (4 Comments)




Topic: Delphi for Win32

Delphi supports both static and dynamic arrays.

Posted By Mike Prestwood, Post #102139, KB Topic: Delphi for Win32
  +Add Comment  (3 Comments)




Topic: Tool Basics

Borland Delphi editor tips and tricks.

Posted By Mike Prestwood, Post #100148, KB Topic: Tool Basics
  +Add Comment




Topic: Language Basics

This primer is intended for those just getting started in Delphi and focuses on displaying things.

Posted By Mike Prestwood, Post #100883, KB Topic: Language Basics
  +Add Comment  (24 Comments)

Create a classic "Hello, World" Windows native code Console App using Delphi. This tutorial is based on Borland Developer Suite 2006 but you can use any version of Delphi you wish. In this tutorial, you will create a classic "Hello, World!" windows console application. A console application is a type of Windows application that has FULL access to the Win32 API, but it's GUI is limited to a DOS-like text window. When Windows starts a console application, it creates a text-mode console window where the program can display text and the user can interact with the program via the keyboard.

Posted By Mike Prestwood, Post #101326, KB Topic: Language Basics
  +Add Comment  (6 Comments)

Create a classic "Hello, World" Windows native code application using Delphi. This tutorial is based on Borland Developer Suite 2006 but you can use any version of Delphi you wish.
Posted By Mike Prestwood, Post #101214, KB Topic: Language Basics
  +Add Comment  (4 Comments)

Object Pascal is generally not case sensitive.

Posted By Mike Prestwood, Post #101340, KB Topic: Language Basics
  +Add Comment  (7 Comments)

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

Posted By Mike Prestwood, Post #101505, KB Topic: Language Basics
  +Add Comment  (20 Comments)

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.

Posted By Mike Prestwood, Post #101712, KB Topic: Language Basics
  +Add Comment

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.
Posted By Mike Prestwood, Post #101353, KB Topic: Language Basics
  +Add Comment

Object Pascal allows parameters of the same type to be listed together, separated by commas, and followed with a single data type (more params of different data types can follow, after a semi-colon). The default for parameters is by value. For by reference, add var in front of the parameter. Object Pascal also offers constant parameters where you add const in front of the parameter. A constant parameter is like a local constant or read-only parameter the compiler can optimize. You cannot assign a value to a constant parameter, nor can you pass one as a var parameter to another routine.

Posted By Mike Prestwood, Post #101627, KB Topic: Language Basics
  +Add Comment

Rave Reports comes closest to a Delphi standard now but historically there has been no real standard in Delphi development. Do-it-yourself developers sometimes like to use TPrinter for very simple reports. ReportSmith was bundled with the first few versions of Delphi.

Delphi has offered many embedded VCL component report options. Quick Reports has been a part of Delphi since Delphi 2.0 and has been the default report writer for many Delphi developers. Ace Reporter, ReportBuilder and Rave Reports are also very popular. During the time of Kylix, FastReports was popular because of it's cross-platform nature.

Posted By Mike Prestwood, Post #101652, KB Topic: Language Basics
  +Add Comment  (4 Comments)

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, PCharInteger, Boolean, Single, Double, Pointer, and Variant.

Posted By Mike Prestwood, Post #101567, KB Topic: Language Basics
  +Add Comment  (2 Comments)




Topic: Language Details

When you want the exception to be the rule. A technique for handling exceptions in Borland Delphi's Object Pascal.

Posted By Mike Prestwood, Post #100087, KB Topic: Language Details
  +Add Comment  (11 Comments)

20. Arrays
Arrays in Object Pascal.
Posted By Mike Prestwood, Post #100158, KB Topic: Language Details
  +Add Comment

This lesson shows you how to create and use several different types of arrays in Object Pascal.
Posted By Mike Prestwood, Post #100003, KB Topic: Language Details
  +Add Comment

Common comparison operators:

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

Posted By Mike Prestwood, Post #101809, KB Topic: Language Details
  +Add Comment

Object Pascal

  • Operator - Yes. But not Pascal.
  • Method - Yes.  
Posted By Mike Prestwood, Post #101463, KB Topic: Language Details
  +Add Comment  (1 Comments)

Using Pascal and PChar strings in Delphi.
Posted By Mike Prestwood, Post #100160, KB Topic: Language Details
  +Add Comment  (1 Comments)

25. Records
Using record data types in Delphi.
Posted By Mike Prestwood, Post #100162, KB Topic: Language Details
  +Add Comment

Using case statements in Delphi.
Posted By Mike Prestwood, Post #100132, KB Topic: Language Details
  +Add Comment  (2 Comments)

InputBox allows you to set a value, display it to the user, and have the user change it. Although InputBox generally isn’t flashy enough for finished applications, it is great for debugging and smaller “in-house” applications.
Posted By Mike Prestwood, Post #100007, KB Topic: Language Details
  +Add Comment

MessageBox is similar to ShowMessage but gives you more control over how it displays. This one is a favorite of developers because it is a Windows API function wrapped in a Delphi method. This is important because many Windows development languages support the MessageBox function.
Posted By Mike Prestwood, Post #100006, KB Topic: Language Details
  +Add Comment  (7 Comments)

How to use Delphi's two varieties of string variables: Pascal strings and PChar strings.
Posted By Mike Prestwood, Post #100131, KB Topic: Language Details
  +Add Comment  (4 Comments)

How to use records in Delphi.
Posted By Mike Prestwood, Post #100130, KB Topic: Language Details
  +Add Comment  (3 Comments)

Use SetWindowLong to hide your application.
Posted By Mike Prestwood, Post #100068, KB Topic: Language Details
  +Add Comment  (1 Comments)

ShowMessage displays a simple dialog box with the text you provide it. It is one of the most used ways of displaying information.
Posted By Mike Prestwood, Post #100005, KB Topic: Language Details
  +Add Comment  (3 Comments)

Simple example of using the carrot operand.
Posted By Mike Prestwood, Post #100161, KB Topic: Language Details
  +Add Comment

The StatusBar component allows you to write text to the status bar. This is one of the most common ways to display information to a user without stopping their work.
Posted By Mike Prestwood, Post #100008, KB Topic: Language Details
  +Add Comment  (1 Comments)




Topic: OOP

Beginners example of creating and using a class. Early versions of Delphi use the standard OO private, protected, and public visibility specifiers plus add published for RTTI info. Later versions of Delphi add strict private and strict protected for a true OO implementation.

Posted By Mike Prestwood, Post #100889, KB Topic: OOP
  +Add Comment  (3 Comments)

Delphi for Win32 supports abstract class members using the abstract keyword. You can even instantiate instances of a class that contains abstract members. Then you override each abstract member in a descendant class with Override. Delphi does not support setting an entire class as abstract. You can create an abstract class (a class with one or more abstract methods), but there is no way to tell the compiler to not allow the instantiation of the abstract class. Delphi does not support abstract member properties directly. To implement an abstract properity, make use of abstract methods. That is, you can read a GetPropertyX abstract function and write to a SetPropertyX abstract procedure. In effect, creating  an abstract property.

Posted By Mike Prestwood, Post #101346, KB Topic: OOP
  +Add Comment  (5 Comments)

In Delphi programming language (Object Pascal), all classes ultimately inherit from the base class TObject.

Posted By Mike Prestwood, Post #101411, KB Topic: OOP
  +Add Comment  (1 Comments)

Delphi allows you to extend an existing class without using inheritance. Buggy in 2005 and not officially supported but stable and usable in 2006 and above. You declare a class helper similiar to how you declare a class but use the keywords class helper for.

  • You can name a helper anything.
  • Helpers have access only to public members of the class.
  • You cannot create an object instance directly from a class helper.
  • self refers to the class being helped.
Posted By Mike Prestwood, Post #101869, KB Topic: OOP
  +Add Comment  (1 Comments)

Declare your class in the Interface section. Then implement the class in the Implementation section.

Posted By Mike Prestwood, Post #101403, KB Topic: OOP
  +Add Comment  (4 Comments)

In Delphi, use the constructor keyword to signify which method or methods are constructors for a class. It is traditional but not required to use a procedure called Create.

In addition to having multiple named constructors, you can overload constructors.

Posted By Mike Prestwood, Post #101488, KB Topic: OOP
  +Add Comment  (3 Comments)

In Delphi, you use the class keyword followed by the parent class in parens. If you leave out the parent class, your class inherits from TObject.

Posted By Mike Prestwood, Post #101394, KB Topic: OOP
  +Add Comment

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.

Posted By Mike Prestwood, Post #101439, KB Topic: OOP
  +Add Comment  (24 Comments)

Specify Delphi member modifiers as follows:

reintroduce; overload; [binding modifier]; [calling convention]; abstract; [warning]

The binding modifiers are virtual, dynamic, or override. The calling conventions are register, pascal, cdecl, stdcall, or safecall. The warnings are platform, deprecated, or library. Additional directives include reintroduce, abstract, class, static, overload, and message.

Posted By Mike Prestwood, Post #101752, KB Topic: OOP
  +Add Comment

Up until D2005, private and protected were not implemented strictly. Starting with D2005, a traditional strict versions of OOP are supported using the strict keyword. OO purist will want you to use strict private over private and strict protected over protected. I suggest you follow that advice until you both fully understand the differences and have a specific need. Delphi offers a special published specifier which is the same as public members but runtime type information (RTTI) is generated.

Posted By Mike Prestwood, Post #101490, KB Topic: OOP
  +Add Comment

In Delphi, 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.

Posted By Mike Prestwood, Post #101945, KB Topic: OOP
  +Add Comment  (2 Comments)




Topic: Using Data

Be careful who you associate with!
Posted By Mike Prestwood, Post #100088, KB Topic: Using Data
  +Add Comment

Implement static member data in Delphi with variables declared in the implementation section (unit scope). Increment and decrement variable in constructor and destructor. Then use a class function to surface the variable's value publicly.
Posted By Mike Prestwood, Post #101713, KB Topic: Using Data
  +Add Comment

Heterogeneous Joins in Delphi: by Mike Benemelis. A heterogeneous join is when you join tables from two different SQL servers (or a server and a local table) within the same query. This short article will show you how to perform such queries using Delphi.
Posted By Mike Prestwood, Post #100009, KB Topic: Using Data
  +Add Comment  (6 Comments)

How to reindex and pack Paradox and dBASE tables.
Posted By Mike Prestwood, Post #100129, KB Topic: Using Data
  +Add Comment  (1 Comments)

SetSystemTime Example
Posted By Mike Prestwood, Post #100884, KB Topic: Using Data
  +Add Comment  (4 Comments)

Using DotNet DLLs in Win32 and using Win32 DLLs in DotNet. When. Why. How.
Posted By Mike Prestwood, Post #100396, KB Topic: Using Data
  +Add Comment  (1 Comments)

Memory Management and Delphi
Posted By Mike Prestwood, Post #100885, KB Topic: Using Data
  +Add Comment  (3 Comments)

The Database Desktop IS Paradox. It's just a stripped down version. The SQL editor in the Database Desktop (and in Paradox) allows you to execute one SQL statement at a time.
Posted By Mike Prestwood, Post #100029, KB Topic: Using Data
  +Add Comment

With TDataSet.Filter, use square brackets for fields with odd characters like spaces and slashes.
Posted By Mike Prestwood, Post #100236, KB Topic: Using Data
  +Add Comment




Topic: Using Controls

To determine the total number of columns in a String Grid, refer to its ColCount property and for the total number of rows, refer to RowCount. Determing the currently selected cell is a simple matter of referring to the Col and Row properties.
Posted By Mike Prestwood, Post #100886, KB Topic: Using Controls
  +Add Comment  (2 Comments)




Topic: Prestwood Delphi Gazette Archive

Our Delphi Gazette ran for a vew years in the late 90s. This page archives 1998.

Posted By Mike Prestwood, Post #102272, KB Topic: Prestwood Delphi Gazette Archive
  +Add Comment  (1 Comments)




Group: C# (Visual C# & VS.Net)





Topic: Tool Basics

C# is case sensitive. The following does NOT:

messagebox.Show("hello");  //Does not work!

The first time you type any other case for commands or variables, VS.Net will change it to the accepted or defined case. For example, if you type messagebox.show it is converted to MessageBox.Show. Once corrected, you can break it again by editing MessageBox to messagebox and the compiler will give you an error.

Posted By Mike Prestwood, Post #101336, KB Topic: Tool Basics
  +Add Comment




Topic: OOP

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.

Posted By Mike Prestwood, Post #101344, KB Topic: OOP
  +Add Comment  (3 Comments)

In C#, you use the class keyword to specify a class and you signify its parent with a colon and the name of the parent class. When you instantiate an object from a class, you use the new keyword.

Posted By Mike Prestwood, Post #101399, KB Topic: OOP
  +Add Comment

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.

Posted By Mike Prestwood, Post #101819, KB Topic: OOP
  +Add Comment

Use a destructor to free unmanaged resources. A destructor is a method with the same name as the class but preceded with a tilde (as in ~ClassName). The destructor implicity creates an Object.Finalize method (you cannot directly call nor override the Object.Finalize method).

In C# you cannot explicitly destroy an object. Instead, the .Net Frameworks garbage collector (GC) takes care of destroying all objects. The GC destroys the objects only when necessary. Some situations of necessity are when memory is exhausted or you explicitly call the System.GC.Collect method. In general, you never need to call  System.GC.Collect.

Posted By Mike Prestwood, Post #101834, KB Topic: OOP
  +Add Comment  (3 Comments)

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...
}
Posted By Mike Prestwood, Post #101435, KB Topic: OOP
  +Add Comment

In C# you can set the visibility of a member field to any visibility: private, protected, public, internal or protected internal. You can intialize a member field with a default when declared. If you set the member field value in your constructor, it will override the default value. Finally, you can use the static modifier (no instance required) and readonly modifier (similar to a constant).

Posted By Mike Prestwood, Post #101744, KB Topic: OOP
  To/From Code Guide: C# Member Method... vs. Other Languages
  +Add Comment  (2 Comments)

In C#, parens indicate a method and the lack of parens indicate a property. You use special get and set methods to both get and set the values of properties. For a read-only property, leave out the set method. The value keyword is used to refer to the member field. Properties can make use of any of the access modifiers (private, protected, etc). It is common to use a lowercase member names for member fields ("name" in our example) and uppercase properties to manage member fields ("Name" in our example).

Posted By Mike Prestwood, Post #101738, KB Topic: OOP
  +Add Comment

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.

Posted By Mike Prestwood, Post #101472, KB Topic: OOP
  +Add Comment  (6 Comments)

C# uses the keyword partial to specify a partial class. All parts must be in the same namespace.

A partial class, or partial type, is a class that can be split into two or more source code files and/or two or more locations within the same source file. Each partial class is known as a class part or just a part. Logically, partial classes do not make any difference to the compiler. The compiler puts the class together at compile time and treats the final class or type as a single entity exactly the same as if all the source code was in a single location.

You can use them for many things including to separate code generator code, organize large classes, divice a class up so you can split ownwership among multiple developers, have different versions of the same class, and to utilize multiple languages with a single class.

Posted By Mike Prestwood, Post #101807, KB Topic: OOP
  +Add Comment  (1 Comments)




Topic: WinForms

The ButtonsCS project. Create a classic "Hello, World" application using Visual Studio .Net with C# syntax. Requires either the full version or Visual C# Express Edition.

Posted By Mike Prestwood, Post #101212, KB Topic: WinForms
  +Add Comment  (4 Comments)




Topic: WebForms Coding Tasks

This article describes the ASPX file extensions.
Posted By Mike Prestwood, Post #100034, KB Topic: WebForms Coding Tasks
  +Add Comment  (3 Comments)




Group: VB.Net Language





Topic: Tool Basics

This will show how to make a "hello world" console application in Visual Studio 2008 using VB.Net.

Posted By Mike Prestwood, Post #101325, KB Topic: Tool Basics
  +Add Comment  (6 Comments)




Topic: OOP

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.

Posted By Mike Prestwood, Post #101348, KB Topic: OOP
  +Add Comment  (1 Comments)

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

Posted By Mike Prestwood, Post #101406, KB Topic: OOP
  +Add Comment

 A sub named New. You can overload the constructor simply by adding two or more New subs with various parameters.

Public Class Cyborg
Public CyborgName As String
  
  Public Sub New(ByVal pName As String)
CyborgName = pName
End Sub
End Class
Posted By Mike Prestwood, Post #101820, KB Topic: OOP
  +Add Comment

Use a destructor to free unmanaged resources. A destructor is a method with the same name as the class but preceded with a tilde (as in ~ClassName). The destructor implicity creates an Object.Finalize method (you cannot directly call nor override the Object.Finalize method).

In VB.Net you cannot explicitly destroy an object. Instead, the .Net Frameworks garbage collector (GC) takes care of destroying all objects. The GC destroys the objects only when necessary. Some situations of necessity are when memory is exhausted or you explicitly call the System.GC.Collect method. In general, you never need to call  System.GC.Collect.

Posted By Mike Prestwood, Post #101835, KB Topic: OOP
  +Add Comment  (3 Comments)

With VB.Net you define an interface with the Interface keyword and use it in a class with the Implements keyword. In the resulting class, you implement each property and method and add Implements Interface.Object to each as in:

Sub Speak(ByVal pSentence As String) Implements IHuman.Speak
  MessageBox.Show(pSentence)
End Sub
Posted By Mike Prestwood, Post #101443, KB Topic: OOP
  +Add Comment

In VB.Net you can set the visibility of a member field to any visibility: private, protected, public, friend or protected friend.

You can intialize a member field with a default when declared. If you set the member field value in your constructor, it will override the default value.

Finally, you can use the Shared modifier (no instance required) and ReadOnly modifier (similar to a constant).

Posted By Mike Prestwood, Post #101761, KB Topic: OOP
  +Add Comment

VB.Net uses a special property keyword along with special get and set methods to both get and set the values of properties. For a read-only property, leave out the set method. The value keyword is used to refer to the member field. Properties can make use of any of the access modifiers (private, protected, etc).

My preference for VB.Net code is to start member fields with "F" ("FName" in our example) and drop the "F" with properties that manage member fields ("Name" in our example).

Posted By Mike Prestwood, Post #101741, KB Topic: OOP
  +Add Comment

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

Posted By Mike Prestwood, Post #101947, KB Topic: OOP
  +Add Comment

VB.Net supports both partial classes and partial methods.

Posted By Mike Prestwood, Post #101857, KB Topic: OOP
  +Add Comment




Topic: WinForms

The ButtonsVB project. Create a classic "Hello, World" application using Visual Studio .Net with VB.Net syntax. Requires either the full version or VB.Net Express Edition.
Posted By Mike Prestwood, Post #101213, KB Topic: WinForms
  +Add Comment  (2 Comments)




Group: Corel Paradox / ObjectPAL Coding





Topic: Paradox & ObjectPAL

A cuddly tray icon which makes all your apps work with the IntelliMouse scrolling wheel. Two modes of operation are supported. Also, FreeWheel allows you to switch between documents by holding down the control and shift keys while moving the mouse wheel. FreeWheel is free, so dont delay - try it today. You might like it! Requires Microsoft IntelliMouse or equivalent.
Posted By Mike Prestwood, Post #102249, KB Topic: Paradox & ObjectPAL
  +Add Comment  (5 Comments)

Arrays in ObjectPAL use a 1-based indice.

Use size() to get the number of elements. size() returns 0 if the array has no elements.

Posted By Mike Prestwood, Post #102138, KB Topic: Paradox & ObjectPAL
  +Add Comment  (5 Comments)




Topic: Tool Basics

Comparison between dBASE and Paradox (from 1996!!).
Posted By Mike Prestwood, Post #100172, KB Topic: Tool Basics
  +Add Comment  (8 Comments)

My thoughts on whether Paradox for Windows is a good solution for building web-based Internet solutions.
Posted By Mike Prestwood, Post #100221, KB Topic: Tool Basics
  +Add Comment  (8 Comments)

If you have an existing Paradox system you can keep using it but you'll need to skip the Vista operating system and either stick with Windows XP or move to Windows 7. Because better tools exist, you may very well want to put a plan together now for converting to another development tool or at least understand what the future is likely to hold. If you're a power-user or researcher working with data, stick with Paradox.

Posted By Mike Prestwood, Post #100285, KB Topic: Tool Basics
  +Add Comment  (44 Comments)




Topic: Installation, Setup, & BDE

Bottom line is you should skip Vista and either stick with XP or move to Win 7. If you have to use Vista, you might be better off with Paradox 9.

Posted By Mike Prestwood, Post #101099, KB Topic: Installation, Setup, & BDE
  +Add Comment  (8 Comments)

Does Corel Paradox for Windows run on Vista? If so, are there any issues? What about Windows 7?

Posted By Mike Prestwood, Post #100449, KB Topic: Installation, Setup, & BDE
  +Add Comment  (25 Comments)

Procedure for fixing the Could Not Initialize BDE" error.

Posted By Mike Prestwood, Post #101971, KB Topic: Installation, Setup, & BDE
  +Add Comment  (7 Comments)

Paradox 9, 10, 11, etc. install easily on Windows 7! You do have to download WinHelp to get the Paradox help files to work properly.

Posted By Mike Prestwood, Post #102247, KB Topic: Installation, Setup, & BDE
  +Add Comment  (12 Comments)

Instructions to install Paradox 9 for Windows on Vista.

Posted By Mike Prestwood, Post #101098, KB Topic: Installation, Setup, & BDE
  +Add Comment  (41 Comments)

Paradox for Windows has two primary file types: source files and delivered files. Source files in Paradox are binary but can can be opened in later versions of Paradox and even in earlier versions if you don't use any new features: .FSL = Form, .RSL = Report, .SSL = Script, and .LSL = Library. Since Paradox source files do not compile to an EXE, Paradox developers tend to use a startup form or script to start the application.

Posted By Mike Prestwood, Post #101354, KB Topic: Installation, Setup, & BDE
  +Add Comment  (2 Comments)

Paradox does not remember desktop settings. I just installed Paradox 11 on a new computer and my working directory and other settings do not stick when I restart Paradox. Why?

Posted By Mike Prestwood, Post #101574, KB Topic: Installation, Setup, & BDE
  +Add Comment  (14 Comments)

Paradox 9 versions for SP1 through SP4. Plus version info on Paradox 10 and 11.

Posted By Mike Prestwood, Post #101977, KB Topic: Installation, Setup, & BDE
  +Add Comment  (7 Comments)

A trip down memory lane: the icons that shipped with various versions of Paradox.

Posted By Mike Prestwood, Post #101308, KB Topic: Installation, Setup, & BDE
  +Add Comment  (1 Comments)




Topic: Paradox Tables

Overview of using Paradox's table encryption to secure your data.
Posted By Mike Prestwood, Post #101193, KB Topic: Paradox Tables
  +Add Comment  (7 Comments)

Use a file server (not a workstation) to store your data, disable Oplocks on the filer server, and configure the BDE (local share to true and optimize if desired). Finally, if workstations are crashing, fix em so they don't. You want clean running computers that don't crash.

Posted By Mike Prestwood, Post #101149, KB Topic: Paradox Tables
  +Add Comment  (3 Comments)

Covers ALL Paradox tables from version 4 on including a description of the various Paradox table structures, limits, and specifications.

Posted By Mike Prestwood, Post #100060, KB Topic: Paradox Tables
  +Add Comment  (36 Comments)

Step by step instructions for repairing your Paradox tables.

Posted By Mike Prestwood, Post #101167, KB Topic: Paradox Tables
  +Add Comment  (3 Comments)




Topic: OPAL: Language Basics

If you've never programmed in ObjectPAL, spend 10 minutes and see how easy it is to program Paradox for Windows.

Posted By Mike Prestwood, Post #101209, KB Topic: OPAL: Language Basics
  +Add Comment  (3 Comments)

This detailed ObjectPAL primer will get you up and running developing in Paradox/ObjectPAL within a few hours.

Posted By Mike Prestwood, Post #100163, KB Topic: OPAL: Language Basics
  +Add Comment  (6 Comments)

Part 2.
Posted By Mike Prestwood, Post #100164, KB Topic: OPAL: Language Basics
  +Add Comment  (3 Comments)

Part 3.

Posted By Mike Prestwood, Post #100165, KB Topic: OPAL: Language Basics
  +Add Comment  (12 Comments)

Think levels when you code in the Pardox ObjectPAL development environment.

Posted By Mike Prestwood, Post #100868, KB Topic: OPAL: Language Basics
  +Add Comment  (5 Comments)

Common comparison operators:

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

Posted By Mike Prestwood, Post #101875, KB Topic: OPAL: Language Basics
  +Add Comment  (3 Comments)

In ObjectPAL, an empty variable can be unassigned (essentially null) or blank (equivalent to ""). You have to use both isBlank and isAssigned to check for an empty string.

Posted By Mike Prestwood, Post #102041, KB Topic: OPAL: Language Basics
  +Add Comment  (11 Comments)

ObjectPAL logical operators:

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

Posted By Mike Prestwood, Post #101898, KB Topic: OPAL: Language Basics
  +Add Comment  (2 Comments)

Techniques for thinking about where to put code in Paradox's object-based event model.
Posted By Mike Prestwood, Post #100769, KB Topic: OPAL: Language Basics
  +Add Comment




Topic: Interactive Paradox: Getting Going

Getting the most out of Paradox's Project Viewer.
Posted By Mike Prestwood, Post #101191, KB Topic: Interactive Paradox: Getting Going
  +Add Comment  (3 Comments)

Step by step instructions for setting some of Paradox's more useful preferences.

Posted By Mike Prestwood, Post #101172, KB Topic: Interactive Paradox: Getting Going
  +Add Comment  (2 Comments)




Topic: OPAL: Language Details

The following code demonstrates one technique for adding and subtracting months from a date in Paradox's ObjectPAL.
Posted By Mike Prestwood, Post #100001, KB Topic: OPAL: Language Details
  +Add Comment  (2 Comments)

Demo of importing and exporting spreadsheets using ObjectPAL.
Posted By Mike Prestwood, Post #101166, KB Topic: OPAL: Language Details
  +Add Comment  (2 Comments)

Q. How can you create a table of all the ObjectPAL commands?
Posted By Mike Prestwood, Post #100067, KB Topic: OPAL: Language Details
  +Add Comment

Using loop structures in ObjectPAL (for, forEach, scan, while, and looping with timers).

Posted By Mike Prestwood, Post #101170, KB Topic: OPAL: Language Details
  +Add Comment  (2 Comments)

DDE is one of several techniques for merging a word document with a Paradox table.
Posted By Mike Prestwood, Post #100070, KB Topic: OPAL: Language Details
  +Add Comment  (3 Comments)

Demonstration of how to handle dates and times in ObjectPAL.
Posted By Mike Prestwood, Post #101162, KB Topic: OPAL: Language Details
  +Add Comment

Paradox character sets: ANSI, OEM, Virtual keycodes (VK Keyboard Constants), and Hex
Posted By Mike Prestwood, Post #100312, KB Topic: OPAL: Language Details
  +Add Comment  (1 Comments)

In 32-bit Windows 95/98/ME/NT/2000, you use the PlaySound function in WINMM.DLL.
Posted By Mike Prestwood, Post #100065, KB Topic: OPAL: Language Details
  +Add Comment

Using execute() in ObjectPAL.
Posted By Mike Prestwood, Post #100310, KB Topic: OPAL: Language Details
  +Add Comment  (22 Comments)

ObjectPAL IsFile example demonstrates how to check if a file exists.
Posted By Mike Prestwood, Post #101146, KB Topic: OPAL: Language Details
  +Add Comment  (3 Comments)

Exploring ObjectPAL's TCursor object type.

Posted By Mike Prestwood, Post #101169, KB Topic: OPAL: Language Details
  +Add Comment  (2 Comments)

ObjectPAL methods for using the Window's registry to store and retrieve configuration settings.
Posted By Mike Prestwood, Post #100770, KB Topic: OPAL: Language Details
  +Add Comment  (2 Comments)




Topic: Interactive Paradox: Queries (QBE)

Specifications of query by example
Posted By Mike Prestwood, Post #100311, KB Topic: Interactive Paradox: Queries (QBE)
  +Add Comment  (4 Comments)




Topic: Interactive Paradox: Reports

Paradox has a built-in report writer that will suffice for nearly all reports you wish to create. You base a report on one or more tables or on a query. It uses a banded approach so you think in terms of records, pages, and report. Except for the record band, each section has a header and a footer. Paradox also offers a quick report which is useful for printing data quickly.

Posted By Mike Prestwood, Post #101218, KB Topic: Interactive Paradox: Reports
  +Add Comment  (1 Comments)




Topic: Interactive Paradox: Using Data

You can use Format | Filter while viewing a table to apply a secondary index.

Posted By Mike Prestwood, Post #100508, KB Topic: Interactive Paradox: Using Data
  +Add Comment  (6 Comments)

Paradox versus dBASE tables. Which to use in Paradox for Windows.
Posted By Mike Prestwood, Post #101185, KB Topic: Interactive Paradox: Using Data
  +Add Comment

Overview of why using BDE aliases are a good idea.
Posted By Mike Prestwood, Post #101186, KB Topic: Interactive Paradox: Using Data
  +Add Comment  (6 Comments)




Topic: OPAL: Commands

Tracinging built-in events, setting breakpoints, compiler options, debugging without the debugger, types of errors, the error event, errorShow, and the try structure.
Posted By Mike Prestwood, Post #101145, KB Topic: OPAL: Commands
  +Add Comment  (2 Comments)

ObjectPAL example that demonstrates listing a set of files and allowing the user to launch any one of them by double clicking.
Posted By Mike Prestwood, Post #101148, KB Topic: OPAL: Commands
  +Add Comment  (1 Comments)

ObjectPAL example where user selects a file and you extract the path.
Posted By Mike Prestwood, Post #101147, KB Topic: OPAL: Commands
  +Add Comment  (1 Comments)

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

Posted By Mike Prestwood, Post #100771, KB Topic: OPAL: Commands
  +Add Comment  (4 Comments)

Use setWorkingDir then trap for MenuChangingWork in menuAction.
Posted By Mike Prestwood, Post #101121, KB Topic: OPAL: Commands
  +Add Comment

Picture strings from the book Paradox 9 Power Programming.
Posted By Mike Prestwood, Post #100075, KB Topic: OPAL: Commands
  +Add Comment

To test the speed of your code, capture the time before and after your code executes and view the milliseconds between the two dates.
Posted By Mike Prestwood, Post #101163, KB Topic: OPAL: Commands
  +Add Comment




Topic: OPAL: Libraries

Using extended uses in ObjectPAL example.

Posted By Mike Prestwood, Post #100305, KB Topic: OPAL: Libraries
  +Add Comment  (1 Comments)




Topic: OPAL: OOP

Compromise OO implementation strategies for Paradox developers.
Posted By Mike Prestwood, Post #100308, KB Topic: OPAL: OOP
  +Add Comment  (5 Comments)




Topic: OPAL: Reports

How to use enumUIObjectNames and attach to manipulate a group of objects on a report.
Posted By Mike Prestwood, Post #100173, KB Topic: OPAL: Reports
  +Add Comment  (4 Comments)

How to send text directly to a printer port (not using a report).
Posted By Mike Prestwood, Post #100174, KB Topic: OPAL: Reports
  +Add Comment  (1 Comments)




Topic: OPAL: Wicked Coding Tasks

How to add an option to the tools menu.
Posted By Mike Prestwood, Post #101176, KB Topic: OPAL: Wicked Coding Tasks
  +Add Comment  (1 Comments)

This overview helps you create and use a reusable progress bar.
Posted By Mike Prestwood, Post #100239, KB Topic: OPAL: Wicked Coding Tasks
  +Add Comment  (4 Comments)

Getting started with moving objects with the mouse.
Posted By Mike Prestwood, Post #101136, KB Topic: OPAL: Wicked Coding Tasks
  +Add Comment

How to use the limited ObjectPAL support in reports.
Posted By Mike Prestwood, Post #100175, KB Topic: OPAL: Wicked Coding Tasks
  +Add Comment




Topic: OPAL: Win32 Calls

TAPI ObjectPAL example.
Posted By Mike Prestwood, Post #100890, KB Topic: OPAL: Win32 Calls
  +Add Comment




Topic: Professional Paradox/ObjectPAL Help

Is Paradox the right tool for your new application?
Posted By Mike Prestwood, Post #100642, KB Topic: Professional Paradox/ObjectPAL Help
  +Add Comment

Should you continue supporting your Paradox legacy applications?
Posted By Mike Prestwood, Post #100643, KB Topic: Professional Paradox/ObjectPAL Help
  +Add Comment

If you've lost your master password for your Paradox tables, we can help you recover your data.
Posted By Mike Prestwood, Post #101194, KB Topic: Professional Paradox/ObjectPAL Help
  +Add Comment




Topic: Runtime, PDE, Package-It!

Paradox for Windows Command-Line Options, runtime registry settings, adding menu items to Paradox, and manually setup a Vista shortcut.

Posted By Mike Prestwood, Post #100307, KB Topic: Runtime, PDE, Package-It!
  +Add Comment  (2 Comments)

List of commercial applications developed in Paradox for Windows
Posted By Mike Prestwood, Post #100306, KB Topic: Runtime, PDE, Package-It!
  +Add Comment  (1 Comments)

Listing of Paradox features NOT available in Paradox Runtime.

Posted By Mike Prestwood, Post #101278, KB Topic: Runtime, PDE, Package-It!
  +Add Comment  (1 Comments)

Getting started using the application framework in Paradox 9.
Posted By Mike Prestwood, Post #101144, KB Topic: Runtime, PDE, Package-It!
  +Add Comment  (1 Comments)




Topic: P5 Book: What Every Prgrmr Should Know

Chapter 1 of What Every Paradox for Windows Programmer Should Know by Mike Prestwood.
Posted By Mike Prestwood, Post #100171, KB Topic: P5 Book: What Every Prgrmr Should Know
  +Add Comment

Chapter 2 of What Every Paradox for Windows Programmer Should Know by Mike Prestwood.
Posted By Mike Prestwood, Post #100177, KB Topic: P5 Book: What Every Prgrmr Should Know
  +Add Comment




Topic: P7 Book: Programming Unleashed

Chapter 27, "Using DDE, OLE, and OLEAuto" from Paradox 7 Programming Unleashed by Mike Prestwood.
Posted By Mike Prestwood, Post #100145, KB Topic: P7 Book: Programming Unleashed
  +Add Comment  (2 Comments)

The four appendices for Paradox 7 Programming Unleashed included on the CD-ROM.
Posted By Mike Prestwood, Post #100881, KB Topic: P7 Book: Programming Unleashed
  +Add Comment




Topic: P9 Book: Power Programming

Forward to my book Paradox 9 Power Programming: The Official Guide. The forward is by Michael Cowpland (Chairman, President and CEO, Corel Corporation).

Posted By Mike Prestwood, Post #101188, KB Topic: P9 Book: Power Programming
  +Add Comment  (1 Comments)

We still have a high demand for my book titled, "Paradox 9 Power Programming" by Mike Prestwood. So we're still doing our book buy back. If you've got one sitting on your shelf, please consider selling it to us.
Posted By Mike Prestwood, Post #100402, KB Topic: P9 Book: Power Programming
  +Add Comment

Chapter 1 titled, "The Paradox Development Environment" from Paradox 9 Power Programming by Mike Prestwood.
Posted By Mike Prestwood, Post #100194, KB Topic: P9 Book: Power Programming
  +Add Comment  (23 Comments)

Chapter 2 "Tables and Developing" from Paradox 9 Power Programming: The Official Guide by Mike Prestwood.
Posted By Mike Prestwood, Post #100219, KB Topic: P9 Book: Power Programming
  +Add Comment  (2 Comments)

Chapter 3, "How to Develop Forms" from Paradox 9 Power Programming by Mike Prestwood.
Posted By Mike Prestwood, Post #100197, KB Topic: P9 Book: Power Programming
  +Add Comment

Chapter 4, "An Introduction to ObjectPAL" from Paradox 9 Power Programming by Mike Prestwood.

Posted By Mike Prestwood, Post #100198, KB Topic: P9 Book: Power Programming
  +Add Comment  (2 Comments)

Chapter 6, "The Event Model" from Paradox 9 Power Programming by Mike Prestwood.
Posted By Mike Prestwood, Post #100200, KB Topic: P9 Book: Power Programming
  +Add Comment  (10 Comments)

Chapter 7, "More About Syntax - Part 1" from Paradox 9 Power Programming by Mike Prestwood.
Posted By Mike Prestwood, Post #100201, KB Topic: P9 Book: Power Programming
  +Add Comment

Chapter 10, "Using Table Windows" from Paradox 9 Power Programming by Mike Prestwood.
Posted By Mike Prestwood, Post #100196, KB Topic: P9 Book: Power Programming
  +Add Comment

Chapter 11, "Programming with Queries" from Paradox 9 Power Programming by Mike Prestwood.
Posted By Mike Prestwood, Post #100202, KB Topic: P9 Book: Power Programming
  +Add Comment  (5 Comments)

Chapter 12, "Handling Reports" from Paradox 9 Power Programming by Mike Prestwood.

Posted By Mike Prestwood, Post #100205, KB Topic: P9 Book: Power Programming
  +Add Comment

Chapter 13, "Crosstabs and Charts" from Paradox 9 Power Programming by Mike Prestwood.
Posted By Mike Prestwood, Post #100206, KB Topic: P9 Book: Power Programming
  +Add Comment  (2 Comments)

Chapter 14, "Using Table and TCursor Variables" from Paradox 9 Power Programming by Mike Prestwood.
Posted By Mike Prestwood, Post #100207, KB Topic: P9 Book: Power Programming
  +Add Comment

Chapter 15, "Fields, Table Frames, and MROs" from Paradox 9 Power Programming by Mike Prestwood.
Posted By Mike Prestwood, Post #100208, KB Topic: P9 Book: Power Programming
  +Add Comment  (4 Comments)

Chapter 16, "Handling the Keyboard" from Paradox 9 Power Programming by Mike Prestwood.

Posted By Mike Prestwood, Post #100211, KB Topic: P9 Book: Power Programming
  +Add Comment  (5 Comments)

Chapter 17, "Manipulating Objects At Run Time" from Paradox 9 Power Programming by Mike Prestwood.
Posted By Mike Prestwood, Post #100212, KB Topic: P9 Book: Power Programming
  +Add Comment

Chapter 18, "Reusing Code" from Paradox 9 Power Programming by Mike Prestwood. Includes coding custom methods, custom procedures, and using ObjectPAL libraries.
Posted By Mike Prestwood, Post #100213, KB Topic: P9 Book: Power Programming
  +Add Comment  (2 Comments)

Chapter 19, "Imitate Users with Action, PostAction, and MenuAction" from Paradox 9 Power Programming by Mike Prestwood.
Posted By Mike Prestwood, Post #100214, KB Topic: P9 Book: Power Programming
  +Add Comment  (2 Comments)

Chapter 24 "SQL and Client/Server Applications" of Paradox 9 Power Programming by Mike Prestwood.

Posted By Mike Prestwood, Post #100204, KB Topic: P9 Book: Power Programming
  +Add Comment  (3 Comments)

This chapter will introduce you to creating both menus and pop-up menus. If you are going to create an application-wide menu, then I strongly recommend you use Paradox’s Application Framework. This chapter will instruct you how to create menus for non-Application Framework applications and pop-up menus you can use with both.

Posted By Mike Prestwood, Post #100403, KB Topic: P9 Book: Power Programming
  +Add Comment




Topic: Paradox for Win16 (versions 1-7)

Converting Your 16-bit Paradox for Windows applications to 32-bit Paradox for Windows
Posted By Mike Prestwood, Post #100309, KB Topic: Paradox for Win16 (versions 1-7)
  +Add Comment




Topic: Paradox for DOS

Discussion of aggregators in Paradox for Windows reports as they relate to Paradox for DOS.
Posted By Mike Prestwood, Post #100176, KB Topic: Paradox for DOS
  +Add Comment  (3 Comments)

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

Posted By Mike Prestwood, Post #101006, KB Topic: Paradox for DOS
  +Add Comment  (1 Comments)




Topic: Paradox for Linux

Chapter 26 by Mike Prestwood from the book WordPerfect Office 2000 for Linux: The Official Guide. First published June 2000 by Osborne-McGraw/Hill. ISBN 0-07-212238-2.

Posted By Mike Prestwood, Post #100874, KB Topic: Paradox for Linux
  +Add Comment  (6 Comments)

Chapter 27 by Mike Prestwood from the book WordPerfect Office 2000 for Linux: The Official Guide. First published June 2000 by Osborne-McGraw/Hill. ISBN 0-07-212238-2.

Posted By Mike Prestwood, Post #100875, KB Topic: Paradox for Linux
  +Add Comment  (13 Comments)

Chapter 28 by Mike Prestwood from the book WordPerfect Office 2000 for Linux: The Official Guide. First published June 2000 by Osborne-McGraw/Hill. ISBN 0-07-212238-2.

Posted By Mike Prestwood, Post #100876, KB Topic: Paradox for Linux
  +Add Comment  (2 Comments)

Chapter 29 by Mike Prestwood from the book WordPerfect Office 2000 for Linux: The Official Guide. First published June 2000 by Osborne-McGraw/Hill. ISBN 0-07-212238-2.

Posted By Mike Prestwood, Post #100877, KB Topic: Paradox for Linux
  +Add Comment

There is no "good" path for converting a Paradox for DOS application to either Paradox for Windows or Paradox for Linux.
Posted By Mike Prestwood, Post #100279, KB Topic: Paradox for Linux
  +Add Comment




Group: Visual Basic Classic





Topic: Tool Basics

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

Directives - #

Directives are sometimes called compiler or preprocessor directives. A # is used for directives within VB Classic code. VB Classic offers only an #If..then/#ElseIf/#Else directive.

Posted By Mike Prestwood, Post #101507, KB Topic: Tool Basics
  +Add Comment  (9 Comments)

VB Classic is a loosely typed language. Declaring variables is optional unless you use the Option Explicit statement to force explicit declaration of all variables with Dim, Private, Public, or ReDim. Using Option Explicit is strongly recommended to avoid incorrectly typing an existing variable and to avoid any confusion about variable scope.

Undeclared variables are variants. To specifically declare a variant, use:

Dim x As Variant
Dim x 

Common data types include Byte (0..255), Boolean, Integer (2-byte integers), Long (4-byte integers), Currency, Single (32-bit number), Double (64-bit number), Date, String, and variant.

Variables declared with Dim at the module level are available to all procedures within the module. At the procedure level, variables are available only within the procedure.

Posted By Mike Prestwood, Post #101569, KB Topic: Tool Basics
  +Add Comment




Topic: Language Basics

VB Classic logical operators:

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

Posted By Mike Prestwood, Post #101892, KB Topic: Language Basics
  +Add Comment  (7 Comments)




Topic: Language Details

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.

Posted By Mike Prestwood, Post #101601, KB Topic: Language Details
  +Add Comment




Group: ASP Classic Coding





Topic: ASP Classic

ASP and ADO coding best practices.
Posted By Mike Prestwood, Post #100144, KB Topic: ASP Classic
  +Add Comment  (1 Comments)

Arrays in ASP Classic use a 0-based indice.

Use UBound to get the number of elements. UBound returns -1 if the array has no elements, 0 if it has 1, 1 if it has 2, etc.

Posted By Mike Prestwood, Post #102133, KB Topic: ASP Classic
  +Add Comment  (2 Comments)

In ASP Classic, you have to add an empty string to the value being compared in order to get consistent results. For example, add &"" to your string varilable or it's code equivalent &vbNullString. Then compare to an empty string or verify it's length to 0 with Len.

Posted By Mike Prestwood, Post #102039, KB Topic: ASP Classic
  +Add Comment  (4 Comments)

Developer blog journal for our ASPSuite product. This blog is intended for the Prestwood ASP Classic developers.
Posted By Mike Prestwood, Post #100399, KB Topic: ASP Classic
  +Add Comment  (16 Comments)

Using CDO to send email.
Posted By Mike Prestwood, Post #100248, KB Topic: ASP Classic
  +Add Comment  (1 Comments)

Introduction to the global.asa file.
Posted By Mike Prestwood, Post #100169, KB Topic: ASP Classic
  +Add Comment  (1 Comments)

Use IsEmpty or Len > 0 to test
When clearing, set to Null (not "")
Posted By Mike Prestwood, Post #100229, KB Topic: ASP Classic
  +Add Comment  (2 Comments)




Topic: Tool Basics

An example of using ASP's Response.Write and creating functions.

Posted By Mike Prestwood, Post #100014, KB Topic: Tool Basics
  +Add Comment  (4 Comments)

Save as VB Classic.

Posted By Mike Prestwood, Post #101585, KB Topic: Tool Basics
  +Add Comment  (7 Comments)




Topic: Language Basics

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

Posted By Mike Prestwood, Post #101383, KB Topic: Language Basics
  +Add Comment  (6 Comments)

Same as VB. ASP Classic logical operators:

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

Posted By Mike Prestwood, Post #101891, KB Topic: Language Basics
  +Add Comment  (4 Comments)

In ASP, you can buffer a RecordSet in either a session or application variable. This code snippet shows you how to create a reusable method for buffering RecordSets in an application variable.
Posted By Mike Prestwood, Post #100410, KB Topic: Language Basics
  +Add Comment

Use Application.Contents.RemoveAll and Session.Contents.RemoveAll

Posted By Mike Prestwood, Post #100452, KB Topic: Language Basics
  +Add Comment  (1 Comments)

Many users these days have very wide screens. This article shows you how to determine the browser width using ASP classic.
Posted By Mike Prestwood, Post #101299, KB Topic: Language Basics
  +Add Comment

Code sample to get a count of the number of fields in a table of a particular field type (a particular DataTypeEnum).
Posted By Mike Prestwood, Post #100432, KB Topic: Language Basics
  +Add Comment  (1 Comments)

You can use JavaScript to set an IIS App var to the GMT server difference. Then use that number in your code.
Posted By Mike Prestwood, Post #100536, KB Topic: Language Basics
  +Add Comment  (4 Comments)

This code snippet shows you how to loop through a form's fields.
Posted By Mike Prestwood, Post #100422, KB Topic: Language Basics
  +Add Comment  (2 Comments)

Call randomize then call Rnd to generate a random number between 0 and 1.
Posted By Mike Prestwood, Post #100691, KB Topic: Language Basics
  +Add Comment  (1 Comments)

How to use ASPMail to send email from your web site.

Posted By Mike Prestwood, Post #100216, KB Topic: Language Basics
  +Add Comment  (1 Comments)

You can use "On Error Resume Next" to suppress errors and "On Error Goto 0" to stop suppressing errors.
Posted By Mike Prestwood, Post #100411, KB Topic: Language Basics
  +Add Comment  (4 Comments)




Topic: Language Details

Use the scriptiing dictionary object which is available on later versions of ASP Classic (all still commonly in use). Both Access VBA and VB Classic use a collection for this but collections are not supported in ASP Classic.

Dim StateList
Set StateList = Server.CreateObject("Scripting.Dictionary")
StateList.Add "CA", "California"
StateList.Add "NV", "Nevada" 
Response.Write "I live in " & StateList.Item("CA")
Posted By Mike Prestwood, Post #101512, KB Topic: Language Details
  +Add Comment  (2 Comments)

Using a RecordSet's properties, methods and events.
Posted By Mike Prestwood, Post #100431, KB Topic: Language Details
  +Add Comment

Response.Flush sends the contents of the buffer to the browser. This command is useful for showing a visitor something while slow loading pages load.

Posted By Mike Prestwood, Post #100421, KB Topic: Language Details
  +Add Comment  (14 Comments)

Use Weekday and WeekdayName to return the day of week in ASP.
Posted By Mike Prestwood, Post #100100, KB Topic: Language Details
  +Add Comment  (2 Comments)




Topic: OOP

Ultra-primitive (no inheritance) but useful and encourages you to think and design using objects.

Posted By Mike Prestwood, Post #101398, KB Topic: OOP
  +Add Comment  (2 Comments)

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.

Posted By Mike Prestwood, Post #101823, KB Topic: OOP
  +Add Comment  (7 Comments)

When an object instance is destroyed, ASP calls a special parameter-less sub named Class_Terminate. For example, when the variable falls out of scope. Since you cannot specify parameters for this sub, you also cannot overload it.

When an object instance is created from a class, ASP calls a special sub called Class_Initialize.

Posted By Mike Prestwood, Post #101830, KB Topic: OOP
  +Add Comment  (1 Comments)

ASP classic uses the property keyword and special Get and Let methods to both get and set the values of properties.

Posted By Mike Prestwood, Post #101749, KB Topic: OOP
  +Add Comment  (58 Comments)

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.

Posted By Mike Prestwood, Post #101956, KB Topic: OOP
  +Add Comment




Group: Website Design & Hosting





Topic: Beginners Corner

214. Using FTP
How to use FTP to upload your web site pages.
Posted By Mike Prestwood, Post #100186, KB Topic: Beginners Corner
  +Add Comment




Topic: DNS Settings

MX Records - web hosting, e-mail, machine name
Posted By Mike Prestwood, Post #100454, KB Topic: DNS Settings
  +Add Comment




Topic: Free Website Scripts

Free Guestbook Script, web hosting, webmaster
Posted By Mike Prestwood, Post #100535, KB Topic: Free Website Scripts
  +Add Comment  (1 Comments)




Topic: HTML Language Reference

Translation of entity references and special codes ( such as < to < ).
Posted By Mike Prestwood, Post #100187, KB Topic: HTML Language Reference
  +Add Comment  (8 Comments)

The tag specifies the font face, font size, and font color.
Posted By Mike Prestwood, Post #100408, KB Topic: HTML Language Reference
  +Add Comment  (3 Comments)




Topic: MS Frontpage

Browser safe colors consist of 216 colors that have been agreed upon and should look good on any type of monitor capable of displaying 256 colors or higher.
Posted By Mike Prestwood, Post #100156, KB Topic: MS Frontpage
  +Add Comment  (5 Comments)

Browser safe colors consist of 216 colors that have been agreed upon and should look good on any type of monitor capable of displaying 256 colors or higher.
Posted By Mike Prestwood, Post #100155, KB Topic: MS Frontpage
  +Add Comment  (4 Comments)

These browser safe fonts will render well on various operating systems and browsers.
Posted By Mike Prestwood, Post #100157, KB Topic: MS Frontpage
  +Add Comment  (6 Comments)

Rules and guidelines for building a better home page.
Posted By Mike Prestwood, Post #100355, KB Topic: MS Frontpage
  +Add Comment  (3 Comments)

We just received FrontPage 2003 beta 2 and Microsoft has continued to add features for serious developers.
Posted By Mike Prestwood, Post #100252, KB Topic: MS Frontpage
  +Add Comment  (7 Comments)

Microsoft is killing FrontPage later THIS YEAR!
Posted By Mike Prestwood, Post #100393, KB Topic: MS Frontpage
  +Add Comment  (6 Comments)




Topic: Server Farm: RS

This article shows you how to access your web hosting control panel.
Posted By Mike Prestwood, Post #100023, KB Topic: Server Farm: RS
  +Add Comment

Summary of the Prestwood hosting plans Java capabilities.
Posted By Mike Prestwood, Post #100135, KB Topic: Server Farm: RS
  +Add Comment




Topic: Unix Hosting

Now you can add LIVE CHAT to your web site easier than you ever imagined. The VolanoChat system is a combination of server and client side Java programs. The client side Java applet (46 KB to 57 KB depending on browser) is downloaded by the browser and then executed on the user's local machine. The client applet then communicates with the software located on the server to create a live real-time chat environment.
Posted By Mike Prestwood, Post #100354, KB Topic: Unix Hosting
  +Add Comment

You can assign unique userids and passwords to control access to various web pages.
Posted By Mike Prestwood, Post #100062, KB Topic: Unix Hosting
  +Add Comment

Limitations on UNIX Connections.
Posted By Mike Prestwood, Post #100247, KB Topic: Unix Hosting
  +Add Comment




Topic: Website Design

This article is a basic introduction to HTML authoring.

Posted By Mike Prestwood, Post #100024, KB Topic: Website Design
  +Add Comment  (9 Comments)

How to create image maps. Imagemaps allow the user to click on predefined sections of a graphic picture on your page and have the server respond as if they clicked on a text hyperlink.
Posted By Mike Prestwood, Post #100215, KB Topic: Website Design
  +Add Comment




Topic: Website Hosting

How to allow anonymous FTP on your Prestwood hosting account.
Posted By Mike Prestwood, Post #100185, KB Topic: Website Hosting
  +Add Comment

Answers to questions you may have about using Microsoft's FrontPage on Prestwood Servers.

Posted By Mike Prestwood, Post #100134, KB Topic: Website Hosting
  +Add Comment

How to get your forgotten or lost Prestwoood hosting account password.

Posted By Mike Prestwood, Post #100022, KB Topic: Website Hosting
  +Add Comment

Frequently Asked Questions about email on our hosted websites.
Posted By Mike Prestwood, Post #100386, KB Topic: Website Hosting
  +Add Comment




Topic: Website Scripting

13 things you can do to make your code more secure, general advice about the rest of it, PLUS YOUR COMMENTS and experiences.

Posted By Mike Prestwood, Post #100988, KB Topic: Website Scripting
  +Add Comment  (6 Comments)




Topic: Windows Hosting

ASP.NET web hosting frequently asked questions.

Posted By Mike Prestwood, Post #100039, KB Topic: Windows Hosting
  +Add Comment

Summary of the "special" directories used with our Windows hosting plans.
Posted By Mike Prestwood, Post #100136, KB Topic: Windows Hosting
  +Add Comment

Limitations of using Microsoft Access as a database in a hosting environment.
Posted By Mike Prestwood, Post #100227, KB Topic: Windows Hosting
  +Add Comment

How to use a DSN to connect to a database (specific to our Windows web hosting clients).
Posted By Mike Prestwood, Post #100170, KB Topic: Windows Hosting
  +Add Comment

We recently upgraded the way in which our statistics packages for Windows 2000 hosting plans store and log their web site data.
Posted By Mike Prestwood, Post #100246, KB Topic: Windows Hosting
  +Add Comment




Group: Java





Topic: Language Details

General Info: Inheritance

The concept of a class makes it possible to define subclasses that share some or all of the main class characteristics. This is called inheritance. Inheritance also allows you to reuse code more efficiently. In a class tree, inheritance is used to design classes vertically. (You can use Interfaces to design classes horizontally within a class tree.) With inheritance, you are defining an "is-a" relationship (i.e. a chow is-a dog). Analysts using UML call this generalization where you generalize specific classes into general parent classes.

Java Inheritance

Simple syntax example of class inheritance.

Posted By Mike Prestwood, Post #101392, KB Topic: Language Details
  +Add Comment  (6 Comments)




Group: JavaScript and AJAX





Topic: Beginners Corner

Short 10 minute getting started JavaScript primer.
Posted By Mike Prestwood, Post #100140, KB Topic: Beginners Corner
  +Add Comment

Description of the JavaScript event handlers.
Posted By Mike Prestwood, Post #100192, KB Topic: Beginners Corner
  +Add Comment

JavaScript frequently asked questions.
Posted By Mike Prestwood, Post #100168, KB Topic: Beginners Corner
  +Add Comment

Adding JavaScript to your HTML forms to validate form fields.
Posted By Mike Prestwood, Post #100908, KB Topic: Beginners Corner
  +Add Comment




Topic: Coding Tasks

For IE 4+, this script will give visitors to your site the option to add your page to their favorites. For Netscape users it will remind them to press Control + D, for all others, it simply reminds them to bookmark your page.
Posted By Mike Prestwood, Post #100190, KB Topic: Coding Tasks
  +Add Comment

How to validate form field is blank or not using JavaScript.
Posted By Mike Prestwood, Post #100191, KB Topic: Coding Tasks
  +Add Comment

How do you do a really simple 30 second countdown in JavaScript?
Posted By Mike Prestwood, Post #100795, KB Topic: Coding Tasks
  +Add Comment  (1 Comments)

How to specify browser size with Javascript.
Posted By Mike Prestwood, Post #100356, KB Topic: Coding Tasks
  +Add Comment

A Javascript "You are here:" location script that uses your folder path to indicate location.
Posted By Mike Prestwood, Post #101663, KB Topic: Coding Tasks
  +Add Comment  (3 Comments)




Topic: JavaScript and AJAX

JScript is Microsoft's implementation of JavaScript.
Posted By Mike Prestwood, Post #100064, KB Topic: JavaScript and AJAX
  +Add Comment




Topic: Language Reference

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.

Posted By Mike Prestwood, Post #101633, KB Topic: Language Reference
  +Add Comment

Javascript operators: assignment, comparison, computational, and logical.
Posted By Mike Prestwood, Post #100167, KB Topic: Language Reference
  +Add Comment

JavaScript reserved words
Posted By Mike Prestwood, Post #100166, KB Topic: Language Reference
  +Add Comment




Group: Perl





Topic: Beginners Corner

A short 10 minute Perl primer. Get started in Perl now!

Posted By Mike Prestwood, Post #100138, KB Topic: Beginners Corner
  +Add Comment  (3 Comments)

Literals are quoted as in "Prestwood".  If you need to embed a quote use a slash in front of the quote as in \"

Posted By Mike Prestwood, Post #101543, KB Topic: Beginners Corner
  +Add Comment

Perl is a loosely typed language with only three types of variables: scalars, arrays, and hashes. Use $ for a scalar variable, @ for an array, or % for a hash (an associative array). The scalar variable type is used for anytype of simple data such as strings, integers, and numbers. In Perl, you identify and use a variable with a $ even within strings

Posted By Mike Prestwood, Post #101617, KB Topic: Beginners Corner
  +Add Comment




Topic: Language Reference

List of Perl operators.

Posted By Mike Prestwood, Post #100139, KB Topic: Language Reference
  +Add Comment




Topic: Perl

Perl uses subs and parameters are referenced in a special array. All arguments passed to a subroutine are stored in a special @_ array. To retrieve the arguments, you have to look inside the array and extract them.

Posted By Mike Prestwood, Post #101659, KB Topic: Perl
  +Add Comment




Group: PHP & Delphi for PHP





Topic: Beginners Corner

Download page from PHP.Net.

Posted By Mike Prestwood, Post #101658, KB Topic: Beginners Corner
  +Add Comment

Declare associative array with initial known values. You can also add to associative array. (You can just assign values without ever declaring it too!)

Posted By Mike Prestwood, Post #101660, KB Topic: Beginners Corner
  +Add Comment

In PHP you can use quotes, or apostraphies as in "Prestwood", and 'Prestwood'. Use a slash in front of a quote or apostrophe to embed same type as in \' and \".

Posted By Mike Prestwood, Post #101524, KB Topic: Beginners Corner
  +Add Comment  (1 Comments)

PHP uses a period (.) known as a dot to concatenate strings.

Posted By Mike Prestwood, Post #101616, KB Topic: Beginners Corner
  +Add Comment

PHP is a loosely typed language. No variable types in PHP. Declaring and using variables are a bit different than in other languages. In PHP, you identify and use a variable with a $ even within strings!

You assign by reference with & as in &$MyVar.

Posted By Mike Prestwood, Post #101615, KB Topic: Beginners Corner
  +Add Comment  (2 Comments)




Topic: Language Reference

PHP uses functions and loosely typed parameters. Function definitions can come before or after their usage so my preference when mixing PHP in with a mostly HTML page is to put the functions after the </html> tag.

Posted By Mike Prestwood, Post #101635, KB Topic: Language Reference
  +Add Comment




Topic: PHP

PHP has become more conformed to CGI specifications and as such, you will need to make changes to your code in order for global variables to be filled in.
Posted By Mike Prestwood, Post #100243, KB Topic: PHP
  +Add Comment  (2 Comments)




Group: Coding & OO





Topic: Borland Database Engine

Download BDE 5.202 (includes a small BDE Information utility for testing the installation).

Posted By Mike Prestwood, Post #100537, KB Topic: Borland Database Engine
  +Add Comment  (29 Comments)

Q. I've updated my BDE from version 5.01 to version 5.2.0.2 but the About BDE Administrator dialog still shows version 5.01?

A. Your update may have taken. Updates typically just replace the DLLs the BDE uses so you may have the latest installed.

Version Information
To see what version of the BDE engine you "actually" have installed, you need to look at the Version Information from within the BDE Administrator. Select Object | Version Information... to see the DLL version numbers

Posted By Mike Prestwood, Post #101246, KB Topic: Borland Database Engine
  +Add Comment  (7 Comments)




Topic: Object Orientation (OO)

270. Aggregation

Aggregations indicate a whole-part relationship, and are known as "has-a" or "is part of" relationships. An Aggregation relationship is indicated by a line with a hollow diamond.

Posted By Mike Prestwood, Post #101263, KB Topic: Object Orientation (OO)
  +Add Comment  (3 Comments)

Overview and introduction to object orientation. When you analyze, design, and code in an OO way, you "think" about objects and their interaction. This type of thinking is more like real life where you naturally think about how "this object" relates to "that object". Classes represent the "design" of an existing object. The values or properties of an existing object is it's current state. When designing classes, OO supports many features like inheritance (like real-life where you inherit your parents characteristics), encapsulation (hiding data), and polymorphism (the ability of one thing to act like another or in different ways).
Posted By Mike Prestwood, Post #100137, KB Topic: Object Orientation (OO)
  +Add Comment  (5 Comments)

272. Inheritance

The concept of a class makes it possible to define subclasses that share some or all of the main class characteristics. This is called inheritance. Inheritance also allows you to reuse code more efficiently. In a class tree, inheritance is used to design classes vertically. (You can use Interfaces to design classes horizontally within a class tree.) With inheritance, you are defining an "is-a" relationship (i.e. a chow is-a dog). Analysts using UML call this generalization where you generalize specific classes into general parent classes.

Posted By Mike Prestwood, Post #100813, KB Topic: Object Orientation (OO)
  To/From Code Guide: Inheritance... vs. Other Languages
  +Add Comment

Our most popular article in the history of our online community! Explains the "is a", "has a", "uses a", and "looks like" relationships (updated May 2007). "Is a" is inheritance, "looks like" is interfaces, "has a" is aggregation, and "uses a" is composition.

Posted By Mike Prestwood, Post #100035, KB Topic: Object Orientation (OO)
  +Add Comment  (12 Comments)

A static member is a member you can have access to without instantiating the class into an object. For example, you can read and write static properties and call static methods without ever creating the class. Static members are also called class members (class methods, class properties, etc.) since they belong to the class and not to a specific object. A static class is a class that contains only static members. In the UML, these classes are described as utility classes.

Posted By Mike Prestwood, Post #101477, KB Topic: Object Orientation (OO)
  +Add Comment  (1 Comments)




Group: DBA, Databases, & Data





Topic: ANSI SQL Scripting

To find duplicate values in the same field, you need to use an alias with the same table twice.
Posted By Mike Prestwood, Post #100061, KB Topic: ANSI SQL Scripting
  +Add Comment




Topic: DBA & Data

Reference of common table structures
Posted By Mike Prestwood, Post #100054, KB Topic: DBA & Data
  +Add Comment

List of common field names, along with suggested field type and length. These are only suggestions and shouldn't be taken as gospel. Use as a starting point.
Posted By Mike Prestwood, Post #100002, KB Topic: DBA & Data
  +Add Comment

Description of dBASE IV field types
Posted By Mike Prestwood, Post #100056, KB Topic: DBA & Data
  +Add Comment  (2 Comments)




Topic: Desktop Databases

Overview of DDE.

Posted By Mike Prestwood, Post #100146, KB Topic: Desktop Databases
  +Add Comment




Topic: Interbase

Interbase database and field specifications
Posted By Mike Prestwood, Post #100057, KB Topic: Interbase
  +Add Comment




Topic: MS SQL 97 / 2000

The preferred technique for transferring an MS SQL database is to do a complete backup and restore.
Posted By Mike Prestwood, Post #100264, KB Topic: MS SQL 97 / 2000
  +Add Comment




Group: Windows Users





Topic: Features You Should Know

You should occasionally review your Windows update history and make sure all updates are succeeding.

Posted By Mike Prestwood, Post #101224, KB Topic: Features You Should Know
  +Add Comment  (4 Comments)




Topic: Microsoft Office

How do you turn off Markup comments in Microsoft Word so the next time I open a document, I do not see the markup comments by default?

Posted By Mike Prestwood, Post #102212, KB Topic: Microsoft Office
  +Add Comment




Topic: Microsoft Outlook

To view the source code of an HTML email as text like you could in Outlook 2003, select Actions | Other Actions | View Source in the Move panel of the ribbon. Also available on the same menu is Message Header and View in Browser.

Posted By Mike Prestwood, Post #102265, KB Topic: Microsoft Outlook
  +Add Comment  (6 Comments)




Topic: Online Security

Don't use it until they fix major problems with false positives and until they stop pubicly displaying your email address!

Posted By Mike Prestwood, Post #102178, KB Topic: Online Security
  +Add Comment  (2 Comments)




Topic: Windows 7

The Windows 7 Home, Professional, and Ultimate editions will retail at a lower price than Vista. The upgrade pricing is available for XP and Vista users but XP users will have to perform a clean install. Gone is the Business edition. It's now back to it's pre-Vista Professional name.

Windows 7 Pricing:

  • Home Premium New User: $199.99, Upgrade: $119.99
  • Professional New User: $299.99, Upgrade: $199.99
  • Ultimate New User: $319.99, Upgrade: $219.99
Posted By Mike Prestwood, Post #102055, KB Topic: Windows 7
  +Add Comment  (1 Comments)




Topic: Windows Users

Protect your computer before it slows down, you lose data, or someone steals information. The basics are an antivirus program, Windows Updates, and a firewall. Beyond that, I like to use several programs that add layers of protection to your computer.

Posted By Mike Prestwood, Post #102023, KB Topic: Windows Users
  +Add Comment

See what services are running inside of SvcHost.EXE. See what is causing your 99% CPU usage.
Posted By Mike Prestwood, Post #100542, KB Topic: Windows Users
  +Add Comment  (1 Comments)

If your computer was fast but is now slow, you can use techniques such as adware removers, defrag, and others to bring your PC back to life! You can also add hardware to speed up your computer (RAM, SATA HD, better video card, etc.).

Posted By Mike Prestwood, Post #102022, KB Topic: Windows Users
  +Add Comment  (1 Comments)

How do I uninstall Internet Explorer 9?

Posted By Mike Prestwood, Post #102307, KB Topic: Windows Users
  +Add Comment

What is the maximum file + path name allowed in Windows?

Posted By Mike Prestwood, Post #102743, KB Topic: Windows Users
  +Add Comment




Topic: Windows Vista

Windows Help program (WinHlp32.exe) does not ship with Microsft Vista nore with Windows Server 2008 but is available for download.
Posted By Mike Prestwood, Post #101137, KB Topic: Windows Vista
  +Add Comment

To create a shortcut, right click on the deskop and select New | Shortcut. The old ways of altering the properties or even copying existing shortcuts is now very limited.

Posted By Mike Prestwood, Post #101175, KB Topic: Windows Vista
  +Add Comment




Topic: Windows XP

The Microsoft Windows Key (WinKey) does more than just display the Start menu.
Posted By Mike Prestwood, Post #100269, KB Topic: Windows XP
  +Add Comment  (2 Comments)




Group: Computer Tech





Topic: Backup Software

Our FAQ list primarily for our clients where we highlight the most important Carbonite questions.

Posted By Mike Prestwood, Post #102183, KB Topic: Backup Software
  +Add Comment

To add an extension, right click on a file, select Properties. On the Carbonite tab, check the Back up files of this type (within folders selected for backup) checkbox. Alternatively, you can specify specific files to back up by right clicking the file and selecting Carbonite | Back This Up.

Posted By Mike Prestwood, Post #102182, KB Topic: Backup Software
  +Add Comment




Topic: Computer Tech

Phone numbers of the major computer manufacturers.

Posted By Mike Prestwood, Post #102322, KB Topic: Computer Tech
  +Add Comment  (1 Comments)

Link page for common support pages.

Posted By Mike Prestwood, Post #102321, KB Topic: Computer Tech
  +Add Comment  (1 Comments)




Topic: Domains

For a particular user on a particular computer, all programs installed for all users will still be available whether they log into their computer or the domain. You will have to migrate all other user specific settings either manually or use an automated tool.

Both of which are incomplete so expect to have to manually migrate some application specific settings and data for each user. At a minimum, log into the old local account and migrate My Documents, Desktop, Favorites, and perhaps e-mail such as the Outlook .PST or Outlook Express .DBX files.

Posted By Mike Prestwood, Post #102028, KB Topic: Domains
  +Add Comment




Topic: RAM

DDR RAM generally comes in one of  four speeds: PC1600, PC2100, PC2700, and PC3200.

Posted By Mike Prestwood, Post #102078, KB Topic: RAM
  +Add Comment




Topic: Software

If you maintain more than a few computers, here are 10 applications you should have in your toolbox of software.

Posted By Mike Prestwood, Post #101314, KB Topic: Software
  +Add Comment  (15 Comments)

From bit to exabyte, know your quantities.
Posted By Mike Prestwood, Post #100978, KB Topic: Software
  +Add Comment  (1 Comments)

In a batch file, schecule DOS command shutdown. Use shutdown /? for specifics. Use net stop to kill services before hand if you wish. Use task scheduler to schedule the execution of the batch file.

Posted By Mike Prestwood, Post #102136, KB Topic: Software
  +Add Comment




Topic: Windows Server 2003

In Windows Server 2003 terminal server, how do you automatically log off disconnected sessions? I'm getting the following error:

"The terminal server has exceeded the maximum number of allowed connections. The system can not log you on. The system has reached its licensed logon limit. Please try again later."

Posted By Mike Prestwood, Post #102149, KB Topic: Windows Server 2003
  +Add Comment




Topic: Wired Networking

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

Posted By Mike Prestwood, Post #102005, KB Topic: Wired Networking
  +Add Comment  (3 Comments)




Group: Computer Industry





Topic: General News & Trends

Borland's annual developer conference was held this month in Long Beach CA. Attending the conference for Prestwood were Scott Wehrly, Mike Prestwood, and Kim Berry.

Posted By Mike Prestwood, Post #100027, KB Topic: General News & Trends
  +Add Comment  (1 Comments)




Topic: IT Water-Cooler for Power-Users

Industry links. Add your computer related website to our list of websites.
Posted By Mike Prestwood, Post #100474, KB Topic: IT Water-Cooler for Power-Users
  +Add Comment

List of books and articles every IT professional should read. Add your recommendations!
Posted By Mike Prestwood, Post #100150, KB Topic: IT Water-Cooler for Power-Users
  +Add Comment  (10 Comments)




Topic: Lighter Side

Apparently if the first and last letters are correct, the rest don't matter.
Posted By Mike Prestwood, Post #100694, KB Topic: Lighter Side
  +Add Comment  (3 Comments)




Topic: Techie Jokes

We can't do this proposed project.

Posted By Mike Prestwood, Post #100352, KB Topic: Techie Jokes
  +Add Comment  (2 Comments)

311. Wife Upgrade

Last year a friend of mine upgraded Girlfriend 1.0 to Wife 1.0

Posted By Mike Prestwood, Post #100353, KB Topic: Techie Jokes
  +Add Comment  (1 Comments)




Group: Technical Writing





Topic: Publishing

Use up to four levels within articles (Heading 1..4). Within text, bold language elements and menu options. Use italics to bring attention to non-code things such as companies, important words, etc. Use bold+Italic for embedded topics and follow with a colon. Use the paragraph style for text and preformatted for code. Max width for images is 700 pixels.
Posted By Mike Prestwood, Post #101711, KB Topic: Publishing
  +Add Comment




Group: PM, Process, and PSDP





Topic: PSDP & 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?

Posted By Mike Prestwood, Post #100527, KB Topic: PSDP & Process
  +Add Comment  (2 Comments)




Topic: PSDP Analysis

The term software artifact has a general meaning in software development process. Several processes have used this term as part of their process. This article focuses on both the general definition and a specific implementation in PSDP Online.
Posted By Mike Prestwood, Post #100934, KB Topic: PSDP Analysis
  +Add Comment




Topic: PSDP Development

Guidelines for create proof of concepts (POCs).

Posted By Mike Prestwood, Post #101994, KB Topic: PSDP Development
  +Add Comment




Topic: PSDP General

Description of PSDP.
Posted By Mike Prestwood, Post #100151, KB Topic: PSDP General
  +Add Comment

Brief summary of how UML workflows map to the PSDP phases.
Posted By Mike Prestwood, Post #100149, KB Topic: PSDP General
  +Add Comment  (1 Comments)




Group: Staff Intranet





Topic: Coding Div Training

Ted talk on design appropriate for software developers.

Posted By Mike Prestwood, Post #102455, KB Topic: Coding Div Training
  +Add Comment




Topic: Directors (Tech=AD/MP Others)

Info for all our directors.

Posted By Mike Prestwood, Post #102328, KB Topic: Directors (Tech=AD/MP Others)
  +Add Comment

Kick start tech staff. Watch tech whiteboard to make sure all use their planner. Plus watch it throughout day to make sure they enter timers within 5 minutes of returning and have one running at the office for their stuff. All=whiteboard/clean. Each=Planner, My Home, communication, then work from assignments.

Posted By Mike Prestwood, Post #102329, KB Topic: Directors (Tech=AD/MP Others)
  +Add Comment

TBD

Posted By Mike Prestwood, Post #102330, KB Topic: Directors (Tech=AD/MP Others)
  +Add Comment




Topic: eBay Management (AT)

Procedure and notes regarding Prestwood listings on eBay.

Posted By Mike Prestwood, Post #101309, KB Topic: eBay Management (AT)
  +Add Comment  (1 Comments)




Topic: Filing (LP/AP)

323. Filing

At least twice a week, file all papers in GRAY slots on top of filing cabinet.

Posted By Mike Prestwood, Post #102519, KB Topic: Filing (LP/AP)
  +Add Comment




Topic: Holiday Cards, Oct/Nov (LP)

The holiday season is a great opportunity to "touch base" with every single client.

Posted By Mike Prestwood, Post #102064, KB Topic: Holiday Cards, Oct/Nov (LP)
  +Add Comment




Topic: Marketing

Claim your free listing. Phone verification required.

Posted By Mike Prestwood, Post #102701, KB Topic: Marketing
  +Add Comment

Posted By Mike Prestwood, Post #103871, KB Topic: Marketing
  +Add Comment




Topic: Monthly Coupons (AT)

Maintain coupon database and printed coupon at front of office.

We use retention coupons to close a deal and to help soothe an upset client. Prize coupons require an authorized signature.

Posted By Mike Prestwood, Post #102514, KB Topic: Monthly Coupons (AT)
  +Add Comment




Topic: Office Cameras (AT)

Our QT4 series cameras replaced our old system in February 2012.

Posted By Mike Prestwood, Post #102363, KB Topic: Office Cameras (AT)
  +Add Comment  (1 Comments)




Topic: Client Forms

In Word templates and printed.

Posted By Mike Prestwood, Post #102451, KB Topic: Client Forms
  +Add Comment

Word templates and printed.

Posted By Mike Prestwood, Post #102445, KB Topic: Client Forms
  +Add Comment

Covers Timer Billing, WO Billing, and Items Tickets.

Posted By Mike Prestwood, Post #102268, KB Topic: Client Forms
  +Add Comment




Group: PrestwoodBoards





Topic: Message Board Help

How to become a moderator and moderator's guide.

Posted By Mike Prestwood, Post #100469, KB Topic: Message Board Help
  +Add Comment

How to create a custom avatar for use with http://www.prestwoodboards.com.
Posted By Mike Prestwood, Post #100476, KB Topic: Message Board Help
  +Add Comment

Guide to using our message boards
Posted By Mike Prestwood, Post #100475, KB Topic: Message Board Help
  +Add Comment  (7 Comments)

Our Prestwood Community rank titles are based on Star Trek's Starfleet Officer Ranks. I know, I know, it's a bit geeky, but what the heck. You rise up in the ranks by earning Prestwood points with our Member Points Program. You earn points by participating in our online community: visit, post, etc. You can spend your points in our online store.

Cadet 1st Year=O-0,  Lieutenant=O-3, Commodore=F-1, more...

The easiest way to earn points is to visit daily and post to our Prestwood Message Boards.

Posted By Mike Prestwood, Post #100477, KB Topic: Message Board Help
  +Add Comment  (3 Comments)




Topic: PrestwoodBoards

Displaying code snippets in the knowledge base and message boards can be a bit tricky. You cannot use "&_lt;", "&_gt;", "&_amp;lt;", nor "&_amp;gt;" (minus underscores).
Posted By Mike Prestwood, Post #101277, KB Topic: PrestwoodBoards
  +Add Comment

Member points information.

Posted By Mike Prestwood, Post #100529, KB Topic: PrestwoodBoards
  +Add Comment  (8 Comments)

A message board is for Q&A, blogs are personal, and WIKI's are controlled.

Posted By Mike Prestwood, Post #100405, KB Topic: PrestwoodBoards
  +Add Comment

From any group, you can display a random tidbit, article, cross reference example, or message board thread. This is a fun and convenient way to browse content quickly to find interesting gems. To use this new feature, visit your favorite group and click on one of the random links in the left column menu.

Posted By Mike Prestwood, Post #101769, KB Topic: PrestwoodBoards
  +Add Comment  (2 Comments)

The Prestwood Online Community rules and disclaimers. Essentially, our policies all center around be-friendly, don't flame, encourage more discussion, and limit advertising to approved areas.

Posted By Mike Prestwood, Post #101179, KB Topic: PrestwoodBoards
  +Add Comment

Good behavior while participating in online communities, blogs, newsgroups, message boards, etc. Although this article is specific to our website, it's intention is general in nature.

Posted By Mike Prestwood, Post #101178, KB Topic: PrestwoodBoards
  +Add Comment

Go to pda.prestwood.com for the small screen version of PPC with small screen features such as a random tidbit browser for studying on the go! All pages are specially designed to look as good as possible on your tiny-screen phone, iPhone, Blackberry, PocketPC, or Palm. To get started, browse to pda.prestwood.com with your PDA-ish device.

kb PDA articlekb PDA article

Posted By Mike Prestwood, Post #101770, KB Topic: PrestwoodBoards
  +Add Comment




Group: Prestwood IT Solutions





Topic: ASPSuite

This error is usually a result of folder permissions.

Posted By Mike Prestwood, Post #100244, KB Topic: ASPSuite
  +Add Comment

How customizable is ASPSuite.

Posted By Mike Prestwood, Post #100242, KB Topic: ASPSuite
  +Add Comment  (1 Comments)




Topic: ATIS

The current version of ATIS is 4.9. We are currently focusing on supporting existing ATIS customers.

Posted By Mike Prestwood, Post #100218, KB Topic: ATIS
  +Add Comment  (1 Comments)




Topic: Coding Services Info

To Do:

  1. Create a new project ticket to store requirements.
  2. Create 1 tasks or artifact for each specific feature or deliverable to the client. For example, one artifact for the framework, and one for each form, report, and supporting application such as an installation program, or help file. If a printed user manuel is desired, we usually complete that with a separate Documentation project, but you could add that as a task to the requirements document as well.

2-Step or Rolling Estimates

With our 2-Step approach, we stop after an initial step-1 effort and seek authorization to build the application. With our rolling estimates approach, we just roll right into building the application frequently starting the initial coding phase toward the end of a Req+Design phase.

Informal, Formal, and Robust

For our PSDP informal path, the requirements project is approved and we usually just roll with the requirements project as Step-2 of our 2-Step approach. With our Formal and Robust paths, our preferred technique is to copy the initial requirements into a new project and close the Initial Requirements project as complete prior to building the application. This allows us to establish a baseline of requirements and estimates we can measure ourselves against as the project proceeds. Plus, it clearly documents and changes in scope.

 

Posted By Mike Prestwood, Post #102413, KB Topic: Coding Services Info
  +Add Comment  (3 Comments)

Project management. Generally project management ranges from 10% to 30% of a project budget. However, the amount of project management required depends on the project.

Posted By Mike Prestwood, Post #101003, KB Topic: Coding Services Info
  +Add Comment

When converting an application, developers need access to a working version of the old app.

Setup old application so Prestwood developers have access to exercising the application. The old app can be setup at Prestwood, or at the client. If at the client, we need VPN access available to the application throughout the duration of the project.

Posted By Mike Prestwood, Post #102412, KB Topic: Coding Services Info
  +Add Comment

Help stabilize Paradox System with our proprietary procedure including oplocks, BDE settings, software updates (latest appropriate BDE/Paradox), and stabilize computers too. Also includes review of deployment architecture (appropriateness).

Posted By Mike Prestwood, Post #102140, KB Topic: Coding Services Info
  +Add Comment  (4 Comments)




Topic: eStore Storefront Software

Alter w_pay.inc. Prestwood eStore ships with an example that uses authorize.net.

Posted By Mike Prestwood, Post #100237, KB Topic: eStore Storefront Software
  +Add Comment  (1 Comments)

Use pay.inc to integrate various merchants.

Posted By Mike Prestwood, Post #100093, KB Topic: eStore Storefront Software
  +Add Comment




Topic: Historical Archive

Historical view of our old office located at 7525 Auburn Blvd, Ste 8.

Posted By Mike Prestwood, Post #101986, KB Topic: Historical Archive
  +Add Comment  (15 Comments)

Picture tour of the Prestwood offices at 8421 Auburn Blvd, Suite 256 (Auburn Oaks Plaza business complex).

Posted By Mike Prestwood, Post #102010, KB Topic: Historical Archive
  +Add Comment  (9 Comments)




Topic: JobDB

Code example of including a list of the 10 most recent jobs from Prestwood JobDB. (Prestwood JobDB is a module available with Prestwood ASPSuite.)

Posted By Mike Prestwood, Post #100097, KB Topic: JobDB
  +Add Comment




Topic: Load Balancer

Load Balancer installation.
Posted By Mike Prestwood, Post #100501, KB Topic: Load Balancer
  +Add Comment  (1 Comments)

Load Balancer routing options.
Posted By Mike Prestwood, Post #100500, KB Topic: Load Balancer
  +Add Comment  (1 Comments)

Load Balancer startup configuration options.
Posted By Mike Prestwood, Post #100498, KB Topic: Load Balancer
  +Add Comment  (1 Comments)

Load Balancer user interface options.
Posted By Mike Prestwood, Post #100502, KB Topic: Load Balancer
  +Add Comment




Topic: Prestwood eMag

Suggested topics and ideas for our monthly eMag.
Posted By Mike Prestwood, Post #100831, KB Topic: Prestwood eMag
  +Add Comment  (2 Comments)




Topic: Prestwood I.T.

Our security and privacy policy.

Posted By Mike Prestwood, Post #100453, KB Topic: Prestwood I.T.
  +Add Comment  (1 Comments)




Topic: Prestwood IT Events

Prestwood IT received two Best of Citrus Heights 2011 plaques at the annual Best Of luncheon. Prestwood IT won for best company in both Web Design and Computer Consulting categories. The event was sold out with over 150 attending.

Posted By Mike Prestwood, Post #102358, KB Topic: Prestwood IT Events
  +Add Comment  (1 Comments)




Topic: Prestwood Services

Our procedure for mining Thumbtack and Angi‘s.

Posted By Mike Prestwood, Post #104938, KB Topic: Prestwood Services
  +Add Comment  (5 Comments)




Topic: RequestDB

Code example of including the RequestDB mini control panel in your pages (for example, as part of your intranet).

Posted By Mike Prestwood, Post #100094, KB Topic: RequestDB
  +Add Comment




Topic: ResumeDB

Code example of including a list of the 10 most recent resumes from Prestwood ResumeDB. (Prestwood ResumeDB is a module available with Prestwood ASPSuite.)

Posted By Mike Prestwood, Post #100096, KB Topic: ResumeDB
  +Add Comment




Topic: Tech Services Info

DriveSavers Partner. After our recovery attempts offer to send to DriveSavers or equivalent. Price ranges from $2500 to $10000

Posted By Mike Prestwood, Post #102227, KB Topic: Tech Services Info
  +Add Comment  (4 Comments)

Computer data backup services for home users and small businesses in the greater Sacramento, CA area including online backup for disaster recovery, onsite hard drive backup, redundant hard drives in servers AND KEY WORKSTATIONS, and data backup and restore from one computer to another.

Posted By Mike Prestwood, Post #102232, KB Topic: Tech Services Info
  +Add Comment




Topic: Web & Marketing Services Info

Posted By Mike Prestwood, Post #102777, KB Topic: Web & Marketing Services Info
  +Add Comment




Topic: Help Wanted!

We are always looking for talented developers to work with us at our corporate office in Citrus Heights, CA and remotely from your home office.

Posted By Mike Prestwood, Post #100467, KB Topic: Help Wanted!
  +Add Comment  (1 Comments)

We are always looking for talented developers to participate in our message boards, post articles, etc.
Posted By Mike Prestwood, Post #100468, KB Topic: Help Wanted!
  +Add Comment  (1 Comments)

New unpaid intern position posted to Craigslist. We hire about 1 in 4 techs that go through our formal intern program. Either way, it's a great way to gain some real industry experience.

Posted By Mike Prestwood, Post #102370, KB Topic: Help Wanted!
  +Add Comment  (6 Comments)

371. Help Wanted!

Help Wanted!

Computer Techs and .Net Coders wanted

Do you live within 30 minutes of our office? Contact Us. Hiring now for the following positions:

  • Server Tech
  • .Net Programmer
  • Delphi Programmer
  • Paradox Programmer

Fax your resume to 916-726-5676.

Are you a talented server tech or .Net coder? If you live within 30 minutes of Citrus Heights, CA (near Sacramento), and are looking for work, contact us. We are looking to fill two postions at our corporate office in Citrus Heights (sorry, no remote work available).

Posted By Mike Prestwood, Post #102333, KB Topic: Help Wanted!
  +Add Comment  (8 Comments)

We offer 2 referal programs: client and general .

Posted By Mike Prestwood, Post #102236, KB Topic: Help Wanted!
  +Add Comment




Topic: Company Info

Posted By Mike Prestwood, Post #102242, KB Topic: Company Info
  +Add Comment  (1 Comments)

New computer support brochure!!! Printable versions of our brochures and flyers in PDF format.

Posted By Mike Prestwood, Post #101991, KB Topic: Company Info
  +Add Comment  (4 Comments)

Prestwood IT advertising strategy and history.

Posted By Mike Prestwood, Post #102246, KB Topic: Company Info
  +Add Comment

Listing of Prestwood IT awards. We will back fill with our varioius wins as time allows.

Posted By Mike Prestwood, Post #102245, KB Topic: Company Info
  +Add Comment  (1 Comments)

Prestwood IT Company Profile

Posted By Mike Prestwood, Post #102240, KB Topic: Company Info
  +Add Comment

Listing of Prestwood IT memberships and certifications.

Posted By Mike Prestwood, Post #102235, KB Topic: Company Info
  +Add Comment  (2 Comments)

Posted By Mike Prestwood, Post #102241, KB Topic: Company Info
  +Add Comment  (1 Comments)

Listing of Prestwood partners.

Posted By Mike Prestwood, Post #102234, KB Topic: Company Info
  +Add Comment  (2 Comments)

Social networking is a bit confusing! Emailing and calling are still the standards. Is faxing still ok? What about Facebook? Do I friend someone or become a fan of their fan page? Wait, what happened to fan pages? Are they now Facebook pages? What about Facebook groups? What about LinkedIn, YouTube, Twitter, MySpace, and others?

The following articles are posted to the PrestwoodBoards knowledge base:

The Prestwood Strategy: Although we still prefer phone calls and email, we do use social media to reach out. Our primary form of social networking is not with our clients, but with fellow IT professionals at PrestwoodBoards.com. Use the link above to learn more including how to interact with Prestwood IT, our other websites and groups, and our staff including Mike Prestwood.

For more information see...

Posted By Mike Prestwood, Post #102239, KB Topic: Company Info
  +Add Comment  (2 Comments)

Prestwood IT believes in community and participates as frequently as possible in sponsorships.

Posted By Mike Prestwood, Post #102238, KB Topic: Company Info
  +Add Comment  (3 Comments)

Our various Prestwood IT and PrestwoodBoards logos.

Posted By Mike Prestwood, Post #102237, KB Topic: Company Info
  +Add Comment  (2 Comments)

The following comments are a mix of comments from visitors to our www.Prestwood.com (business), and www.PrestwoodBoards.com (online community).

Posted By Mike Prestwood, Post #102243, KB Topic: Company Info
  +Add Comment




Group: Analysis & UML





Topic: Data Flow Diagrams (DFD)

DFDs document a process by documenting the flow of data throughout the process. They depict how data interacts with a system. They can be used to engineer a new process, document an existing process, or re-engineer an existing process.

Posted By Mike Prestwood, Post #100887, KB Topic: Data Flow Diagrams (DFD)
  +Add Comment  (14 Comments)




Topic: Unified Modeling Language (UML)

This introduction to the UML covers symbol usage, definitions, and creating diagrams. The UML standardizes what diagrams with what symbols for what situation. The UML is complete with diagrams for analysis, design, and coding. Use use case diagrams to document how users (actors) use a system (a use case). Use class and object diagrams for the design and coding of a system. A class is the prototype for an object. An object has attributes (properties) and the current values of those properties is the current state of the object.
Posted By Mike Prestwood, Post #100143, KB Topic: Unified Modeling Language (UML)
  +Add Comment  (2 Comments)




Group: Microsoft Access





Topic: Language Basics

Access VBA, like all the VB-based languages, uses a single quote (') or the original class-style basic "REM" (most developers just use a quote). Access VBA does NOT have a multiple line comment. Directives are sometimes called compiler or preprocessor directives. A # is used for directives within Access VBA code. Access VBA offers only an #If..then/#ElseIf/#Else directive.

Posted By Mike Prestwood, Post #101499, KB Topic: Language Basics
  +Add Comment  (7 Comments)

Same as VB. Access VBA logical operators:

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

Posted By Mike Prestwood, Post #101890, KB Topic: Language Basics
  +Add Comment  (3 Comments)

Access VBA is a loosely typed language. Declaring variables is optional unless you use the Option Explicit statement to force explicit declaration of all variables with Dim, Private, Public, or ReDim. Using Option Explicit is strongly recommended to avoid incorrectly typing an existing variable and to avoid any confusion about variable scope. Variables declared with Dim at the module level are available to all procedures within the module. At the procedure level, variables are available only within the procedure.

Posted By Mike Prestwood, Post #101571, KB Topic: Language Basics
  +Add Comment  (2 Comments)




Topic: Language Details

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.

Posted By Mike Prestwood, Post #101596, KB Topic: Language Details
  +Add Comment  (1 Comments)




Group: Website Owners





Topic: Getting Started

List of 20 reasons why you need to be on the Internet including to establish a presence/advertise, serve your customers, network with staff and vendors, to support your customers 24 hours a day, to reach the media, and to serve your local market.

Use these reasons as an Internet and email marketing guide for your web site. Does your website fully utilize each applicable reason?

Posted By Mike Prestwood, Post #100154, KB Topic: Getting Started
  +Add Comment  (3 Comments)

A static website is like a brochure. A dynamic website uses a database to present large amounts of data.
Posted By Mike Prestwood, Post #101017, KB Topic: Getting Started
  +Add Comment




Topic: Internet Marketing

Ideas for promoting your website.
Posted By Mike Prestwood, Post #101111, KB Topic: Internet Marketing
  +Add Comment  (11 Comments)

Marketing and sales is about reaching out to people. People are on social networks so you, or your company, should be out there too. For some companies, a particular social network such as Facebook is another valuable marketing channel. For others, a social network might be a way they interact with their key customers or vendors.

Posted By Mike Prestwood, Post #102151, KB Topic: Internet Marketing
  +Add Comment  (7 Comments)

Currently Facebook is the "it" website for social networking. Create a business page for your business, but ONLY if you‘re going to post business stuff to it at least once a month. A simple approach is to show the more social side of your business. Yes, you can post company happenings like specials, awards you‘ve won, events you‘re attending, and company functions like company picnics and get togethers.

You have to have a personal account, but if you really don‘t want to be on Facebook, you can create a personal Facebook account and only use it for business. This approach allows you to friend clients and interact with them, but you‘ll have to be disciplined and keep your family and true friends off of it, and keep it business focused. Meaning, like the old days, keep your politics, religion, and sex to yourself. You‘ll have to act within your personal Facebook page like you act at the office--professionally at all times.

If you already have a personal account, create a Facebook page for your business. If you don‘t wish to mix personal info with business, set your privacy settings to friends-of-friends and direct business-folk to your page. Facebook groups are limited to 5,000 members and are used for family, or friends, or club-like activity. However, if your club activity is public, it is better to use a fan page any way. Just like your public account, fan pages are indexed by the search engines but groups are not.

Posted By Mike Prestwood, Post #102154, KB Topic: Internet Marketing
  +Add Comment  (8 Comments)




Topic: Website Design Services

Increase your company's IQ with a properly built company wide intranet.
Posted By Mike Prestwood, Post #100991, KB Topic: Website Design Services
  +Add Comment  (1 Comments)

e-Commerce * e-Business * Members-only * Online Databases
Posted By Mike Prestwood, Post #100994, KB Topic: Website Design Services
  +Add Comment

FAQs related to Prestwood building your website.
Posted By Mike Prestwood, Post #100990, KB Topic: Website Design Services
  +Add Comment  (1 Comments)




Topic: Website Owners

Common security tasks for web browsers and web servers.
Posted By Mike Prestwood, Post #100107, KB Topic: Website Owners
  +Add Comment  (6 Comments)




Group: Delphi Prism





Topic: Delphi Prism

In Prism, a string can be nil (unassigned), assigned an empty string (""), or assigned a value.  Therefore, to check if a string is empty, you have to check against both nil and (""). Alternatively, you can check the length of the string or use String.IsNullOrEmpty.

Posted By Mike Prestwood, Post #102037, KB Topic: Delphi Prism
  +Add Comment




Topic: Tool Basics

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

Posted By Mike Prestwood, Post #101928, KB Topic: Tool Basics
  +Add Comment  (2 Comments)




Topic: Language Basics

Same as in Delphi for Win32 but Prism also supports inline variable declaration.

Posted By Mike Prestwood, Post #101645, KB Topic: Language Basics
  +Add Comment  (2 Comments)

In Prism, everything is within a class (just like with C#, VB.Net, and Java). So you create class methods using the method keyword. Alternatively, you can use procedure or function if you want the compiler to enforce returning or not returning a value.

Posted By Mike Prestwood, Post #101661, KB Topic: Language Basics
  +Add Comment

Unlike Delphi, Prism performs implicit casting. To concatenate two strings, a string to an integer, or a string to a floating point number, use the + operator. For example, to convert a floating point number to a string just concatenate an empty string to the number as in "" + 3.2.

Posted By Mike Prestwood, Post #101921, KB Topic: Language Basics
  +Add Comment  (3 Comments)

The Prism unary operators are:

+
-
Not

Posted By Mike Prestwood, Post #101896, KB Topic: Language Basics
  +Add Comment




Topic: Language Details

Like Delphi, Prism supports overloading. However, Prism supports implicit overloading (no need for an overload keyword).

Posted By Mike Prestwood, Post #101903, KB Topic: Language Details
  +Add Comment




Topic: OOP

Prism supports abstract class members and abstract classes using the abstract keyword. 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 (method, procedure, or function), a property, or an event in an abstract class. You can add abstract members ONLY to abstract classes using the abstract keyword. Alternatively, you can use the empty keyword in place of abstract if you wish to instantiate the abstract class.

Posted By Mike Prestwood, Post #101753, KB Topic: OOP
  +Add Comment

Declare your class in the Interface section. Then implement the class in the Implementation section. To create an object instance, use the New keyword. Optionally, you can use Create for backword compatibility with Delphi if you turn it on in the compatibility options. Since Prism does have a garbage collector, you do not have to free the object. If you need to free either unmanaged resources or resources where "timing" is important, implement IDisposable and take control of freeing the object yourself using Dispose.

Posted By Mike Prestwood, Post #101731, KB Topic: OOP
  +Add Comment  (1 Comments)

Prism uses unnamed constructor methods for constructors. Prism also supports a Create constructor method for backward compatibility with Delphi for Win32.

Posted By Mike Prestwood, Post #101836, KB Topic: OOP
  +Add Comment  (1 Comments)

Unlike Delphi, Delphi Prism uses the .Net garbage collector to free managed object instances. Prism does not have nor need a true destructor.

In .Net, a finalizer is used to free non-managed objects such as a file or network resource. Because you don't know when the garbage collector will call your finalizer, Microsoft recommends you implement the IDisposable interface for non-managed resources and call it's Dispose() method at the appropriate time.

Posted By Mike Prestwood, Post #101848, KB Topic: OOP
  +Add Comment

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

Posted By Mike Prestwood, Post #101733, KB Topic: OOP
  +Add Comment  (1 Comments)

In Prism you can set the visibility of a member field to any visibility: private, protected, public, assembly and protected or assembly or protected. Prism supports the readonly modifier for member fields which is handy for constant like data. In this case, I chose not to preface my read-only member field with "F" so it's usage is just like a read-only property. Prism also support the class modifier (static data) for member fields. Delphi developers should notice the use of := to initialize a member field (in Delphi you use an =).

Posted By Mike Prestwood, Post #101760, KB Topic: OOP
  +Add Comment  (1 Comments)

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.

Posted By Mike Prestwood, Post #101735, KB Topic: OOP
  +Add Comment

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.

Posted By Mike Prestwood, Post #101946, KB Topic: OOP
  +Add Comment

Prism supports both partial classes and partial methods using the keyword partial. A partial method is an empty method defined in a partial class.

Posted By Mike Prestwood, Post #101794, KB Topic: OOP
  +Add Comment




Topic: Delphi for .Net Archive

Delphi 8 fix for Required package Borland$ not found caused by the .Net Framework service pack 1 update.
Posted By Mike Prestwood, Post #100270, KB Topic: Delphi for .Net Archive
  +Add Comment  (21 Comments)




Group: Client Extranet





Topic: Coding Services

Usually includes screenshots with text, access to physical database for reference, or we document existing database. Other documentation might include creating videos of old app focusing on walking through of various use cases.

  1. Create app record in Enterprise Modeling, complete 100%.
  2. Create Old Requirements Document project. Usually best to stick with one task/artifact per screen. Skip General Requirements because that applies to new projects.
  3. Add App Specific Actors.
  4. Add App Specific Definitions.
  5. [Optional] Document old app General Design.
Posted By Mike Prestwood, Post #102411, KB Topic: Coding Services
  +Add Comment  (8 Comments)

Prestwood uses database expertise in development of a new student tracking application for renowned Chicago Department of Cultural Affairs/Gallery 37.
Posted By Mike Prestwood, Post #100025, KB Topic: Coding Services
  +Add Comment  (4 Comments)

Prestwood uses database expertise in development of a new student tracking application for renowned Chicago Department of Cultural Affairs/Gallery 37.
Posted By Mike Prestwood, Post #100026, KB Topic: Coding Services
  +Add Comment  (4 Comments)




Topic: New Client Area

What is the advantage of working with a smaller consulting firm like Prestwood versus a Big 5 IT consulting firm?
Posted By Mike Prestwood, Post #100856, KB Topic: New Client Area
  +Add Comment  (4 Comments)

Welcome to our New Client area and thank you for considering Prestwood Software for your software development outsourcing needs.
Posted By Mike Prestwood, Post #100458, KB Topic: New Client Area
  +Add Comment




Topic: PS Hosting

Online help.
Posted By Mike Prestwood, Post #101332, KB Topic: PS Hosting
  +Add Comment  (2 Comments)




Topic: PSDP Step 1-Discovery

PSDP Online Q&A

Posted By Mike Prestwood, Post #100463, KB Topic: PSDP Step 1-Discovery
  +Add Comment

Estimating the time to develop an entire project at the beginning of a project is a tricky task because of too many unknown variables.
Posted By Mike Prestwood, Post #100461, KB Topic: PSDP Step 1-Discovery
  +Add Comment

During Discovery we decide on an approach that works for both companies, establish an initial budget, and document what the software must do.
Posted By Mike Prestwood, Post #100460, KB Topic: PSDP Step 1-Discovery
  +Add Comment

The best way to get started is to submit a New Ticket. This ticket will be used to track your project. If you're ready to get started, you can open a support account and optionally pre-pay for some development hours.

Posted By Mike Prestwood, Post #100462, KB Topic: PSDP Step 1-Discovery
  +Add Comment




Topic: PSDP Step 2-Plan

During the planning step we document how the software will satisfy the requirements (the what) using a General Design followed by a Detail Design phase.
Posted By Mike Prestwood, Post #100464, KB Topic: PSDP Step 2-Plan
  +Add Comment




Topic: PSDP Step 3-Build

Quality is one of the factors that determines how much a project will cost. Functional applications are cheaper and faster to get to version 1.0 but cost more to maintain and enhance. In PSDP, functional applications include temporary and moderat risk projects. Robust applications cost a little more to get to version 1.0 but cost less to maintain and enhance. In PSDP, robust applications include high risk, commercial, and critical applications.
Posted By Mike Prestwood, Post #100459, KB Topic: PSDP Step 3-Build
  +Add Comment

During the building step, we actually build and debug the software with the Initial Coding and Testing and Rework phases.
Posted By Mike Prestwood, Post #100465, KB Topic: PSDP Step 3-Build
  +Add Comment




Topic: PSDP Step 4-Deliver

The Delivery of your software can be as simple as us emailing you the installation file or delivery can include on-site installation and training.
Posted By Mike Prestwood, Post #100466, KB Topic: PSDP Step 4-Deliver
  +Add Comment  (1 Comments)




Topic: Working Remotely with PS

For online business chatting, we use MSN Messenger. MSN Messenger also works with Windows Messenger which comes with Windows XP and above. MSN Messenger is a free download.

Posted By Mike Prestwood, Post #101101, KB Topic: Working Remotely with PS
  +Add Comment

For file management (to and from you), we do not normally use FTP. Instead we use our My Uploads feature to both upload a file to Prestwood and to view existing account files.

To get to your uploads, from the main pull-down menu click My | More... | My Uploads. Use the Upload a File option to send us a file. Use the File Manager options to view existing files you and others have uploaded to your account and files attached to notes. You can add a note to your account, tickets, and PSDP items (tasks, defects, requirement items, etc). All note attachments also show up in your My Uploads area.

Posted By Mike Prestwood, Post #101799, KB Topic: Working Remotely with PS
  +Add Comment

We offer both Vault and SourceOffsite to manage source code. Both have nearly the same feature set and both offer a remote desktop Windows applications for checking source code in and out.

Posted By Mike Prestwood, Post #101103, KB Topic: Working Remotely with PS
  +Add Comment




Topic: Dr. Bott

A Dr Bott uploader. This wizard uploads DrBott.com store items to our ASPSuite eStore storefront software. We can customize it to upload to your store from any drop-shipper.

Posted By Mike Prestwood, Post #101289, KB Topic: Dr. Bott
  +Add Comment  (1 Comments)

Sales Website: www.prestwood.com Or visit our legacy sales site: 
legacy.prestwood.com


©1995-2024 Prestwood IT Solutions.   [Security & Privacy]