I.T. Discussion Community!
Mike Prestwood -Collapse +Expand
Employee
-Collapse +Expand
mprestwood
-Collapse +Expand Profile
Member Info
Member Narration

POSTS:
MB Posts (1410)
KB Posts (1805)◄╣
KB Comments (76)
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
All Mike Prestwood's Short KB Articles
Mike Prestwood


About Me

Mike Prestwood is a drummer, an author, and creator of the PrestwoodBoards online community. He is the President & CEO of Prestwood IT Solutions. Prestwood IT provides Coding, Website, and Computer Tech services. Mike has authored 6 computer books and over 1,200 articles. As a drummer, he maintains play-drums.com and has authored 3 drum books. If you have a project you wish to discuss with Mike, you can send him a private message through his PrestwoodBoards home page or call him 9AM to 4PM PST at 916-726-5675 x205.




Knowledge Base Posts

More...
  KB Article    

Mike Prestwood
1. Document Known Terms

Every business and custom application uses terms defined for their business. Definitions help clarify communication by establishing the meaning of verbiage and can be either a word or phrase.

To do: Ask client for a list of terms. If they do not have a list, perhaps client staff can generate a list of definitions to kick-start documenting of known terms. We will add to the list as we discover them.

Deliverable: Included as part of the App Specification from the app menu, or printed and/or delivered to the client for review anytime from the App Definitions page.

Posted to KB Topic: Coding Services Info
22 months ago
(2 Comments , last by Scott.P )

SS
Nothing New Since Your Last Visit
1475
Hits

Prestwood IT Solutions

Mike Prestwood
2. Archive Legacy System

Get source code, database, and any existing documenation from client. Do NOT check old source code into version control. Instead, place all files on Drive P under folder \ClientLabel\AppLabel_Old\Source\*.*

Posted to KB Topic: Coding Services Info
22 months ago

SS
Nothing New Since Your Last Visit
1204
Hits

Prestwood IT Solutions

Mike Prestwood
3. Generate Legacy Paradox PDFs

Create documentation directly from legacy Paradox system. We have a suite of PDoxDos and PDoxWin analysis tools which create our data models, data dictionaries, file inventories, and searchable reference databases. This documentation is used to create the new database as well as to extract many data driven business rules. This step includes setting up the legacy system with data in our development environment so developers can exercise the legacy system anytime needed throughout both steps of our 2-step process.

Deliverable: Saved as PDFs on drive P as well as sent to the client in an email.

Posted to KB Topic: Coding Services Info
22 months ago

SS
Nothing New Since Your Last Visit
1214
Hits

Prestwood IT Solutions

Mike Prestwood
4. Identify Use Cases Only

After forms are identified, we initially identify but do not document in detail use cases (business processes). The documenting of uses cases can occur later in step 1 or early in step 2 of our 2-Step. Each use case is identified, labeled, and assigned to 1 or more actors as part of the Task Artifact that is identified with the specific form that contains use case, or in a UML Use Case diagram to accompany our standard documentation. If only a UML Use Case diagram is created at this point of the project, then the UML Use Case diagram is used during the Document Use Cases task where each use case and actor are associated with a specific App Artifact and documented.

Deliverable: 1+ tasks in step 1 or 2 of our 2-step. Optionally, we can deliver a UML use case diagram.

Posted to KB Topic: Coding Services Info
22 months ago
(3 Comments , last by Zara.B )

SS
Nothing New Since Your Last Visit
1567
Hits

Prestwood IT Solutions

Mike Prestwood
5. Identify and Document Actors

An actor represents a role or user of the application. Actors are defined with each application and can be linked with one or more requirement items, forms, and/or use cases (business processes).

Deliverable: Included as part of the App Specification from the app menu, or printed and/or delivered to the client for review anytime from the App Actors page.

Posted to KB Topic: Coding Services Info
22 months ago
(1 Comments , last by Thomas.H )

SS
Nothing New Since Your Last Visit
1303
Hits

Prestwood IT Solutions

Mike Prestwood
6. Convert, Identify Forms/Reports

Identify scope of the user interface. First, we identify forms and reports in use. Then narrow that list to what will be converted. In every case, the client drives this process with our help. Any forms or reports missed, can be added to the project when discovered. However, the client is responsible for validating the scope of the project. Each form and report is added to the step 2 of 2 build-it phase either as a task by itself or as part of task.

Posted to KB Topic: Coding Services Info
22 months ago

SS
Nothing New Since Your Last Visit
1002
Hits

Prestwood IT Solutions

Mike Prestwood
7. Other
Posted to KB Topic: Coding Services Info
24 months ago

SS
Nothing New Since Your Last Visit
1271
Hits

Prestwood IT Solutions

Mike Prestwood
8. Other
Posted to KB Topic: Web & Marketing Services Info
24 months ago

SS
Nothing New Since Your Last Visit
1087
Hits

Prestwood IT Solutions

Mike Prestwood
9. Other
Posted to KB Topic: Tech Services Info
24 months ago

SS
Nothing New Since Your Last Visit
1002
Hits

Prestwood IT Solutions

Mike Prestwood
10. Initial Pre-2-Step Discovery

Sometimes clients want to start a project with a small task or 2. This pre-project work is considered part of discovery and may include feasibility, documenting of an old system, data cleanup, etc. As soon as appropriate, the formal discovery should start with our Step 1 of our 2 step process.

Posted to KB Topic: Coding Services Info
25 months ago

SS
Nothing New Since Your Last Visit
1012
Hits

Prestwood IT Solutions

Mike Prestwood
11. New Server

New domain controller server. The suggested default is to use a Hyper-V host with 2012 or 2016 standard server VM. Optional additional VM servers can be added as needed including a File Server to centrally locate all important data, Exchange Server, etc.

Posted to KB Topic: Tech Services Info
25 months ago
(1 Comments , last by iwan.r )

SS
Nothing New Since Your Last Visit
1252
Hits

Prestwood IT Solutions

Mike Prestwood
12. New/Move Office

Broader scope than just a cabling job. Can include cabling, vendor management (ISP, phones, etc.), setup or move of server, workstations, etc.

Posted to KB Topic: Tech Services Info
25 months ago
(1 Comments , last by Ermelinda_D._Tw)

SS
Nothing New Since Your Last Visit
1049
Hits

Prestwood IT Solutions

Mike Prestwood
13. Cabling Job

Billing models can be per drop, or time and materials.

Posted to KB Topic: Tech Services Info
25 months ago

SS
Nothing New Since Your Last Visit
715
Hits

Prestwood IT Solutions

Mike Prestwood
14. Enhance Website
Posted to KB Topic: Web & Marketing Services Info
25 months ago

SS
Nothing New Since Your Last Visit
934
Hits

Prestwood IT Solutions

Mike Prestwood
15. New Website
Posted to KB Topic: Web & Marketing Services Info
25 months ago

SS
Nothing New Since Your Last Visit
719
Hits

Prestwood IT Solutions

Mike Prestwood
16. 2 of 2, AppName 1.0

Step 2 of 2: Build-It

  • PSDP Initial Coding Phase: Build MVC shell with user management and login. Build data migration program. Build initial forms. Alpha builds. Add mobile readiness.
  • PSDP Testing & Rework Phase: Beta builds with optional double entry alongside existing application.
  • PSDP Deployment and Maintenance Phase: Deploy. Establish maintenance plan.

Step 2 of our 2 step is used to complete an application by building it. This step 2 project ticket is created during discovery, during step 1 of our 2-step process. For projects over 500 hours, we break up our step 2 of 2 into multiple projects of 500 hours or less. In which case, the App Tickets option on the application menu tracks overall progress.

This project ticket documents requirements in App Artifacts. However, there may be some completed requirements in previous projects including step 1 projects, which is appropriate. This project also documents any tasks that are required to complete the project including PM, testing, and deployment. The combination of tasks and artifacts in this project represent the project plan for building the app.

If the client has authorized work, it is set to In-Progress and work can start as soon as resources are ready which means, depending on billing relationship and approach, this step 2 build project can overlap with a step 1 discovery project. If this ticket is not authorized, the printed version of the Project Plan is the Project Proposal for Building of the next version of the application.

Posted to KB Topic: Coding Services Info
25 months ago, and updated 22 months ago

SS
Nothing New Since Your Last Visit
1074
Hits

Prestwood IT Solutions

Mike Prestwood
17. 1 of 2, AppName 1.0

Step 1 of 2: Discovery

  • PSDP Feasibility Phase: Setup legacy system for coders. Document legacy system using automated tools.
  • PSDP Requirements Phase: Identify forms and reports to convert. Document terms, actors, and identify use cases. Identify enhancements (if any). Identify tables in use.
  • PSDP Design Phase: Build new database. Initial screen design mockup. Document business rules and additional documentation of use cases.

Step 1 deliverables usually include a project plan for the Step 2 of 2 build-it phase which serves as the requirements, a new database, and a GUI mockup. Each form and report becomes a task in step 2 of our 2-step process along with other known tasks such as build data migration program, build MVC Shell Application, user subsystem, and admin forms for maintaining users, lookup tables, etc.

Step 1 of our 2 step approach is used to start a project with discovery. Step 2 is build. The goal of discovery is to document known requirements, some initial design, and a project plan. Step 1 of our 2 step includes at least the following tasks: Gather Requirements, Build GUI Mockup, and Create the Initial Database. The Requirements task becomes the project plan for step 2, Build.

Discovery can include additional tasks such as documenting an existing application, data cleanup, and even a task or two from the initial coding phase such as implementing our Prestwood ASP.Net MVC shell which includes some initial design, and member management.

If this ticket is not authorized, the printed version of the Project Plan is the Project Proposal for Discovery. Once authorized, the tasks of this project are completed. The requirements task is completed by creating a Step 2 of 2 project ticket which becomes the project plan and/or the proposal for Step 2, Build.

Posted to KB Topic: Coding Services Info
25 months ago, and updated 22 months ago

SS
Nothing New Since Your Last Visit
1040
Hits

Prestwood IT Solutions

Mike Prestwood
18. Wordpress Theme Install and Customize
Posted to KB Topic: Web & Marketing Services Info
25 months ago

SS
Nothing New Since Your Last Visit
608
Hits

Prestwood IT Solutions

Mike Prestwood
19. Wordpress Plugin Install & Setup
Posted to KB Topic: Web & Marketing Services Info
25 months ago

SS
Nothing New Since Your Last Visit
687
Hits

Prestwood IT Solutions

Mike Prestwood
20. Installation Program
Posted to KB Topic: Coding Services Info
25 months ago

SS
Nothing New Since Your Last Visit
666
Hits

Prestwood IT Solutions

Mike Prestwood
21. Subsystem

2+ forms and/or reports.

Posted to KB Topic: Coding Services Info
25 months ago

SS
Nothing New Since Your Last Visit
601
Hits

Prestwood IT Solutions

Mike Prestwood
22. Tech Task, Large (10+ Hours)

Client Request: 

To Do:

  1. Initial estimate=2 hours.
  2. Evaluate, define approach, then... 
    • Use this ticket: Update estimate, seek client authorization.
    • Create a project ticket, seek cient authorization, and close original ticket.
    • Need more time? Update estimate on original ticket, seek authorization.
Posted to KB Topic: Tech Services Info
25 months ago

SS
Nothing New Since Your Last Visit
595
Hits

Prestwood IT Solutions

Mike Prestwood
23. Tech Task, Small (Under 10 Hours)

Client Request: 

To Do:

  1. Initial estimate=2 hours.
  2. Evaluate, complete work within 2 hours, or update estimate.
  3. Then... 
    • If ticket billing relationship is T&M Ongoing, keep going.
    • If T&M Notify, notify client, keep going. 
    • Otherwise, wait for client to authorize. Once authorized, update Authorized field.
Posted to KB Topic: Tech Services Info
25 months ago
(1 Comments , last by Jimmy.N )

SS
Nothing New Since Your Last Visit
937
Hits

Prestwood IT Solutions

Mike Prestwood
24. Prospect, Cabling Job

Establish scope of cabling job, discover...

  • # and length of drops
  • materials needed: faceplates, etc.
  • estimate people power (watch for challenges like metal in walls)

Time Estimate: Okay to perform up to 4 hours at no charge. Usually used to walk the building. Beyond that, if there are tasks that need to be done prior to proposing or starting a New Cabling project, do them against this ticket or create a new ticket(s).

Goal: If client is ready to proceed, create a separate New Cabling project ticket and propose to client.

Posted to KB Topic: Tech Services Info
25 months ago

SS
Nothing New Since Your Last Visit
807
Hits

Prestwood IT Solutions

Mike Prestwood
25. Prospect, Office Move

Establish scope of office move job, discover...

  • cabling needs, start a separate cabling project or integrate with this one
    • # and length of drops
    • materials needed: faceplates, etc.
    • estimate people power (watch for challenges like metal in walls)
  • Are we moving computers? Best if we at least move the server, but we'd like to move all "devices", but NOT furniture.
  • Are all vendors lined up?
  • Does the server room need preping? Mini-split?

Time Estimate: Okay to perform up to 4 hours at no charge. Usually used to walk the building. Beyond that, if there are tasks that need to be done prior to proposing or starting an Office Move project, do them against this ticket or create a new ticket(s). For example, if they want help with vendors such as phone, ISP, and others, that's billable work.

Goal: If client is ready to proceed, create a separate Office Move project ticket for work not performed under this ticket and propose to client.

Posted to KB Topic: Tech Services Info
25 months ago

SS
Nothing New Since Your Last Visit
612
Hits

Prestwood IT Solutions

Mike Prestwood
26. Coding Task, Large (10+ Hours)

Client Request:

To Do:

  1. Initial estimate=2 hours.
  2. Evaluate, define approach, then... 
    • Use this ticket: Update estimate, seek client authorization.
    • Create a project ticket, seek cient authorization, and close original ticket.
    • Need more time? Update estimate on original ticket, seek authorization.
Posted to KB Topic: Coding Services Info
25 months ago

SS
Nothing New Since Your Last Visit
520
Hits

Prestwood IT Solutions

Mike Prestwood
27. Web Dev Task, Small (Under 10 Hours)

Client Request: 

To Do:

  1. Initial estimate=2 hours.
  2. Evaluate, complete work within 2 hours, or update estimate.
  3. Then... 
    • If ticket billing relationship is T&M Ongoing, keep going.
    • If T&M Notify, notify client, keep going. 
    • Otherwise, wait for client to authorize. Once authorized, update Authorized field.
Posted to KB Topic: Web & Marketing Services Info
25 months ago

SS
Nothing New Since Your Last Visit
516
Hits

Prestwood IT Solutions

Mike Prestwood
28. Prospect, Open New Office

Establish scope of our role with the opening of a new office, discover...

  • cabling needs, start a separate cabling project or integrate with this one
    • # and length of drops
    • materials needed: faceplates, etc.
    • estimate people power (watch for challenges like metal in walls)
  • Are we buying computers? We sell hardware and software, but NOT furniture.
  • Are all vendors lined up?
  • Does the server room need preping? Mini-split?

Time Estimate: Okay to perform up to 4 hours at no charge. Usually used to walk the building. Beyond that, if there are tasks that need to be done prior to proposing or starting an Open New Office project, do them against this ticket or create a new ticket(s). For example, if they want help with vendors such as phone, ISP, and others, that's billable work.

Goal: If client is ready to proceed, create a separate Open New Office project ticket for work not performed under this ticket and propose to client.

Posted to KB Topic: Tech Services Info
25 months ago

SS
Nothing New Since Your Last Visit
654
Hits

Prestwood IT Solutions

Mike Prestwood
29. Prospect, New Server

Establish scope of new server job, discover...

  • Need a server? Create a separate Items ticket(s) for any hardware/software. Seek approval.
  • Determine appropriate migration path for domain controller (upgrade vs start over). Best to start clean.
  • Determine migration path for data.
  • Determine ongoing server support. You can't have a server without a support plan.

Time Estimate: Okay to perform up to 4 hours at no charge. Usually used to evaluate the server and generate quotes. Beyond that, if there are tasks that need to be done prior to proposing or starting a New Server project, do them against this ticket or create a new ticket(s). For example, if they want to clean up data and workstations prior to installing new server.

Goal: If client is ready to proceed, create a separate New Server project ticket for work not performed under this ticket and propose to client.

Posted to KB Topic: Tech Services Info
25 months ago

SS
Nothing New Since Your Last Visit
549
Hits

Prestwood IT Solutions

Mike Prestwood
30. Onboarding Other Task

Onboarding Task: 

Posted to KB Topic: Tech Services Info
25 months ago

SS
Nothing New Since Your Last Visit
577
Hits

Prestwood IT Solutions

Mike Prestwood
31. Prospect, Monthly Support Plan

Initial Concerns: 

We provide computer and networking support and maintenance with our monthly Managed Care plans.

Process:

  1. If a business, send Managed Care for Business flyer. If home user, send Managed Care for Families flyer.
  2. Follow up, ask,
    • "How much support per week or month do you need?"
    • "Are you interested in a plan with included hours or an unlimited support plan?"
  3. If interested, determine entry level from questions above, create 1 or 2 SLA quotes. If unsure and they are interested in included hours, create both a Bronze and Silver plan. If they are interested in unlimited support, create a Gold plan (unlimited support), plus a Silver plan for contrast.
  4. Send SLA.
  5. Follow up until yes/no.
Posted to KB Topic: Tech Services Info
25 months ago

SS
Nothing New Since Your Last Visit
537
Hits

Prestwood IT Solutions

Mike Prestwood
32. Prospect, Monthly Maint/SEO Plan

Initial Concerns: 

We provide website support and maintenance with our monthly Website Maintenance plans.

Process:

  1. Send Website Maintenance flyer.
  2. Follow up, ask,
    • "How much support and/or web changes per week or month do you need?"
    • "Are you interested in SEO or just maintenance?"
  3. If interested, determine entry level from questions above, create SLA.
  4. Send SLA.
  5. Follow up until yes/no.
Posted to KB Topic: Web & Marketing Services Info
25 months ago

SS
Nothing New Since Your Last Visit
551
Hits

Prestwood IT Solutions

Mike Prestwood
33. Prospect, Monthly App Support Plan

Initial Concerns: 

We provide app support and maintenance with our monthly App Maintenance plans.

Process:

  1. If Paradox, send Paradox Support Plan flyer; otherwise, send App Maintenance flyer.
  2. Follow up, ask, "How much support and/or coding per week or month do you need?"
  3. If interested, determine entry level from question above, create SLA.
  4. Send SLA.
  5. Follow up until yes/no.
Posted to KB Topic: Coding Services Info
25 months ago

SS
Nothing New Since Your Last Visit
595
Hits

Prestwood IT Solutions

Mike Prestwood
34. Prospect, Build App, New

Feasibility Phase, which is part of Discovery, can include converting any existing documentation into our system, or we can just get started by kicking off a Requirements+Design project.

Time Estimate: Although it depends on many factors, feasibility usually ranges from 0 to 16 hours, but each client varies. Our recommendation is that we kick-off a Requirements+Design project ASAP.

Goals:

  1. Define any initial feasibility tasks the client wants done plus propose any that come to mind.
  2. If appropriate to do a longer Feasibility Phase, then initiate a Feasibility Phase project.
  3. If client is ready to proceed, define 2-Step approach, initiate Step 1: Requirements+Design (What+Why) with minimum tasks of Requirements Document, Initial Database, and GUI Mockup.

Note: For the best chance of a successful project, limit version 1.0 to as few features as reasonable.

Posted to KB Topic: Coding Services Info
25 months ago

SS
Nothing New Since Your Last Visit
587
Hits

Prestwood IT Solutions

Mike Prestwood
35. Web Dev Task, Large (10+ Hours)

Client Request: 

To Do:

  1. Initial estimate=2 hours.
  2. Evaluate, define approach, then... 
    • Use this ticket: Update estimate, seek client authorization.
    • Create a project ticket, seek cient authorization, and close original ticket.
    • Need more time? Update estimate on original ticket, seek authorization.
Posted to KB Topic: Web & Marketing Services Info
25 months ago

SS
Nothing New Since Your Last Visit
476
Hits

Prestwood IT Solutions

Mike Prestwood
36. Prospect, New Website

Establish scope of new website, discover...

  • Web Page Flow Chart
  • New Page Content -- Does it already exist? Do they need help creating it?
  • Design Approach: do they have branding? colors? logo? theme?

Time Estimate: Okay to perform up to 4 hours at no charge. Beyond that, if there are tasks that need to be done prior to proposing or starting a New Website Project, do them against this ticket or create a new ticket(s).

Goals: If client is ready to proceed, create a separate New Website project ticket and propose to client.

Posted to KB Topic: Web & Marketing Services Info
25 months ago

SS
Nothing New Since Your Last Visit
482
Hits

Prestwood IT Solutions

Mike Prestwood
37. Prospect, Website Redesign

Establish scope of new website (redesign only, redesign with content changes). If content changes, discover...

  • Web Page Flow Chart -- stays the same? What pages go away, what stays?
  • Page Content Changes -- For existing pages, is there any content changes.
  • New Page Content -- Does it already exist? Do they need help creating it?

Time Estimate: Okay to perform up to 4 hours at no charge. Beyond that, if there are tasks that need to be done prior to proposing or starting a Redesign Project, do them against this ticket or create a new ticket(s).

Goals: If client is ready to proceed, create a separate Website Redesign project ticket and propose to client.

Posted to KB Topic: Web & Marketing Services Info
25 months ago

SS
Nothing New Since Your Last Visit
579
Hits

Prestwood IT Solutions

Mike Prestwood
38. Deliverable: GUI Mockup

Develop a GUI mockup that is not connected to a database. Although it can evolve, your goal is to specify the specific look and feel of the final application.

Rules:

  • Should have look and feel of final application.
  • Okay to build the technical shell and have a web developer skin and theme it.
  • Cannot be connected any data.
  • Should contain all major forms.
  • Long forms can have some fields skipped but you should include text on the form indicating such.
  • Simple one table lookup forms can be skipped but the menu option should be included.
  • Do NOT include reports as those will be specified later. Although, menu options with reports is okay.
Posted to KB Topic: Coding Services Info
25 months ago
(1 Comments , last by Dubi.D )

SS
Nothing New Since Your Last Visit
613
Hits

Prestwood IT Solutions

Mike Prestwood
39. Prestwood MVVM Shell

A rigid and clean ASP.Net MVC implementation based on MVVM appropriate for our Formal/Robust paths. The PM wil ensure the same coding techniques are used for all coding using our MVVM architectue.

Techniques which are limited in our MVVM architecture and include use of Telerik controls (licensed separately), direct access to the database (coders must go through an implemented data layer), use of GUIDS, lighter use of database views, and stored procedures.

C# Web Application using ASP.Net MVC to MS SQL.

This task includes:

  1. Setup basic shell database (user tables added in a separate task).
  2. Menu system with Admin menu added (user menu options added in a separate task).
  3. Login screen.
  4. Admin menu user management option with supporting form with defined users: Admin, and User.
Posted to KB Topic: Coding Services Info
25 months ago, and updated 25 months ago
(9 Comments , last by Rocky.s )

SS
Nothing New Since Your Last Visit
993
Hits

Prestwood IT Solutions

Mike Prestwood
40. Form: FormName

Define form specification and build. Integrate into system.

Estimate Note: Some simple forms can be built in a half day, complex forms can take up to 40 hours, very complex or redefined longer, some much longer.

Posted to KB Topic: Coding Services Info
25 months ago

SS
Nothing New Since Your Last Visit
536
Hits

Prestwood IT Solutions

Mike Prestwood
41. Report: ReportName

Define report specification and build. Integrate into reporting menu system.

Estimate Note: Most simple reports can be built in a half day, complex reports can take up to 16, very complex or redefined longer. 

Posted to KB Topic: Coding Services Info
25 months ago

SS
Nothing New Since Your Last Visit
508
Hits

Prestwood IT Solutions

Mike Prestwood
42. Prestwood MVC Shell

A flexible, get it done, ASP.Net MVC implementation based on standard traditional techniques. Appropriate for our Informal/Formal paths. The PM will NOT ensure the same coding techniques are used for all coding in favor of a satisfy the requirements approach. Syntax consistency is ensured by the development tool. Consistency of coding techniques is encouraged with good communication among the coders. Good solid coding techniques are used in all cases. Acceptable techniques which are limited in our MVVM architecture include direct access to the database bypassing an implemented data layer, use of autoinc keys over GUIDS, heavier use of database views, and stored procedures.

C# Web Application using ASP.Net MVC to MS SQL.

Includes:

  1. Setup basic shell database (user tables added in a separate task).
  2. Menu system with Admin menu added (user menu options added in a separate task).
  3. Login screen.
  4. Admin menu user management option with supporting form with defined users: Admin, and User.
Posted to KB Topic: Coding Services Info
25 months ago, and updated 25 months ago

SS
Nothing New Since Your Last Visit
684
Hits

Prestwood IT Solutions

Mike Prestwood
43. Deliverable: Initial Database

Create initial database. From an OOA viewpoint, you are identifying entities and attributes which is usually a requirements phase task. For us, we create an initial database that frequently evolves into the final database. With the initial database, your focus in on creating tables and fields and this task can be part of the requirements phase.

If converting from an old app, move existing tables and views only. If using an Informal Path, then normalize the database a reasonable amount ONLY. If you want to normalize more than very little, seek authorization from the client, but make sure they understand this will add to the cost of the project. If taking a Formal or Robust path, normalizing database more than a very little is still optional.

Posted to KB Topic: Coding Services Info
25 months ago

SS
Nothing New Since Your Last Visit
561
Hits

Prestwood IT Solutions

Mike Prestwood
44. Prospect, Build App, Convert from Old

Feasibility Phase, which is part of Discovery, can include documenting existing system, establishing scope of new application (meaning document what is in old app that is not needed, plus minimal needed additional features).

Time Estimate: Although it depends on the complexity of the old application, feasibility usually ranges from 16 to 40 hours, but for larger complex applications, they can be several hundred hours.

Goals:

  1. Define new project as a Strict Technical Conversion with few additions, or define as a Technical Conversion with Additions.
  2. If appropriate to do a longer Feasibility Phase, then initiate a Feasibility Phase project.
  3. If client is ready to proceed, define 2-Step approach, initiate Step 1: Requirements (What) with minimum deliverables of Requirements Document, Initial Database, and GUI Mockup.

Note: For the best chance of a successful project, limit changes to as few as reasonable.

Posted to KB Topic: Coding Services Info
25 months ago

SS
Nothing New Since Your Last Visit
1344
Hits

Prestwood IT Solutions

Mike Prestwood
45. Coding Task, Small (under 10 hours)

Client Request:

To Do:

  1. Initial estimate=2 hours.
  2. Evaluate, complete work within 2 hours, or update estimate.
  3. Then... 
    • If ticket billing relationship is T&M Ongoing, keep going.
    • If T&M Notify, notify client, keep going. 
    • Otherwise, wait for client to authorize. Once authorized, update Authorized field.
Posted to KB Topic: Coding Services Info
25 months ago

SS
Nothing New Since Your Last Visit
1291
Hits

Prestwood IT Solutions

Mike Prestwood
46. Windows Max Path+Filename Limit

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

Posted to KB Topic: Windows Users
34 months ago

FAQ

KB Post
Nothing New Since Your Last Visit
3218
Hits

Windows Users

Mike Prestwood
47. Setup Google Adwords
Posted to KB Topic: Marketing
53 months ago

KB Post
Nothing New Since Your Last Visit
3513
Hits

Staff Intranet

Mike Prestwood
48. Setup Yellow Pages (YP.com)

Claim your free listing. Phone verification required.

Posted to KB Topic: Marketing
53 months ago

KB Post
Nothing New Since Your Last Visit
3696
Hits

Staff Intranet

Mike Prestwood
49. Setup Google+

Use if you have a physical location and want to appear in local search results.

53 months ago

KB Post
Nothing New Since Your Last Visit
4247
Hits

Computer Industry

Mike Prestwood
50. Setup VPN

Setup VPN including configuring router and/or server and 1+ clients. Router must support VPN. Can be either router to router or use a Windows server. We prefer a Windows server but if the router is a SonicWall or Cisco, it's ok to use.

Posted to KB Topic: Tech Services Info
5 years ago

SS
Nothing New Since Your Last Visit
2438
Hits

Prestwood IT Solutions

Mike Prestwood
51. Filing

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

Posted to KB Topic: Filing (LP/AP)
6 years ago, and updated 29 months ago

KB Post
Nothing New Since Your Last Visit
3782
Hits

Staff Intranet

Mike Prestwood
52. Monthly Coupons

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 to KB Topic: Monthly Coupons (AT)
6 years ago

KB Post
Nothing New Since Your Last Visit
3098
Hits

Staff Intranet

Mike Prestwood
53. Ticket Training

Ticket training including the following pages: Client Portal, Service Tickets, My Team, Priorities, and reports. Concepts covered include creating a ticket, importance of ticket description (scope), adding notes, checking on time/status. If Prestwood agent installed, also includes the agent menu and how to capture a screen shot.

Posted to KB Topic: Prestwood Services
6 years ago

SS
Nothing New Since Your Last Visit
4181
Hits

Prestwood IT Solutions

Mike Prestwood
54. Physical to Hyper-V

Convert a physical hard drive to a Hyper-V virtual.

Posted to KB Topic: Tech Services Info
6 years ago

SS
Nothing New Since Your Last Visit
2244
Hits

Prestwood IT Solutions

Mike Prestwood
55. Search Optics Support

Help with search optics.

Posted to KB Topic: Tech Services Info
6 years ago

SS
Nothing New Since Your Last Visit
2009
Hits

Prestwood IT Solutions

Mike Prestwood
56. Redtail CRM Tech Support

Provide support help for software primarily as liaison. Although we do have experience and can perform many tasks.

Posted to KB Topic: Tech Services Info
6 years ago

SS
Nothing New Since Your Last Visit
2038
Hits

Prestwood IT Solutions

Mike Prestwood
57. Sage Act! Tech Support

Provide support help for software primarily as liaison. Although we do have experience and can perform many tasks.

Posted to KB Topic: Tech Services Info
6 years ago

SS
Nothing New Since Your Last Visit
1670
Hits

Prestwood IT Solutions

Mike Prestwood
58. Athena Tech Support

Provide support help for software primarily as liaison. Although we do have experience and can perform many tasks.

Posted to KB Topic: Tech Services Info
6 years ago

SS
Nothing New Since Your Last Visit
1611
Hits

Prestwood IT Solutions

Mike Prestwood
59. Intuit ProSeries Tax Tech Support

Provide support help for software primarily as liaison. Although we do have experience and can perform many tasks.

Posted to KB Topic: Tech Services Info
6 years ago

SS
Nothing New Since Your Last Visit
1543
Hits

Prestwood IT Solutions

Mike Prestwood
60. Intuit Quickbooks Data Coding

We can create custom IIF files for importing, direct data manipulation, etc.

Posted to KB Topic: Coding Services Info
6 years ago

SS
Nothing New Since Your Last Visit
1419
Hits

Prestwood IT Solutions

Mike Prestwood
61. ScanIT Parts Tech Support

Provide support help for software primarily as liaison. Although we do have experience and can perform many tasks.

Posted to KB Topic: Tech Services Info
6 years ago

SS
Nothing New Since Your Last Visit
2051
Hits

Prestwood IT Solutions

Mike Prestwood
62. In.Honda Tech Support

Provide support help for software primarily as liaison. Although we do have experience and can perform many tasks.

Posted to KB Topic: Tech Services Info
6 years ago

SS
Nothing New Since Your Last Visit
1937
Hits

Prestwood IT Solutions

Mike Prestwood
63. Yardi Systems Tech Support

Provide support help for software primarily as liaison. Although we do have experience and can perform many tasks.

Posted to KB Topic: Tech Services Info
6 years ago

SS
Nothing New Since Your Last Visit
1756
Hits

Prestwood IT Solutions

Mike Prestwood
64. Thomson Reuters Tech Support

Provide support help for software primarily as liaison. Although we do have experience and can perform many tasks. Including help with CS Professional Suite, Accounting CS, File Cabinet CS, Ultra Tax CS

Posted to KB Topic: Tech Services Info
6 years ago

SS
Nothing New Since Your Last Visit
1542
Hits

Prestwood IT Solutions

Mike Prestwood
65. Junxure Tech Support

Provide support help for software primarily as liaison. Although we do have experience and can perform many tasks.

Posted to KB Topic: Tech Services Info
6 years ago

SS
Nothing New Since Your Last Visit
1500
Hits

Prestwood IT Solutions

Mike Prestwood
66. Lacerte Tax Tech Support

Provide support help for Athena software primarily as liaison. Although we do have experience and can perform many tasks.

Posted to KB Topic: Tech Services Info
6 years ago

SS
Nothing New Since Your Last Visit
1328
Hits

Prestwood IT Solutions

Mike Prestwood
67. Intuit Quickbooks Tech Support

Provide support help for Intuit QuickBooks software.

Posted to KB Topic: Tech Services Info
6 years ago

SS
Nothing New Since Your Last Visit
1415
Hits

Prestwood IT Solutions

Mike Prestwood
68. Reynolds and Reynolds Tech Support

Provide support help for Reynolds and Reynolds software. Although this usually means working with their support staff (they don't allow others to support them), we do have experience and can perform many tasks and work as the liaison.

Posted to KB Topic: Tech Services Info
6 years ago

SS
Nothing New Since Your Last Visit
1461
Hits

Prestwood IT Solutions

Mike Prestwood
69. Mitchell Tech Support

Provide support help for Mitchell software. Although this usually means working with their support staff (they don't allow others to support them), we do have experience and can perform many tasks and work as the liaison.

Posted to KB Topic: Tech Services Info
6 years ago

SS
Nothing New Since Your Last Visit
1648
Hits

Prestwood IT Solutions

Mike Prestwood
70. Setup/Fix Server Antivirus

Add or upgrade Windows server antivirus software. Options include hosted antivirus (best choice), F-Secure, or other.

Posted to KB Topic: Tech Services Info
6 years ago

SS
Nothing New Since Your Last Visit
1374
Hits

Prestwood IT Solutions

Mike Prestwood
71. SEO: Localization Package

Optimize website for primary city of business and surrounding cities (up to 6 cities total). Optimized for cities, zip codes, and area codes specified. This combined with our SEO Primary Bundle will ensure your website and services will be found in your community.

Posted to KB Topic: Web & Marketing Services Info
6 years ago
(2 Comments , last by Douglas.G )

SS

Article
Nothing New Since Your Last Visit
8211
Hits

Prestwood IT Solutions

Mike Prestwood
72. Stabalize Paradox System Audit

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 to KB Topic: Coding Services Info
6 years ago
(4 Comments , last by Brian.T3 )

SS

Article
Nothing New Since Your Last Visit
7183
Hits

Prestwood IT Solutions

Mike Prestwood
73. Prospect, Network Assessment
  1. Hand them 'What We Do' Flyer.
  2. Perform network evaluation.
    • Count servers and workstations
    • Note server roles and installed software
    • Note network equipment (modem, router, firewall, switches, WAPs, etc.)
    • Determine whether usernames/passwords for all of the above are available for Prestwood
    • Determine client's main line of business, client's technical needs/expectations, and expected growth level
  3. Determine proper SLA entry point:
    • Bronze/Silver (client does not want a monthly plan, or)
    • Silver/Gold (pro-level only, included hours vs unlimited remote support)
    • Gold Only (easily can afford Gold so propose this ONLY)
  4. Back at office, create a proposal for needed work.
  5. Prepare 1 or 2 managed care proposal.
Posted to KB Topic: Tech Services Info
6 years ago, and updated 25 months ago

SS
Nothing New Since Your Last Visit
2076
Hits

Prestwood IT Solutions

Mike Prestwood
74. HD Data Recovery, Send Away

DriveSavers Partner. After our recovery attempts, offer to send to DriveSavers or equivalent. Price ranges from $500 to $1,500.

Posted to KB Topic: Tech Services Info
6 years ago
(2 Comments , last by Essie.H )

SS

Article
Nothing New Since Your Last Visit  
7801
Hits

Prestwood IT Solutions

Mike Prestwood
75. ASP.Net Storefront Procedure

Install, setup, and configure software. This is a robust store solution and we do this kind of work on an hourly basis. Price for software license billed separately.

Posted to KB Topic: Coding Services Info
6 years ago

SS
Nothing New Since Your Last Visit
1442
Hits

Prestwood IT Solutions

Mike Prestwood
76. BackupAssist Exchange Addon

Install and configure addon.

Posted to KB Topic: Tech Services Info
6 years ago

SS
Nothing New Since Your Last Visit
1651
Hits

Prestwood IT Solutions

Mike Prestwood
77. BackupAssist RSync Standalone+Cloud Storage

Purchase license, install software, help client purchase cloud storage, configure to use chosen cloud service.

Includes software+1yr upgrades ($173) plus setup to Amazon RSync cloud service ($350). Monthly data subcription paid to Amazon (or other).

Posted to KB Topic: Tech Services Info
6 years ago, and updated 6 years ago

SS
Nothing New Since Your Last Visit
2470
Hits

Prestwood IT Solutions

Mike Prestwood
78. Setup Dev Env
  1. If needed, setup database server and any other needed servers.
  2. Setup developer environment on developer workstation.
  3. Document procedure.
  4. If needed, duplicate to other developer workstations. 
Posted to KB Topic: Coding Services Info
6 years ago, and updated 25 months ago

SS
Nothing New Since Your Last Visit
1965
Hits

Prestwood IT Solutions

Mike Prestwood
79. Video: Simplicity Sells

Ted talk on design appropriate for software developers.

Posted to KB Topic: Coding Div Training
6 years ago

KB Post
Nothing New Since Your Last Visit
2874
Hits

Staff Intranet

Mike Prestwood
80. New Client Form

In Word templates and printed.

Posted to KB Topic: Client Forms
6 years ago

KB Post
Nothing New Since Your Last Visit
2855
Hits

Staff Intranet

Mike Prestwood
81. Prestwood Backup Form

Word templates and printed.

Posted to KB Topic: Client Forms
6 years ago

KB Post
Nothing New Since Your Last Visit
2477
Hits

Staff Intranet

Mike Prestwood
82. Setup Legacy App for Developers

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 to KB Topic: Coding Services Info
6 years ago, and updated 25 months ago

KB Post
Nothing New Since Your Last Visit
1630
Hits

Prestwood IT Solutions

Mike Prestwood
83. Deliverable: Requirements Document

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 to KB Topic: Coding Services Info
6 years ago, and updated 25 months ago
(3 Comments , last by Pamela.B )

KB Post
Nothing New Since Your Last Visit
3925
Hits

Prestwood IT Solutions

Mike Prestwood
84. Document Legacy System

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 to KB Topic: Coding Services
6 years ago, and updated 25 months ago

KB Post
Nothing New Since Your Last Visit
2020
Hits

Client Extranet

Mike Prestwood
85. Craigslist Job Posting Posted

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 to KB Topic: Help Wanted!
7 years ago
(5 Comments , last by lee.m )

KB Post
Nothing New Since Your Last Visit
16062
Hits

Prestwood IT Solutions

Mike Prestwood
86. Office Security Cameras

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

Posted to KB Topic: Office Cameras (AT)
7 years ago, and updated 32 months ago
(1 Comments , last by MarkS.Spea.M )

KB Post
Nothing New Since Your Last Visit
3229
Hits

Staff Intranet

Mike Prestwood
87. Prestwood IT Wraps First Company Car

Prestwood IT wraps it's first company car.

Posted to KB Topic: Company Info
7 years ago
(2 Comments , last by mprestwood )

News
Nothing New Since Your Last Visit
7562
Hits

Prestwood IT Solutions

Mike Prestwood
88. Prestwood IT Wins Best of Citrus Heights 2011

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 to KB Topic: Prestwood IT Events
7 years ago, and updated 7 years ago
(1 Comments , last by mprestwood )

KB Post
Nothing New Since Your Last Visit
6880
Hits

Prestwood IT Solutions

Mike Prestwood
89. 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 to KB Topic: Help Wanted!
8 years ago, and updated 5 years ago
(3 Comments , last by Pervez.J )

KB Post
Nothing New Since Your Last Visit
84780
Hits

Prestwood IT Solutions

Mike Prestwood
90. Self Help: Find Drivers & Updates

Link page for common support pages.

Posted to KB Topic: Computer Tech
8 years ago
(1 Comments , last by Uwais.Q )

KB Post
Nothing New Since Your Last Visit
75385
Hits

Computer Tech

Mike Prestwood
91. Self Help: Computer Restore Disks

Phone numbers of the major computer manufacturers.

Posted to KB Topic: Computer Tech
8 years ago
(1 Comments , last by Uwais.Q )

KB Post
Nothing New Since Your Last Visit
69011
Hits

Computer Tech

Mike Prestwood
92. Tech Director

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 to KB Topic: Directors (Tech=AD/MP Others)
8 years ago, and updated 33 months ago

KB Post
Nothing New Since Your Last Visit
4245
Hits

Staff Intranet

Mike Prestwood
93. Website Director

TBD

Posted to KB Topic: Directors (Tech=AD/MP Others)
8 years ago

KB Post
Nothing New Since Your Last Visit
3260
Hits

Staff Intranet

Mike Prestwood
94. All Directors

Info for all our directors.

Posted to KB Topic: Directors (Tech=AD/MP Others)
8 years ago

KB Post
Nothing New Since Your Last Visit
3557
Hits

Staff Intranet

Mike Prestwood
95. Vote for Prestwood IT

Best of Citrus Heights Contest
Cast YOUR Vote for Prestwood IT! Anyone can vote!

Prestwood IT is located in Citrus Heights, CA and we are entered into the following two categories:

Best Computer Company - Vote for Prestwood IT!
Please vote for us in the  Computer Services category.

Best Web Design Company - Vote for Prestwood IT!
We are also listed in the Web Design Category.

Posted to KB Topic: Prestwood I.T.
8 years ago, and updated 7 years ago

News
Nothing New Since Your Last Visit
10039
Hits

Prestwood IT Solutions

Mike Prestwood
96. Prestwood IT, Computer Company for Sacramento Mountain Lions

Prestwood IT is now the official computer company of your Sacramento Mountain Lions!

Posted to KB Topic: Prestwood I.T.
8 years ago

News
Nothing New Since Your Last Visit
5330
Hits

Prestwood IT Solutions

Mike Prestwood
97. Enable Telnet in Windows 7

telnet is not recognized as an internal or external command, operable program or batch file.

Posted to KB Topic: Windows 7
8 years ago

Error
Nothing New Since Your Last Visit
8318
Hits

Windows Users

Mike Prestwood
98. Uninstall IE9

How do I uninstall Internet Explorer 9?

Posted to KB Topic: Windows Users
8 years ago

FAQ

Article
Nothing New Since Your Last Visit
9699
Hits

Windows Users

Mike Prestwood
99. 7/18/11 - Prestwood IT @ Golf Tournament

Prestwood IT sponsoring Annual Past Chair's Golf Tournament 2011On Monday July 18th, Prestwood IT is sponsoring a tee at the Annual Past Chair's Golf Tournament which is put on by the Citrus Heights and Fair Oaks chambers. If you golf, take a look at this event and we'll see you on one of the tees!

Posted to KB Topic: Prestwood IT Events
8 years ago, and updated 8 years ago
(3 Comments , last by mprestwood )

News
Nothing New Since Your Last Visit
6479
Hits

Prestwood IT Solutions

Mike Prestwood
100. 6/29/11 - Prestwood IT @ Joint Chambers Mixer

On Wednesday June 29th, visit Prestwood IT at the multi-chamber event. Stop by our table top display to network with us, talk about technology, website design, internet advertising, or job opportunities.

  • 5:30 pm to 7 pm
  • North Ridge Country Club, 7600 Madison Avenue (in Fair Oaks)
Joint 4 Chamber Business Mixer:
  • Carmichael Chamber
  • Citrus Heights Regional Chamber
  • Fair Oaks Chamber
  • Orangevale Chamber
Posted to KB Topic: Prestwood IT Events
8 years ago, and updated 8 years ago

News
Nothing New Since Your Last Visit
5467
Hits

Prestwood IT Solutions

Mike Prestwood
101. Prestwood IT at Placer County Fair

Visit the Prestwood IT booth and win a prize! Prestwood IT will be at the Placer County Fair every day of the fair (June 23-26).

Posted to KB Topic: Prestwood IT Events
8 years ago, and updated 8 years ago
(1 Comments , last by mprestwood )

News
Nothing New Since Your Last Visit
5651
Hits

Prestwood IT Solutions

Mike Prestwood
102. Prestwood IT Summer 2011 Event Schedule

Calendar of events for Prestwood IT including marketing and speaking events.

  • Mike on Fox40 News
  • Street Events/Placer Fair
  • BPN

Use Facebook?

Visit our Facebook events calendar for a complete list of public events. Come see us!

Posted to KB Topic: Prestwood IT Events
8 years ago, and updated 8 years ago

News
Nothing New Since Your Last Visit
6465
Hits

Prestwood IT Solutions

Mike Prestwood
103. Join Mike Prestwood at BPN Networking Group

Are you a business professional? Looking for new customers? Join Mike Prestwood as his guest at his business networking group.

Businss Professionals Network (BPN) is for business professionals who are looking to exchange business ideas and gain new customers. Join Mike Prestwood as his guest at the next BPN meeting. This event is open to all business professionals. Please feel free to come to a meeting (just show up), or, even better, give Mike Prestwood a call at 916-726-5675 x205 and let him know you'll be coming.

Posted to KB Topic: Prestwood IT Events
8 years ago, and updated 8 years ago

News
Nothing New Since Your Last Visit
6760
Hits

Prestwood IT Solutions

Mike Prestwood
104. Prestwood IT at Downtown Loomis Thursday Night FamilyFest

Starting June 30th, visit the Prestwood IT booth and win a prize, talk about technology, or job opportunities. Prestwood IT will be there every Thursday night through August.

Posted to KB Topic: Prestwood IT Events
8 years ago, and updated 8 years ago
(2 Comments , last by mprestwood )

News
Nothing New Since Your Last Visit
7959
Hits

Prestwood IT Solutions

Mike Prestwood
105. Prestwood IT is Costco Business of the Month, June 2011

Prestwood IT is business of the month at our local Costco here in Citrus Heights. Stop by our display and pick up a very special Costco members only coupon (limit one coupon per customer).

Posted to KB Topic: Company Info
8 years ago, and updated 8 years ago

News
Nothing New Since Your Last Visit
4910
Hits

Prestwood IT Solutions

Mike Prestwood
106. Mike Prestwood on Fox 40 News

Think about your computer and what's on there. Pictures? Videos? Contacts? Tax information? Work files?

Original air date: 5/17/2011.

Posted to KB Topic: Prestwood IT Events
8 years ago, and updated 8 years ago

News
Nothing New Since Your Last Visit
5673
Hits

Prestwood IT Solutions

Mike Prestwood
107. Mike Prestwood at Roseville Downtown Tuesday Nights 2011

Prestwood IT at Roseville Downtown Tuesday NightsStop by the Prestwood IT booth and meet Mike Prestwood. Talk technology, pick up a job application for Prestwood IT, or just say hello.

Posted to KB Topic: PrestwoodBoards
8 years ago
(8 Comments , last by adam.h3 )

News
Nothing New Since Your Last Visit
5445
Hits

PrestwoodBoards

Mike Prestwood
108. Prestwood IT at Roseville Downtown Tuesday Nights 2011

Prestwood IT at Roseville Downtown Tuesday NightsVisit the Prestwood IT booth at the Roseville Downtown Tuesday Nights event and win a prize! Prestwood IT will be there every Tuesday night through July.

Posted to KB Topic: Prestwood IT Events
8 years ago, and updated 8 years ago
(3 Comments , last by mprestwood )

News
Nothing New Since Your Last Visit
6790
Hits

Prestwood IT Solutions

Mike Prestwood
109. Prestwood IT at Earth Day Celebration 2011 in Roseville

Join Prestwood IT for our first annual Earth Day Celebration. Prestwood IT will be at the BPN booth next to Mutual of Omaha. BPN is Mike's networking group and we are co-sponsoring the petting zoo with Mutual of Omaha.

Posted to KB Topic: Prestwood IT Events
8 years ago, and updated 8 years ago
(1 Comments , last by Jane.G )

News
Nothing New Since Your Last Visit
4772
Hits

Prestwood IT Solutions

Mike Prestwood
110. Delphi Gazette Archive: 1998

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

8 years ago

KB Post
Nothing New Since Your Last Visit
7026
Hits

Pascal and Delphi Coding

Mike Prestwood
111. Work Order Form

Covers Timer Billing, WO Billing, and Items Tickets.

Posted to KB Topic: Client Forms
8 years ago, and updated 8 years ago

KB Post
Nothing New Since Your Last Visit  
2367
Hits

Staff Intranet

Mike Prestwood
112. HTML Copyright Entity Reference

How do you embed a copyright character/symbol into an HTML page?

Posted to KB Topic: HTML Language Reference
8 years ago
(3 Comments , last by silican.g )

FAQ
Nothing New Since Your Last Visit
9759
Hits

Website Design & Hosting

Mike Prestwood
113. Outlook 2010/2013 View Email Source, HTML, and Header

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 to KB Topic: Microsoft Outlook
8 years ago
(6 Comments , last by Pervez.J )

KB Post
Nothing New Since Your Last Visit
32175
Hits

Windows Users

Mike Prestwood
114. Prestwood eMag March Edition Now Available!

After two months off, the Prestwood eMag started sending again today now with no Prestwood IT business content!

Posted to KB Topic: PrestwoodBoards
8 years ago

News
Nothing New Since Your Last Visit
4258
Hits

PrestwoodBoards

Mike Prestwood
115. The Prestwood March Newsletter Started Sending!

After two months off, the Prestwood newsletter started sending again today!

Posted to KB Topic: Prestwood eMag
8 years ago

News
Nothing New Since Your Last Visit
4307
Hits

Prestwood IT Solutions

Mike Prestwood
116. Prestwood IT Social Networking Strategy

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 to KB Topic: Company Info
8 years ago
(2 Comments , last by jame.k )

KB Post
Nothing New Since Your Last Visit
10803
Hits

Prestwood IT Solutions

Mike Prestwood
117. FreeWheel by Jim Barry
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 to KB Topic: Paradox & ObjectPAL
8 years ago
(1 Comments , last by Larry.H )

Download

Article
Nothing New Since Your Last Visit
21744
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
118. Home Page Now More Relevant!

Today we posted changes to your home page. Now your home page shows you your most relevant content from the groups you've joined and the threads you've participated in. New posts for the groups you've joined show up right below your group icons. Your most recently updated threads you've participated in right below that. Finally, your latest posts right below that.

Also, in a continued effort to separate Prestwood IT from PrestwoodBoards, the Prestwood IT specific groups and topics no longer show up on the group list nor on the groups menu.

Posted to KB Topic: PrestwoodBoards
8 years ago

News
Nothing New Since Your Last Visit
4134
Hits

PrestwoodBoards

Mike Prestwood
119. Install Paradox 9 on Windows 7 64bit

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 to KB Topic: Installation, Setup, & BDE
8 years ago, and updated 8 years ago
(12 Comments , last by Pervez.J )

Article
Nothing New Since Your Last Visit
52619
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
120. Prestwood IT Ads

Prestwood IT advertising strategy and history.

Posted to KB Topic: Company Info
8 years ago

KB Post
Nothing New Since Your Last Visit
5367
Hits

Prestwood IT Solutions

Mike Prestwood
121. Prestwood IT Awards

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

Posted to KB Topic: Company Info
8 years ago, and updated 6 years ago

KB Post
Nothing New Since Your Last Visit
7014
Hits

Prestwood IT Solutions

Mike Prestwood
122. Visitor Comments

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

Posted to KB Topic: Company Info
8 years ago

KB Post
Nothing New Since Your Last Visit
5314
Hits

Prestwood IT Solutions

Mike Prestwood
123. Prestwood IT Mission and Vision Statements
Posted to KB Topic: Company Info
8 years ago, and updated 6 years ago

KB Post
Nothing New Since Your Last Visit
6153
Hits

Prestwood IT Solutions

Mike Prestwood
124. More About Prestwood...
Posted to KB Topic: Company Info
8 years ago

KB Post
Nothing New Since Your Last Visit
5732
Hits

Prestwood IT Solutions

Mike Prestwood
125. Prestwood IT Company Profile

Prestwood IT Company Profile

Posted to KB Topic: Company Info
8 years ago, and updated 20 months ago

KB Post
Nothing New Since Your Last Visit
6233
Hits

Prestwood IT Solutions

Mike Prestwood
126. Prestwood IT Sponsorships

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

Posted to KB Topic: Company Info
8 years ago
(3 Comments , last by HARRISON.B )

KB Post
Nothing New Since Your Last Visit
5855
Hits

Prestwood IT Solutions

Mike Prestwood
127. Prestwood Logos

Our various Prestwood IT and PrestwoodBoards logos.

Posted to KB Topic: Company Info
8 years ago
(1 Comments , last by clark.J )

KB Post
Nothing New Since Your Last Visit
5926
Hits

Prestwood IT Solutions

Mike Prestwood
128. Prestwood IT Referral Program

We offer 2 referal programs: client and general .

Posted to KB Topic: Help Wanted!
8 years ago

KB Post
Nothing New Since Your Last Visit
5353
Hits

Prestwood IT Solutions

Mike Prestwood
129. Prestwood IT Memberships

Listing of Prestwood IT memberships and certifications.

Posted to KB Topic: Company Info
8 years ago

KB Post
Nothing New Since Your Last Visit
5404
Hits

Prestwood IT Solutions

Mike Prestwood
130. Prestwood IT Partners

Listing of Prestwood partners.

Posted to KB Topic: Company Info
8 years ago, and updated 8 years ago
(2 Comments , last by Anonymous )

KB Post
Nothing New Since Your Last Visit
8819
Hits

Prestwood IT Solutions

Mike Prestwood
131. Prestwood IT Wins Best of Citrus Heights 2010

Prestwood IT wins for best company in both Web Design and Computer Consulting categories.

Posted to KB Topic: Company Info
8 years ago, and updated 8 years ago

News
Nothing New Since Your Last Visit
6908
Hits

Prestwood IT Solutions

Mike Prestwood
132. Prestwood Backup Options Overview

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 to KB Topic: Tech Services Info
9 years ago, and updated 6 years ago

KB Post
Nothing New Since Your Last Visit  
5530
Hits

Prestwood IT Solutions

Mike Prestwood
133. Change MS Word Markup Default to Off

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 to KB Topic: Microsoft Office
9 years ago

FAQ

KB Post
Nothing New Since Your Last Visit
10688
Hits

Windows Users

Mike Prestwood
134. Not enough quota is available to process this command.

Not enough quota is available to process this command.

Posted to KB Topic: Windows Vista
9 years ago

Error
Nothing New Since Your Last Visit
17350
Hits

Windows Users

Mike Prestwood
135. Delphi XE Tour in Sacramento

RAD Studio XE Tour - SACRAMENTO, CA. Free Pizza and soda!!!!  Sponsored by Prestwood IT Solutions - www.prestwood.com

Posted to KB Topic: Sac Delphi User Group
9 years ago
(1 Comments , last by lowster11 )

News
Nothing New Since Your Last Visit
6101
Hits

Pascal and Delphi Coding

Mike Prestwood
136. PrestwoodBoards Reaches 11,000 Members!

Today PrestwoodBoards hit the 11,000 members mark!

Posted to KB Topic: PrestwoodBoards
9 years ago
(8 Comments , last by Getcertify.P )

News
Nothing New Since Your Last Visit
10561
Hits

PrestwoodBoards

Mike Prestwood
137. Perl Constants (use constant)

In PHP, you declare constants using the define keyword:

define("CONST_NAME", "Value");

Constants in PHP are case sensitive. A common standard in PHP is to use all-uppercase letters, with underscores to separate words within the name.

Posted to KB Topic: Perl
9 years ago

Code
Nothing New Since Your Last Visit
9507
Hits

Perl

Mike Prestwood
138. PHP Constants (define)

In PHP, you declare constants using the define keyword:

define("CONST_NAME", "Value");

Constants in PHP are case sensitive. A common standard in PHP is to use all-uppercase letters, with underscores to separate words within the name.

Posted to KB Topic: PHP
9 years ago

Code
Nothing New Since Your Last Visit
8631
Hits

PHP & Delphi for PHP

Mike Prestwood
139. Carbonite FAQ

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

Posted to KB Topic: Backup Software
9 years ago, and updated 9 years ago

KB Post
Nothing New Since Your Last Visit
8187
Hits

Computer Tech

Mike Prestwood
140. Carbonite, Add a Backup Extension

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 to KB Topic: Backup Software
9 years ago

KB Post
Nothing New Since Your Last Visit
10888
Hits

Computer Tech

Mike Prestwood
141. ASP Classic Error 3709

Run-time error '3709':
Operation is not allowed on an object referencing a closed or invalid connection.

Posted to KB Topic: Language Details
9 years ago
(3 Comments , last by petter.s )

Error
Nothing New Since Your Last Visit
12587
Hits

ASP Classic Coding

Mike Prestwood
142. 10 Second Review: Adblock Plus

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

Posted to KB Topic: Online Security
9 years ago

KB Post
Nothing New Since Your Last Visit
5139
Hits

Windows Users

Mike Prestwood
143. ASP Classic Edit Record (AddNew, Update, Delete)

In ASP, using ADO, you use RecordSet.AddNew to add a new record, Recordset.Update to post the record, and RecordSet.Delete to delete it. To edit a record, you open the RecordSet using an editable cursor.

Posted to KB Topic: ASP Classic
9 years ago

Code
Nothing New Since Your Last Visit
17226
Hits

ASP Classic Coding

Mike Prestwood
144. ASP Classic Yes/No Function

The following function demonstrates one technique for coding a Yes/No dropdown. It uses a for loop which can be expanded to handle more than the 3 states (Y, N, and blank).

Example of calling the function:

Do you fish? <%=YesNoDropDown("ynFish", "")%>
Posted to KB Topic: ASP Classic
9 years ago
(1 Comments , last by neil.j )

Code
Nothing New Since Your Last Visit
7255
Hits

ASP Classic Coding

Mike Prestwood
145. PrestwoobBoards Recent Additions

Many new features including an enhanced PrestwoodBoards home page.

Posted to KB Topic: PrestwoodBoards
9 years ago, and updated 9 years ago

News
Nothing New Since Your Last Visit
3848
Hits

PrestwoodBoards

Mike Prestwood
146. Using Facebook for Business Checklist & FAQ

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 to KB Topic: Internet Marketing
9 years ago, and updated 9 years ago
(7 Comments , last by Rodgers.G )

KB Post
Nothing New Since Your Last Visit
15008
Hits

Website Owners

Mike Prestwood
147. Set time limit for disconnected session setting

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 to KB Topic: Windows Server 2003
9 years ago

FAQ

Article
Nothing New Since Your Last Visit
12236
Hits

Computer Tech

Mike Prestwood
148. Open Relay/Blacklist Tests http://www.mailradar.com/openrelay/
Posted to KB Topic: Admin Server Tools
9 years ago

Link
Nothing New Since Your Last Visit
5467
Hits

Computer Tech

Mike Prestwood
149. Social Networking Business Strategies

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 to KB Topic: Internet Marketing
9 years ago, and updated 9 years ago
(6 Comments , last by Rodgers.G )

Article
Nothing New Since Your Last Visit
19971
Hits

Website Owners

Mike Prestwood
150. Cat 5, 5e, 6, and 6a Connectors

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

Posted to KB Topic: Wired Networking
10 years ago

FAQ

KB Post
Nothing New Since Your Last Visit
8738
Hits

Computer Tech

Mike Prestwood
151. Assign IP Address Range to VPN Clients

On Windows Server 2003, how do you assign a specific range of IP addresses using DHCP to VPN clients?

Posted to KB Topic: Windows Server 2003
9 years ago, and updated 9 years ago

FAQ
Nothing New Since Your Last Visit
8881
Hits

Computer Tech

Mike Prestwood
152. New Feature: Anonymous Posts!

Over the years we've had many requests for the ability to post anonymously. Today I add the ability to both reply to message board threads anonymously as well as to knowledge base posts. You still need an account if you wish to start a new message board thread or post a knowledge base article. In addition, you can now use the special 'devnull@prestwood.com' email address if you wish to create an account but not use a valid email address.

Posted to KB Topic: Message Board Help
9 years ago, and updated 9 years ago
(1 Comments , last by petter.s )

News
Nothing New Since Your Last Visit
4256
Hits

PrestwoodBoards

Mike Prestwood
153. Delphi Array (x=Array[0..3] of string;)

Delphi supports both static and dynamic arrays.

Posted to KB Topic: Delphi for Win32
9 years ago
(2 Comments , last by Anonymous )

Code

KB Post
Nothing New Since Your Last Visit  
19573
Hits

Pascal and Delphi Coding

Mike Prestwood
154. ObjectPAL Array (Array[] type)

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 to KB Topic: Paradox & ObjectPAL
9 years ago
(5 Comments , last by Venyer.T )

Code

KB Post
Nothing New Since Your Last Visit  
14733
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
155. Restart Windows Computer Batch File

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 to KB Topic: Software
9 years ago

KB Post
Nothing New Since Your Last Visit
6850
Hits

Computer Tech

Mike Prestwood
156. Paradox 9 Help & PDF Files

Paradox 9 ships with several very valuable help files. For convenience, you can also download them here.

Posted to KB Topic: Paradox & ObjectPAL
9 years ago
(3 Comments , last by David.J3 )

Download
Nothing New Since Your Last Visit
28801
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
157. VB Classic Array (x = Array())

Arrays in VB Classic use a 0-based indice. UBound returns -1 if the array has no elements, 0 if it has 1, 1 if it has 2, etc.

Posted to KB Topic: VB Classic
9 years ago

Code
Nothing New Since Your Last Visit  
9548
Hits

Visual Basic Classic

Mike Prestwood
158. ASP Classic Array (x = Array())

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 to KB Topic: ASP Classic
9 years ago, and updated 8 years ago

Code

KB Post
Nothing New Since Your Last Visit  
14151
Hits

ASP Classic Coding

Mike Prestwood
159. Access VBA Array (x = Array())

Arrays in Access VBA use a 0-based indice. UBound returns -1 if the array has no elements, 0 if it has 1, 1 if it has 2, etc.

Posted to KB Topic: Access & VBA
9 years ago
(2 Comments , last by shravi.v )

Code
Nothing New Since Your Last Visit  
11283
Hits

Microsoft Access

Mike Prestwood
160. OLEAuto Paradox to Outlook

The following code snippet adds an appointment to your Outlook calendar. Tested with Paradox 9 and Outlook 2003 but should work with later versions of both programs.

Note, you will get a Error opening server 'Outlook.Application' error if your antivirus program is blocking Outlook access.

Posted to KB Topic: OPAL: Wicked Coding Tasks
9 years ago
(1 Comments , last by Lotfi.F )

Code
Nothing New Since Your Last Visit
8651
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
161. BDE SQL Links Not Maintained

I have an application in Delphi 1-7, using BDE. Is there a way that I can upgrade the BDE so the can work with MSSQL 2005 or 2008. They work fine if MSSQL2000 is is used. Am I on a dead end or there is still hope?

Posted to KB Topic: BDE
9 years ago, and updated 9 years ago
(2 Comments , last by mina.l )

FAQ
Nothing New Since Your Last Visit
11291
Hits

Pascal and Delphi Coding

Mike Prestwood
162. ObjectPAL Sort Records (switchIndex, sortTo, setGenFilter)

In Paradox, you add an index for each sort your wish to perform on a table then use switchIndex(). Alternatively, you can use sortTo() to sort a table into a new table.

Posted to KB Topic: OPAL: Language Details
9 years ago

Code
Nothing New Since Your Last Visit
9405
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
163. ObjectPAL Record Movement (home, end, nextRecord)

ObjectPAL uses home(), end(), nextRecord(), priorRecord() to move a database cursor (works with either a TCursor or UIObject).

TCursor.nextRecord()

These commands send a message to the object. Specifically, they send an action constant using the action command. The above snippet is equivalent to:

TCursor.action(DataNextRecord)

It is handy to  with familiar with action constants because not all action constants have an ObjectPAL equivalent comment.

Posted to KB Topic: OPAL: Language Details
9 years ago

Code
Nothing New Since Your Last Visit
7118
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
164. ObjectPAL Find Record (locate, qLocate)

ObjectPAL provides a rich set of commands for finding a record with a TCursor or UIObject including:

  • locate() -  Seach for a value based on a criteria. Uses indexes as appropriate.
  • locatePattern() - Search for a pattern within a value.
  • moveToRecord() - Moves to a specific record number.
  • qLocate() - Search using currently set index.

Each of these basic find record commands has supporting commands such as locateNext() and recNo().

Posted to KB Topic: OPAL: Language Details
9 years ago

Code
Nothing New Since Your Last Visit
8435
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
165. ObjectPAL Filter Records (setRanger, setGenFilter)

In ObjectPAL, you can filter set a TCursor, UIObject, and Table objects using setRange() and setGenFilter().

Posted to KB Topic: OPAL: Language Details
9 years ago

Code
Nothing New Since Your Last Visit
9390
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
166. ObjectPAL Edit Record (insertRecord, postRecord, edit)

In ObjectPAL, you use Cursor.InsertRecord to add a new record, Cursor.postRecord to post the record, and Cursor.deleteRecord() to delete it. To edit a record, you must put the cursor into edit mode, Cursor.Edit(). (A cursor applies to both a TCursor and UIObject.)

ObjectPAL gives you tremendous flexibility with editing data and includes many additional commands such as insertAfterRecord and isEdit. For dBASE tables, you can also use unDeleteRecord() to un-delete a record. See the ObjectPAL help for more commands.

Posted to KB Topic: OPAL: Language Basics
9 years ago

Code
Nothing New Since Your Last Visit
8675
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
167. ASP Classic Sort Records (Sort)

In ASP, using ADO, you sort a set of records using the Sort property.

Posted to KB Topic: ASP Classic
9 years ago

Code
Nothing New Since Your Last Visit
6999
Hits

ASP Classic Coding

Mike Prestwood
168. ASP Classic Filter Records (Filter)

In ASP, using ADO, you filter a set of records using Filter.

Posted to KB Topic: ASP Classic
9 years ago

Code
Nothing New Since Your Last Visit
7281
Hits

ASP Classic Coding

Mike Prestwood
169. ASP Classic Find Record (Find, Seek)

In ASP, using ADO, you use Find and Seek to move a cursor of a RecordSet to a matching record.

Posted to KB Topic: ASP Classic
9 years ago

Code
Nothing New Since Your Last Visit
6537
Hits

ASP Classic Coding

Mike Prestwood
170. ASP Classic Record Movement (MoveFirst, MoveLast, MoveNext)

ASP uses MoveFirst, MoveLast, MoveNext, and MovePrevious to move a database cursor (a RecordSet).

objRecordSet.MoveNext
Posted to KB Topic: ASP Classic
9 years ago
(3 Comments , last by fuzail.f )

Code
Nothing New Since Your Last Visit
16257
Hits

ASP Classic Coding

Mike Prestwood
171. Web Application Stress Tool (WAST)

The free Microsoft web stress tool is designed to realistically simulate multiple browsers requesting pages from a Web site.

Posted to KB Topic: Windows Hosting
11 years ago

Download
Nothing New Since Your Last Visit
12259
Hits

Website Design & Hosting

Mike Prestwood
172. DDR SDRAM Memory Module

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

Posted to KB Topic: RAM
10 years ago

KB Post
Nothing New Since Your Last Visit  
6347
Hits

Computer Tech

Mike Prestwood
173. MS SQL 2008 Saving Changes Not Permitted

In MS SQL 2008, if you get a Saving Changes Not Permitted error, you can easily fix this error in Management Studio. Uncheck the Prevent saving changes that require table re-creation option. 

Posted to KB Topic: MS SQL 2008
10 years ago

Error
Nothing New Since Your Last Visit
9505
Hits

DBA, Databases, & Data

Mike Prestwood
174. Paradox and TWAIN Support

Does Paradox for Windows support TWAIN?

Posted to KB Topic: OPAL: Wicked Coding Tasks
10 years ago

FAQ
Nothing New Since Your Last Visit
6969
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
175. RAD Studio 2010 Tour! See Delphi 2010!

Embarcadero TechnologiesSee What's New in RAD Studio 2010 at a Free Seminar
COMING TO A CITY NEAR YOU!

Technology is moving fast. Learn the secrets to getting the most out of RAD Studio 2010 and new Windows technologies by attending the RAD Studio 2010 Tour in a city near you. These free two-hour technical seminars, led by noted experts David Intersimone, Anders Ohlsson, Nick Hodges, or Mike Rozlog, will give you a firsthand look at new capabilities that will make you more productive and successful with Delphi--, C++Builder--, Delphi Prism-- and Embarcadero-- RAD Studio 2010.

Touch the future with Delphi, C++Builder, and Delphi Prism!

Posted to KB Topic: Coding & OO
10 years ago

News
Nothing New Since Your Last Visit
12458
Hits

Coding & OO

Mike Prestwood
176. Prestwood Sponsors RAD Studio 2010 Sacramento Tour Stop!

Prestwood Software is sponsoring the Technology is moving fast. During this free two-hour technical seminar, you'll learn the secrets to getting the most out of RAD Studio 2010 and new Windows technologies.  You'll get a firsthand look at new capabilities that will make you more productive and successful with Delphi--, C++Builder--, Delphi Prism-- and Embarcadero-- RAD Studio 2010.

RAD Studio/Delphi 2010 Sacramento Tour Stop! 
Wednesday, December 2, 2009
6:00PM - 8:00PM

New Horizons of Sacramento
1750 Creekside Oaks Drive, Suite 150
Sacramento, CA 95833

Sponsored by:

Prestwood Software

Posted to KB Topic: Delphi for Win32
10 years ago, and updated 10 years ago

News
Nothing New Since Your Last Visit
5299
Hits

Pascal and Delphi Coding

Mike Prestwood
177. New Prestwood Study Tests

 Although our Prestwood Certified area is currently in beta, our study tests are available now. Each study test features beginner, intermediate, and advanced questions. Although we have to add many more questions, the tests are live now and usable for study and review. The purpose of our study tests is to learn and review. You hover over answers to reveal the correct answer. Each question features a pop up [Review] link of study material. Test yourself and review concepts you are not familiar with.

New:  Check out our study tests...

Study, review, learn.

Posted to KB Topic: PrestwoodBoards
10 years ago, and updated 9 years ago
(4 Comments , last by Fred.F2 )

News
Nothing New Since Your Last Visit
10679
Hits

PrestwoodBoards

Mike Prestwood
178. John McCain Introduces Bill Against Net Neutrality

Despite it's name, "The Internet Freedom Act of 2009" does not free the Internet. It's an attack against Net Neutrality and yet another attempt to give the Internet to big business.

What is Net Neutrality? Net neutrality (also network neutrality, Internet neutrality) frees restrictions on content, sites, or platforms, on the kinds of equipment that may be attached, and on the modes of communication allowed, as well as one where communication is not unreasonably degraded by other communication streams.

Posted to KB Topic: General News & Trends
10 years ago, and updated 10 years ago
(1 Comments , last by Jenny.W )

News
Nothing New Since Your Last Visit
5043
Hits

Computer Industry

Mike Prestwood
179. Move Table to Another Schema

In MS-SQL, to move an object such as a table or view from one schema to another, use alter schema.

Posted to KB Topic: Microsoft SQL Server
10 years ago

Code
Nothing New Since Your Last Visit  
11918
Hits

DBA, Databases, & Data

Mike Prestwood
180. 64-bit Version of Paradox for Windows

I wanted to check out if there was a 64 bit Paradox for Windows. I believe this database tool is excellent especially in defining a database.

Posted to KB Topic: Tool Basics
11 years ago, and updated 9 years ago
(5 Comments , last by Oren.W )

FAQ
Nothing New Since Your Last Visit  
18070
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
181. Quarterly Mailings

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

Posted to KB Topic: Holiday Cards, Oct/Nov (LP)
10 years ago, and updated 6 years ago

KB Post
Nothing New Since Your Last Visit
2858
Hits

Staff Intranet

Mike Prestwood
182. VB.Net Empty String Check (String.IsNullOrEmpty)

The .Net framework offers a static method in the string class: String.IsNullOrEmpty.

Posted to KB Topic: VB.Net
10 years ago
(2 Comments , last by Hasbvijapade )

Code
Nothing New Since Your Last Visit  
14476
Hits

VB.Net Language

Mike Prestwood
183. Windows 7 Pricing Announced

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 to KB Topic: Windows 7
10 years ago
(1 Comments , last by Don.L )

KB Post
Nothing New Since Your Last Visit
11615
Hits

Windows Users

Mike Prestwood
184. Prestwood 8421 Office Tour

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

Posted to KB Topic: Historical Archive
10 years ago
(7 Comments , last by Anonymous )

KB Post
Nothing New Since Your Last Visit
9090
Hits

Prestwood IT Solutions

Mike Prestwood
185. Paradox and PNG Images

Does Paradox for Windows support .PNG image files?

10 years ago

FAQ
Nothing New Since Your Last Visit
8218
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
186. Delphi Inline Code (asm)

In Delphi, you can inline assembler code using the asm keyword.

Posted to KB Topic: Delphi for Win32
10 years ago

Code
Nothing New Since Your Last Visit
9156
Hits

Pascal and Delphi Coding

Mike Prestwood
187. Delphi Event Handler

Many objects in Delphi have events you can use to trigger code. For example, when you add a form to your project you have access to the form events such as onCreate, onShow, onHide, onDockDrop, etc. In addition, Delphi offers module level events initialization and finalization sections.

Posted to KB Topic: Delphi for Win32
10 years ago

Code
Nothing New Since Your Last Visit
8681
Hits

Pascal and Delphi Coding

Mike Prestwood
188. Event Handler

In computer programming, an event handler is part of event driven programming where the events are created by the framework based on interpreting inputs. Each event allows you to add code to an application-level event generated by the underlying framework, typically GUI triggers such as a key press, mouse movement, action selection, and an expired timer. In addition, events can represent data changes, new data, etc. Specifically, an event handler is an asynchronous callback subroutine that handles inputs received in a program.

A custom event is a programmer created event. For example, you can contrast an event handler with a member event, an OOP concept where you add an event to a class.

Posted to KB Topic: General Coding Concepts
10 years ago

Definition
Nothing New Since Your Last Visit
9127
Hits

Coding & OO

Mike Prestwood
189. Delphi Member Events

In Delphi, member events are essentially properties of the type method pointer.

Posted to KB Topic: Delphi for Win32
10 years ago

Code
Nothing New Since Your Last Visit
7131
Hits

Pascal and Delphi Coding

Mike Prestwood
190. Delphi Prism Member Events (event)

Like all .Net languages, Prism events are a separate type of class member. You define a member event by using the event keyword. Events depend on Delegates to define the signature (the type) of the event they represent and they maintain a list of multiple subscribers - unlike in Delphi for Win32, where each event can only have one handler

Posted to KB Topic: Delphi Prism
10 years ago

Code
Nothing New Since Your Last Visit
7770
Hits

Delphi Prism

Mike Prestwood
191. Delphi Prism Event Handler

The Delphi Prism

Most notable for Delphi developers is the fact that Prism does not offer initialization nor finalization sections.

Posted to KB Topic: Delphi Prism
10 years ago

Code
Nothing New Since Your Last Visit
10811
Hits

Delphi Prism

Mike Prestwood
192. JavaScript Event Handler

The JavaScript event handler contains events centered around the Document Object Model (DOM). Common events include onMouseOver and onMouseOut, onFocus and onBlur, onClick and onDblClick, onChange and onSelect, onLoad and onUnload.

For example, onMouseOver and onMouseOut are frequently used with websites to change an image when your mouse moves over it. The onClick event is used to trigger code upon a mouse click.

Posted to KB Topic: JavaScript and AJAX
10 years ago

Code
Nothing New Since Your Last Visit
9277
Hits

JavaScript and AJAX

Mike Prestwood
193. Member Event

A custom event added by a programmer to a class. Custom created events need to be processed, usually by an event dispatcher within a framework.

Posted to KB Topic: Object Orientation (OO)
10 years ago

Definition
Nothing New Since Your Last Visit
7460
Hits

Coding & OO

Mike Prestwood
194. C# Empty String Check (String.IsNullOrEmpty)

The .Net framework offers a static method in the string class: String.IsNullOrEmpty.

Posted to KB Topic: C#
10 years ago

Code
Nothing New Since Your Last Visit
9472
Hits

C# (Visual C# & VS.Net)

Mike Prestwood
195. Delphi Empty String Check (length(s) = 0)

Length() or SizeOf() will correctly identify an unassigned string variable or an empty string.

Posted to KB Topic: Delphi for Win32
10 years ago
(1 Comments , last by Uwais.Q )

Code
Nothing New Since Your Last Visit
16266
Hits

Pascal and Delphi Coding

Mike Prestwood
196. C++/CLI Empty String Check (String.IsNullOrEmpty)

The .Net framework offers a static method in the string class: String.IsNullOrEmpty.

Posted to KB Topic: C++
10 years ago
(1 Comments , last by Kolkata.Q )

Code
Nothing New Since Your Last Visit
17098
Hits

C++

Mike Prestwood
197. ObjectPAL Empty String Check (isBlank() or not isAssigned())

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 to KB Topic: OPAL: Language Basics
10 years ago, and updated 9 years ago
(2 Comments , last by Carry.M )

Code

KB Post
Nothing New Since Your Last Visit
10656
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
198. ASP Classic Empty String Check (Len(s&vbNullString))

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 to KB Topic: ASP Classic
10 years ago, and updated 9 years ago
(4 Comments , last by Eugene.P )

Code

Article
Nothing New Since Your Last Visit  
41301
Hits

ASP Classic Coding

Mike Prestwood
199. VB Classic Empty String Check (Len(s&vbNullString))

In VB 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 to KB Topic: VB Classic
10 years ago

Code
Nothing New Since Your Last Visit
8815
Hits

Visual Basic Classic

Mike Prestwood
200. Access VBA Empty String Check (Len(s&vbNullString))

In Access VBA, 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 to KB Topic: Access & VBA
10 years ago
(1 Comments , last by petter.s )

Code
Nothing New Since Your Last Visit
16796
Hits

Microsoft Access

Mike Prestwood
201. Delphi Prism Empty String Check (length)

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 to KB Topic: Delphi Prism
10 years ago

Code

KB Post
Nothing New Since Your Last Visit
14531
Hits

Delphi Prism

Mike Prestwood
202. Paradox on Terminal Server

Paradox Exit Error 1:
Save Configuration File
the file 'C:\Program Files\...\config\PDX_EN_FULL_sbar.cfg' could not be opened. Paradox Exit

Error 2:
Save Configuration File
The Statusbar Configuration File could not be opened.
The configuration cannot be saved.

Paradox Exit Error 3:
The file 'C:\Program Files\...\config\PDX_EN_FULL_bars.cfg' could not be opened.
The configuration cannot be saved.

BDE Error:
Database Engine Error
Cannot find Engine configuration file.
BDE Error: 8452 [$21][$ 4]

The Solution

As with getting most legacy applications to work correctly on Terminal Server, getting the BDE to work is a matter of rights. Once rights are setup, you can then configure the BDE.

There are many ways to solve these specific rights errors. One easy solution if you trust the users using the terminal server is to add them as administrators to the terminal server. An elegant way to accomplish this if you're using Active Directory is to add your user group to the Administrators group of the terminal server.

((Click link above for screen shots.))

Posted to KB Topic: Coding Services Info
10 years ago, and updated 6 years ago
(1 Comments , last by szld )

SS
Nothing New Since Your Last Visit
10512
Hits

Prestwood IT Solutions

Mike Prestwood
203. BDE on Terminal Server

BDE Error:

Database Engine Error
Cannot find Engine configuration file.
BDE Error: 8452 [$21][$ 4]

Posted to KB Topic: Borland Database Engine
10 years ago

Error
Nothing New Since Your Last Visit
14157
Hits

Coding & OO

Mike Prestwood
204. Sealed Classes

What is a sealed class?

Posted to KB Topic: OOP
11 years ago

FAQ
Nothing New Since Your Last Visit
7547
Hits

Pascal and Delphi Coding

Mike Prestwood
205. Converting from a Workgroup to a Domain

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 to KB Topic: Domains
10 years ago, and updated 7 years ago

KB Post
Nothing New Since Your Last Visit
13168
Hits

Computer Tech

Mike Prestwood
206. Protect Your Windows Computer Using FREE Tools

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 to KB Topic: Windows Users
10 years ago, and updated 10 years ago

KB Post
Nothing New Since Your Last Visit
8415
Hits

Windows Users

Mike Prestwood
207. Speed Up Your Windows Computer for FREE

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 to KB Topic: Windows Users
10 years ago, and updated 10 years ago
(1 Comments , last by joswin.m )

KB Post
Nothing New Since Your Last Visit  
11837
Hits

Windows Users

Mike Prestwood
208. Employers Pay for H-1B

Do employers have to pay to hire an H-1B worker?

10 years ago

FAQ
Nothing New Since Your Last Visit
6260
Hits

American I.T. Workforce

Mike Prestwood
209. H-1B Specialized Skill

Do H-1B workers have to have a specialized skill?

10 years ago
(1 Comments , last by Kate.B2 )

FAQ
Nothing New Since Your Last Visit
7032
Hits

American I.T. Workforce

Mike Prestwood
210. American-based Anti Adware

Which anti-adware/anti-malware products are made by American-based companies?

Posted to KB Topic: American-Based Companies
10 years ago
(8 Comments , last by fugolegat.1 )

FAQ
Nothing New Since Your Last Visit
7565
Hits

American I.T. Workforce

Mike Prestwood
211. It's Done: Borland is No More
A trip down memory lane: Borland 1983-2009
Micro Focus buys Borland. The decline of Borland is now complete. The once legendary software company is no more! Okay, for those of us that worked at Borland and those that loved their development tools, it pretty much was over years ago. For me, I'm still a big fan of the CodeGear development tools, especially Delphi and Prism, but the fanatical culture and clarity of purpose was over when Philippe Kahn left. I've been following Borland ever since I left the company in 1995 and every time I heard of a stupid move, I cringed. I'm sure all of us who have watched the decline of Borland over the years have a list of stupid Borland moves.
Posted to KB Topic: General News & Trends
10 years ago, and updated 10 years ago
(10 Comments , last by mprestwood )

News
Nothing New Since Your Last Visit
16950
Hits

Computer Industry

Mike Prestwood
212. Show Not Present Hidden Drivers in Device Manager

Right click on My Computer and select the Properties menu option then select the Advanced tab (in Vista, select the Advanced system settings then the Advanced tab). Click the Environment Variables button then the New button and add the following:

  • name = devmgr_show_nonpresent_devices
  • value = 1

Select Ok twice to close the Environment Variables dialog. In Device Manager on the Hardware tab, select View | Show Hidden Devices. Now both hidden devices and non-present devices will be listed. The non-present devices are grayed out.

Posted to KB Topic: Windows Users
10 years ago, and updated 9 years ago
(1 Comments )

Tip
Nothing New Since Your Last Visit
11771
Hits

Windows Users

Mike Prestwood
213. Uninstall in Safe Mode

By default, you cannot uninstall programs in Safe Mode. Whatever issue you are handling, your first choice is to resolve it using more acceptable solutions such as using System Restore or MSConfig. For MSConfig, try disabling all startup programs then see if you can use Add/Remove Programs. If you wish to enable the Windows Installer Service while in Safe Mode, add the following registry entry:

HKLM\SYSTEM\CurrentControlSet\Control\SafeBoot\Minimal\MSIServer\VE\TREG_SZ\F\D %Service%

Posted to KB Topic: Windows XP
10 years ago

Tip
Nothing New Since Your Last Visit
8662
Hits

Windows Users

Mike Prestwood
214. Hung versus Hanged

Use "hung" for things and longer durations. Use "hanged" for people and shorter durations.

Examples:

"I hung a picture on the wall."

"He hung a deer on a tree for butchering."

"Felicia and Ashley hung out last night."

"Horse theives were hanged in the 19th century."

"The terrorist was hanged and his corpse was hung on the tree."

Posted to KB Topic: Grammar
10 years ago

Tip
Nothing New Since Your Last Visit
8840
Hits

Technical Writing

Mike Prestwood
215. Fast, Free DNS Servers

The best free and fast DNS server service provider is OpenDNS. At least that's who we are currently using and recommending.

OpenDNS free dns server list:

  • 208.67.222.222
  • 208.67.220.220

If you wish to try others, search for free fast Public DNS Servers List.

Posted to KB Topic: DNS
10 years ago

Tip
Nothing New Since Your Last Visit
8333
Hits

Computer Tech

Mike Prestwood
216. Prestwood Brochures (new computer support)

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

Posted to KB Topic: Company Info
10 years ago, and updated 8 years ago
(3 Comments , last by Gerald.R_Ex1 )

KB Post
Nothing New Since Your Last Visit
9576
Hits

Prestwood IT Solutions

Mike Prestwood
217. Weak Wireless Signal

If you have a USB wireless device such as a wireless NIC, mouse controller, etc. that has a weak signal because of location, try adding a USB extension cable and placing the device in a more open location.

USB cables from stores such as Radio Shack, Best Buy, etc. are over priced 5 or 6 times what you can get on the internet.

For wireless network cards, you can also buy a range-extending antenna for the computer's WiFi card or router, or a wireless range extender.

Posted to KB Topic: Wireless Networking
10 years ago

Tip
Nothing New Since Your Last Visit
7912
Hits

Computer Tech

Mike Prestwood
218. Windows Internet Name Service (WINS)

Microsoft's implementation of NetBIOS Name Service (NBNS), a name server and service for NetBIOS computer names. Just as DNS serves up domain names, WINS serves up NetBios names and is particularly useful within a Microsoft-based network when or without the NetBIOS protocol installed. Use of WINS will decrease broadcast traffic.

Posted to KB Topic: WINS
10 years ago

Definition
Nothing New Since Your Last Visit
7817
Hits

Computer Tech

Mike Prestwood
219. Go with at least Windows Server 2003

I have several Windows 2000 Servers, should I upgrad them? I have to setup a new server, should I install another Windows 2000 Server or dive into Windows 2003? What about Windows Server 2008?

Posted to KB Topic: Windows Server 2003
10 years ago

FAQ
Nothing New Since Your Last Visit
7430
Hits

Computer Tech

Mike Prestwood
220. MS DHCP Preferred Over SOHO Devices

It is better to install a Microsoft DHCP server in your business network over the more limited DHCP servers provided by SOHO devices such as those found in wireless routers, firewalls, the Comcast router, etc. Installing a Microsoft DHCP server allows you to take advantage of more advanced features.

Posted to KB Topic: DHCP
10 years ago

Tip
Nothing New Since Your Last Visit
9858
Hits

Computer Tech

Mike Prestwood
221. Cat 5e and Gigabit Networks

Can I run a Gigabit network over Category 5 or Category 5e?

Posted to KB Topic: Wired Networking
10 years ago
(5 Comments , last by Douglas.G )

FAQ
Nothing New Since Your Last Visit
9510
Hits

Computer Tech

Mike Prestwood
222. Find Driver Tip

If you know the correct driver is installed on your computer some place but don't remember where or know it's part of Windows, use the browse  for local driver option and specifiy a path of C:\ and check the include subfolders checkbox.

For example, in Vista, if there are no bluetooth devices on you computer when Vista is installed, the bluetooth stack isn't loaded. To load it, simply put your USB bluetooth dongle in an available USB port and use the tip above to load the Vista bluetooth driver.

Posted to KB Topic: Windows Users
10 years ago

Tip
Nothing New Since Your Last Visit
10146
Hits

Windows Users

Mike Prestwood
223. Proof of Concept (POC)

Guidelines for create proof of concepts (POCs).

Posted to KB Topic: PSDP Development
10 years ago

KB Post
Nothing New Since Your Last Visit
6033
Hits

PM, Process, and PSDP

Mike Prestwood
224. Logos Should Use 1 Symbol Max

Each logo you create should have at most one symbol. You can mess with the text is "textual" ways such as font, color, and minor tweaks, but if you include a "symbol", you should include only one symbol.

Posted to KB Topic: Logos
10 years ago
(8 Comments , last by Maurice.W )

Tip
Nothing New Since Your Last Visit
9679
Hits

Website Design & Hosting

Mike Prestwood
225. Increase Colors Before You Shrink

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

Posted to KB Topic: Graphics
10 years ago
(1 Comments , last by Seth.A )

FAQ
Nothing New Since Your Last Visit
8211
Hits

Website Design & Hosting

Mike Prestwood
226. Prestwood 7525 Office Online Tour

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

Posted to KB Topic: Historical Archive
10 years ago, and updated 10 years ago
(10 Comments , last by lumamodid.b )

KB Post
Nothing New Since Your Last Visit
7980
Hits

Prestwood IT Solutions

Mike Prestwood
227. Resize Transparent Image, Increase Colors First

Before you resize a transparent GIF or PNG larger or smaller, make sure you first increase the number of colors to the maximum number of colors allowed. In essence, unleash the full power of your graphics program. After you resize your image, you will have to reapply transparency.

Posted to KB Topic: Graphics
10 years ago
(5 Comments , last by framaroot.d )

Tip
Nothing New Since Your Last Visit
8719
Hits

Website Design & Hosting

Mike Prestwood
228. Paradox 9/10/11 Versions (and WPO 2000)

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

Posted to KB Topic: Installation, Setup, & BDE
10 years ago, and updated 9 years ago
(4 Comments , last by mistol_dos )

KB Post
Nothing New Since Your Last Visit
20404
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
229. AxDistEx.exe Trojan Virus - Not

Some virus programs are reporting a virus in the 1998 file axdistex.exe:

File: \ Distrib\setup\axdistex.exe
Malware: Win32:CIH-C
Type: Virus/Worm
Posted to KB Topic: Paradox & ObjectPAL
10 years ago
(3 Comments , last by Laverne.V )

Error
Nothing New Since Your Last Visit
13508
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
230. Oracle Buys Sun: Java Under New Management

Oracle to purchase Sun Microsystems for $7.4 billion. The driving force behind this deal was Oracle's desire to acquire Java and Solaris.

Posted to KB Topic: General News & Trends
10 years ago

News
Nothing New Since Your Last Visit
9547
Hits

Computer Industry

Mike Prestwood
231. Could Not Initialize BDE

Procedure for fixing the Could Not Initialize BDE" error.

Posted to KB Topic: Installation, Setup, & BDE
10 years ago, and updated 9 years ago
(7 Comments , last by James.C5 )

KB Post
Nothing New Since Your Last Visit
26907
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
232. Reverse Offshoring - Sallie Mae to create 2000 U.S. jobs

Sallie Mae to create 2,000 jobs, return its overseas operations to U.S.

Posted to KB Topic: Off Shoring
10 years ago
(2 Comments , last by William.c )

News
Nothing New Since Your Last Visit
6493
Hits

American I.T. Workforce

Mike Prestwood
233. Knowledge Base Comments now numbered

Knowledge base comments are now numbered 1 of x, 2 of x, etc. and the first comment is marked as well as the latest comment.

Posted to KB Topic: Knowledge Base Help
10 years ago

News
Nothing New Since Your Last Visit
5927
Hits

PrestwoodBoards

Mike Prestwood
234. DLL Uses Block

I'm making a DLL Call and I need to pass a logical, I tried passing an ObjectPAL logical data type and that didn't work. How do I pass a logical to a function in a DLL?

Posted to KB Topic: OPAL: Win32 Calls
10 years ago

FAQ
Nothing New Since Your Last Visit  
7276
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
235. nmefwmi.exe

Error: nmefwmi.exe has stopped working

Solution: This error is caused by a defect in 11g limited to Windows Vista. The nmefwimi.exe is an Oracle 11g service used by dbconsole (OaracleDBConsoleorcl). You can stop this service to stop this error then set it's Startup Type to Manual to prevent it from returning. Doing so will not affect your database. When you need to use dbconsole, start the service manually.

Also, check with Oracle for an update that fixes this issue.

Posted to KB Topic: Oracle 11g
10 years ago, and updated 10 years ago
(1 Comments , last by jjeffman )

Error
Nothing New Since Your Last Visit
20003
Hits

DBA, Databases, & Data

Mike Prestwood
236. Delphi Prism Polymorphism

Prism supports the following types of polymorphism:

Posted to KB Topic: OOP
10 years ago, and updated 10 years ago
(1 Comments , last by mtiede )

Code
Nothing New Since Your Last Visit
9087
Hits

Delphi Prism

Mike Prestwood
237. Delphi Polymorphism

Delphi supports the following types of polymorphism:

Posted to KB Topic: OOP
10 years ago
(1 Comments , last by Uwais.Q )

Code
Nothing New Since Your Last Visit
12745
Hits

Pascal and Delphi Coding

Mike Prestwood
238. Delphi Prism Pointers

Although pointer data types in Prism coding are less important than in other languages such as C++, Prism does support developer defined pointers. Use the ^ operator to declare a pointer data type. Use the @ operator to return the current address of a variable.

In .Net managed coding the use of pointers is not safe because the garbage collector may move memory around. To safely use pointers, use the unsafe keyword. However, avoid unsafe code if possible.

Posted to KB Topic: Language Details
10 years ago

Code
Nothing New Since Your Last Visit
10765
Hits

Delphi Prism

Mike Prestwood
239. VB.Net Polymorphism

C# supports the following types of polymorphism:

Posted to KB Topic: OOP
10 years ago

Code
Nothing New Since Your Last Visit
9528
Hits

VB.Net Language

Mike Prestwood
240. Share Code with Delphi and Prism

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

Posted to KB Topic: Tool Basics
10 years ago
(2 Comments , last by mprestwood )

FAQ

KB Post
Nothing New Since Your Last Visit
12327
Hits

Delphi Prism

Mike Prestwood
241. a versus an

a
not any particular or certain one; a certain; another; one;

"He is a Delphi programmer."
 

an
the form of "a" before an initial vowel

"He is an ObjectPAL programmer."

Posted to KB Topic: Grammar
10 years ago

Tip
Nothing New Since Your Last Visit
8401
Hits

Technical Writing

Mike Prestwood
242. then versus than

then
adverb - at that time; adjective - being; noun - that time

"Create the database, then start the prototype."

than
in relation to; by comparison with

"Delphi 6 is a better product than Visual Basic 6."

Posted to KB Topic: Grammar
10 years ago

Tip
Nothing New Since Your Last Visit
7975
Hits

Technical Writing

Mike Prestwood
243. "a lot" and "allot"

a lot, not alot
to a very great degree or extent

"John is a lot better programmer than Dave."
 

allot
to divide or distribute by share or portion

"I am going to allot you half the analysis."

Posted to KB Topic: Spelling Pitfalls
10 years ago
(2 Comments , last by jack.m2 )

Tip
Nothing New Since Your Last Visit
8647
Hits

Technical Writing

Mike Prestwood
244. ASP Classic Member Visibility (Private, Public)

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 to KB Topic: OOP
10 years ago

Code

Article
Nothing New Since Your Last Visit
15740
Hits

ASP Classic Coding

Mike Prestwood
245. ASP Classic Member Modifiers (Default)

Other than visibility modifiers Public and Private, the only other member modifier available in ASP Classic is Default which is used only with the Public keyword in a class block. It indicates that the sub, function, or property is the default method for the class. You can have only one Default per class.

Posted to KB Topic: OOP
10 years ago

Code
Nothing New Since Your Last Visit
7299
Hits

ASP Classic Coding

Mike Prestwood
246. VB Classic Self Keyword (Me)

The Me keyword is a built-in variable that refers to the class where the code is executing. For example, you can pass Me from one module to another.

Posted to KB Topic: Language Details
10 years ago

Code
Nothing New Since Your Last Visit
7717
Hits

Visual Basic Classic

Mike Prestwood
247. ASP Classic Self Keyword (me)

Same as VB. The Me keyword is a built-in variable that refers to the class where the code is executing.

Posted to KB Topic: Language Details
10 years ago

Code
Nothing New Since Your Last Visit
10883
Hits

ASP Classic Coding

Mike Prestwood
248. Access VBA Self Keyword (Me)

Same as VB. The Me keyword is a built-in variable that refers to the class where the code is executing. For example, you can pass Me from one module to another.

Posted to KB Topic: Language Details
10 years ago

Code
Nothing New Since Your Last Visit
11118
Hits

Microsoft Access

Mike Prestwood
249. PHP Deployment Overview

With PHP, you simply copy your files to a web server that is capable of running PHP pages.

Posted to KB Topic: Beginners Corner
10 years ago

Code
Nothing New Since Your Last Visit
9220
Hits

PHP & Delphi for PHP

Mike Prestwood
250. Perl Deployment Overview

With Perl, you simply copy your files to a web server that is capable of running Perl pages.

Posted to KB Topic: Beginners Corner
10 years ago

Code
Nothing New Since Your Last Visit
7745
Hits

Perl

Mike Prestwood
251. ASP Classic Deployment Overview

With ASP Classic, you simply copy your files to a web server that is capable of running ASP pages. This includes your .ASP pages along with supporting files such as images, include files, and database files.

Optionally, you can also deploy a global.asa file which is used to code certain events like application start, application end, session start, and session end.

Posted to KB Topic: Tool Basics
10 years ago

Code
Nothing New Since Your Last Visit
6657
Hits

ASP Classic Coding

Mike Prestwood
252. Access VBA Deployment Overview

You can deploy your Microsoft Access application either with the full version of Access or with the Access Runtime (see Deploying Applications Using the Access Runtime).

Posted to KB Topic: Language Basics
10 years ago

Code
Nothing New Since Your Last Visit
8157
Hits

Microsoft Access

Mike Prestwood
253. VB.Net Overriding (Overridable, Overrides)

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 to KB Topic: OOP
10 years ago

Code

Article
Nothing New Since Your Last Visit
25365
Hits

VB.Net Language

Mike Prestwood
254. Method Overriding

Where you define or implement a virtual method in a parent class and then replace it in a descendant class.

When you decide to declare a method as virtual, you are giving permission to derived classes to extend and override the method with their own implementation. You can have the extended method call the parent method's code too.

In most OO languages you can also choose to hide a parent method. When you introduce a new implementation of the same named method with the same signature without overriding, you are hiding the parent method.

Posted to KB Topic: Object Orientation (OO)
10 years ago

Definition
Nothing New Since Your Last Visit  
13458
Hits

Coding & OO

Mike Prestwood
255. Delphi Prism Overriding (virtual, override)

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 to KB Topic: OOP
10 years ago

Code

Article
Nothing New Since Your Last Visit
13468
Hits

Delphi Prism

Mike Prestwood
256. Delphi Overriding (virtual, override)

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 to KB Topic: OOP
10 years ago, and updated 9 years ago
(2 Comments , last by Anonymous )

Code

Article
Nothing New Since Your Last Visit
22746
Hits

Pascal and Delphi Coding

Mike Prestwood
257. VB.Net Pointers (None)

VB.Net doesn't support pointers. The closest it comes is IntPtr which you use to get pointer handles on windows, files, etc.

C# does have better support for pointers and C++/CLI has extensive support. One solution when it's really needed in VB.Net is to code in C# or C++/CLI and add it to your project.

However, VB.Net does support references.

Posted to KB Topic: Language Details
10 years ago

Code
Nothing New Since Your Last Visit  
8607
Hits

VB.Net Language

Mike Prestwood
258. C# Pointers

Although pointer data types in C# coding are less important than in other languages such as C++, C# does support developer defined pointers. Use the * operator to declare a pointer data type. Use the & operator to return the current address of a variable.

In .Net managed coding the use of pointers is not safe because the garbage collector may move memory around. To safely use pointers, use the unsafe keyword.

C++/CLI has more extensive support for pointers than C#. If you have needs that go beyond what C# offers, you can code in C++/CLI and add it to your project.

Posted to KB Topic: Language Details
10 years ago

Code
Nothing New Since Your Last Visit
8282
Hits

C# (Visual C# & VS.Net)

Mike Prestwood
259. Delphi Pointers

Although pointer data types in Delphi coding are less important and not required for most general coding, Delphi fully supports developer defined pointers. Use a carrot (^) to declare a pointer data type. Use the @ operator or Addr function to return the current address of a variable.

Posted to KB Topic: Language Details
10 years ago

Code
Nothing New Since Your Last Visit
9410
Hits

Pascal and Delphi Coding

Mike Prestwood
260. C# Self Keyword (this)

To refer to the current instance of a class, use the this keyword. The this keyword provides a way to refer to the specific instance in which the code is currently executing. It is particularly useful for passing information about the currently executing instance.

The this keyword is also used as a modifier of the first parameter of an extension method.

You cannot use this with static method functions because static methods do not belong to an object instance. If you try, you'll get an error.

Posted to KB Topic: OOP
10 years ago
(4 Comments , last by Mike.B3 )

Code
Nothing New Since Your Last Visit
20995
Hits

C# (Visual C# & VS.Net)

Mike Prestwood
261. VB.Net Self Keyword (Me)

To refer to the current instance of a class or structure, use the Me keyword. Me provides a way to refer to the specific instance in which the code is currently executing. It is particularly useful for passing information about the currently executing instance.

The Me keyword is also used as a modifier of the first parameter of an extension method.

You cannot use Me with static method functions because static methods do not belong to an object instance. If you try, you'll get an error.

Posted to KB Topic: OOP
10 years ago

Code
Nothing New Since Your Last Visit  
9573
Hits

VB.Net Language

Mike Prestwood
262. Class Constructor

Constructors are called when you instantiate an object from a class. This is where you can initialize variables and put code you wish executed each time the class is created. When you initially set the member fields and properties of an object, you are initializing the state of the object. The state of an object is the values of all it's member fields and properties at a given time.

Posted to KB Topic: Object Orientation (OO)
10 years ago
(2 Comments , last by MichaelH..V )

Definition
Nothing New Since Your Last Visit
18278
Hits

Coding & OO

Mike Prestwood
263. Rich Editor: Spell checking

Spell checking is available in our rich editor for IE and Gecko based browsers such as Firefox and Safari. We use our rich editor in many areas of our community such as message boards, knowledge base, job postings, resumes, etc. For IE, there is an icon on the editor's toolbar. For Gecko based browsers such as Firefox and Safari, browser enabled spell checking is active. Spell checking is not available for Google Chrome. Currently Chrome's spell checking is not compatible with IFrames so you have spell checking OUTSIDE our editor.

Posted to KB Topic: PrestwoodBoards
11 years ago

Tip
Nothing New Since Your Last Visit
10488
Hits

PrestwoodBoards

Mike Prestwood
264. CSharp Language Specification (C#) http://msdn.microsoft.com/en-us/library/aa664628(VS.71).aspx
Posted to KB Topic: Language Basics
11 years ago

Link
Nothing New Since Your Last Visit
5568
Hits

C# (Visual C# & VS.Net)

Mike Prestwood
265. Not In SQL Select Query

The following selects all the records in Table1 where IDField is not in Table2.

Posted to KB Topic: ANSI SQL Scripting
10 years ago

Code
Nothing New Since Your Last Visit
9961
Hits

DBA, Databases, & Data

Mike Prestwood
266. Programming Literals

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

Posted to KB Topic: General Coding Concepts
10 years ago
(1 Comments , last by Suzy.W )

Definition
Nothing New Since Your Last Visit
14203
Hits

Coding & OO

Mike Prestwood
267. Quit, Quiet, Quite
  • Quit: to stop, cease, or discontinue
  • Quiet: making no noise
  • Quite: completely, wholly, or entirely
Posted to KB Topic: Spelling Pitfalls
10 years ago

Tip
Nothing New Since Your Last Visit
11908
Hits

Technical Writing

Mike Prestwood
268. Inline Routines

Instead of calling a routine, you move the code from the routine itself and expand it in place of the call. In addition to manual inlining, some languages support automatic inlining where the compiler or some other pre-compiler decides when to inline a code routine. Also, some languages allow for developer defined inlining where the developer can suggest and/or force the inlining of a code routine. Inlining can optimize your code for speed by saving a call and return, and parameter management.

Posted to KB Topic: General Coding Concepts
10 years ago

Definition
Nothing New Since Your Last Visit
11839
Hits

Coding & OO

Mike Prestwood
269. Round Floating Point Numbers

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

Posted to KB Topic: General Coding Concepts
10 years ago

Tip
Nothing New Since Your Last Visit
17991
Hits

Coding & OO

Mike Prestwood
270. Pointers / References

A pointer is a variable type that allows you to refer indirectly to another object. Instead of holding data, a pointer holds the address to data -- the address of another variable or object. You can change the address value a pointer points to thus changing the variable or object the pointer is pointing to.

A reference is a type of pointer that cannot change and it must always point to a valid storage (no nulls).

Posted to KB Topic: General Coding Concepts
10 years ago

Definition
Nothing New Since Your Last Visit
12028
Hits

Coding & OO

Mike Prestwood
271. Program or unit recursively uses itself

You cannot create a Delphi unit with the same name as is already in use. For example, do not create a buttons.pas unit for your application because the VCL already has a Buttons.pas unit. The solution is to rename your unit.

Posted to KB Topic: Delphi for Win32
10 years ago
(2 Comments , last by kaqo.x )

Error
Nothing New Since Your Last Visit
19625
Hits

Pascal and Delphi Coding

Mike Prestwood
272. A 10 Minute C# Winforms Quick Start

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 to KB Topic: WinForms
11 years ago

Article
Nothing New Since Your Last Visit
17652
Hits

C# (Visual C# & VS.Net)

Mike Prestwood
273. ObjectPAL Self Keyword (Self)

A built-in object variable that represents the UIObject to which the currently executing code is attached.

Posted to KB Topic: OPAL: Language Details
10 years ago

Code
Nothing New Since Your Last Visit  
7403
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
274. Delphi Prism Self Keyword (Self)

Within the implementation of a method, the identifier Self references the object in which the method is called. The Self variable is an implicit parameter for each object method.
A method can use this variable to refer to its owning class.

Posted to KB Topic: Language Details
10 years ago

Definition
Nothing New Since Your Last Visit
7538
Hits

Delphi Prism

Mike Prestwood
275. Delphi Self Keyword (Self)

Within the implementation of a method, the identifier Self references the object in which the method is called. The Self variable is an implicit parameter for each object method.
A method can use this variable to refer to its owning class.

Posted to KB Topic: Language Details
10 years ago

Code
Nothing New Since Your Last Visit
11326
Hits

Pascal and Delphi Coding

Mike Prestwood
276. Java Deployment Overview

Java applets and applications both require the Java Runtime Environment (JRE) and any additional dependencies you've added.

Posted to KB Topic: Tool Basics
10 years ago

Code
Nothing New Since Your Last Visit
7086
Hits

Java

Mike Prestwood
277. Oxidizer

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

Posted to KB Topic: Tool Basics
10 years ago

Download
Nothing New Since Your Last Visit
10915
Hits

Delphi Prism

Mike Prestwood
278. ShineOn

A Delphi Prism implementation of the Delphi for Win32 RTL.

Posted to KB Topic: Tool Basics
10 years ago

Download
Nothing New Since Your Last Visit
9396
Hits

Delphi Prism

Mike Prestwood
279. Code Contract

A.k.a. Class Contract and Design by Contracts.

A contract with a method that must be true upon calling (pre) or exiting (post). A pre-condition contract must be true when the method is called. A post-condition contract must be true when exiting. If either are not true, an error is raised. For example, you can use code contracts to check for the validity of input parameters, and results

An invariant is also a code contract which validates the state of the object required by the method.

Posted to KB Topic: Object Orientation (OO)
10 years ago, and updated 10 years ago

Definition
Nothing New Since Your Last Visit
7782
Hits

Coding & OO

Mike Prestwood
280. Delphi Prism Class Contracts (require, ensure)

Prism supports class contracts with its require and ensure keywords. The require keyword is a pre condition that must be true when the method is called. The ensure keyword is a post condition that much be true when a method exits. With either, if the condition evaluates to false, then an assertion is generated.

They can be used to check for the validity of input parameters, results, or for the state of the object required by the method.

The require and ensure keywords will expand the method body to list the preconditions; both sections can contain a list of Boolean statements, separated by semicolons.

Posted to KB Topic: OOP
10 years ago

Code
Nothing New Since Your Last Visit
7506
Hits

Delphi Prism

Mike Prestwood
281. VB.Net Member Modifiers

The method modifiers include MustOverride, NotOverridable, Overridable, Overrides. Specify VB.Net member modifiers as follows:

Public Overrides Function SomeFunction() As Double

The field modifiers include ReadOnly and Shared. Specify field modifiers as follows:

Public ReadOnly SomeField As String

Posted to KB Topic: OOP
10 years ago

Code
Nothing New Since Your Last Visit
8129
Hits

VB.Net Language

Mike Prestwood
282. C# Member Modifiers

The method modifiers are abstract, extern, new, partial, sealed, virtual, and override. Specify C# member modifiers as follows:

abstract SomeMethod() {..}

The field modifiers are const, readonly, static, volatile. Specify field modifiers as follows:

readonly int MyAge;

Posted to KB Topic: OOP
10 years ago

Code
Nothing New Since Your Last Visit
7389
Hits

C# (Visual C# & VS.Net)

Mike Prestwood
283. Delphi Prism Left of String (Substring)

Delphi Prism Left of String

Posted to KB Topic: Language Details
10 years ago

Code
Nothing New Since Your Last Visit
8286
Hits

Delphi Prism

Mike Prestwood
284. C++/CLI String Concatenation (+)

C++/CLI performs implicit casting of numbers to strings. 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 to KB Topic: C++/CLI Language Basics
10 years ago

Code
Nothing New Since Your Last Visit  
9804
Hits

C++

Mike Prestwood
285. Delphi Prism String Concatenation (+)

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 to KB Topic: Language Basics
10 years ago, and updated 10 years ago
(3 Comments , last by mtiede )

Code

KB Post
Nothing New Since Your Last Visit
13664
Hits

Delphi Prism

Mike Prestwood
286. C++/CLI Logical Operators

Same as C++ and Java. C# logical operators:

& and, as in this and that No Short Circuit
&& and, as in this and that short circuits
| or, as in this or that No Short Circuit
|| or, as in this or that short circuits
! Not, as in Not This
^ either or, as in this or that but not both

Posted to KB Topic: C++/CLI Language Basics
10 years ago

Code
Nothing New Since Your Last Visit
8736
Hits

C++

Mike Prestwood
287. C# Logical Operators

Same as C++ and Java. C# logical operators:

& and, as in this and that No Short Circuit
&& and, as in this and that short circuits
| or, as in this or that No Short Circuit
|| or, as in this or that short circuits
! Not, as in Not This
^ either or, as in this or that but not both

Posted to KB Topic: Language Basics
10 years ago

Code
Nothing New Since Your Last Visit
9109
Hits

C# (Visual C# & VS.Net)

Mike Prestwood
288. Delphi Prism Logical Operators

Prism logical operators:

and and, as in this and that
or or, as in this or that
not Not, as in Not This
xor either or, as in this or that but not both

Posted to KB Topic: Language Basics
10 years ago

Code
Nothing New Since Your Last Visit  
8092
Hits

Delphi Prism

Mike Prestwood
289. ObjectPAL Parameters (var, const)

By Reference or Value (and by constant)
The default for parameters is by value. For by reference, add var in front of the parameter. ObjectPAL also offers constant parameters where you add const in front of the parameter. A constant parameter is like a read-only parameter the compiler can optimize. You cannot assign a value to a constant parameter.

Posted to KB Topic: OPAL: Language Details
11 years ago

Code
Nothing New Since Your Last Visit  
8872
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
290. Delphi Prism Exception Trapping (try..except, try..finally)

Use a try..except..end block to trap and process errors.

Posted to KB Topic: Language Details
10 years ago

Code
Nothing New Since Your Last Visit
10900
Hits

Delphi Prism

Mike Prestwood
291. The Delphi Prism Primer http://prismwiki.codegear.com/en/The_Prism_Primer
Posted to KB Topic: Language Details
10 years ago

Link
Nothing New Since Your Last Visit
5385
Hits

Delphi Prism

Mike Prestwood
292. C++/CLI If Statement (if..else if..else)

Same as standard C.

Posted to KB Topic: C++/CLI Language Basics
10 years ago
(2 Comments , last by joswin.m )

Code
Nothing New Since Your Last Visit
8651
Hits

C++

Mike Prestwood
293. C++/CLI Finalizer (~ClassName)

Unlike standard C++, C++/CLI 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 to KB Topic: C++/CLI OOP
10 years ago

Code
Nothing New Since Your Last Visit
9297
Hits

C++

Mike Prestwood
294. C++ Pointers

C++ uses both pointers and references. Use the * operator to declare a pointer and use the & operator to declare a reference.

Posted to KB Topic: C++ Language Details
10 years ago

Code
Nothing New Since Your Last Visit
7139
Hits

C++

Mike Prestwood
295. C++/CLI Deployment Overview

C++/CLI projects require the .Net framework and any additional dependencies you've added such as Crystal Reports.

In Visual Studio.Net, you can create a Setup and Deployment project by using any of the templates available on the New Project dialog (Other Project Types).

To create a ClickOnce deploy package, search the internet for mage.exe and mageui.exe.

In addition, you can use any of the many free and commercially available installation packages.

Posted to KB Topic: C++/CLI Language Basics
10 years ago

Code
Nothing New Since Your Last Visit
6346
Hits

C++

Mike Prestwood
296. ObjectPAL Pointers

ObjectPAL doesn't use pointers except for use with DLLs where you use a special CPTR uses keyword to refer to a DLL string pointer data type.

Posted to KB Topic: OPAL: Libraries
10 years ago

Code
Nothing New Since Your Last Visit  
7632
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
297. VB.Net Deployment Overview

VB.Net projects require the .Net framework and any additional dependencies you've added such as Crystal Reports.

In Visual Studio.Net, you can create a Setup and Deployment project by using any of the templates available on the New Project dialog (Other Project Types).

In addition, VB.Net projects also support ClickOnce which brings the ease of Web deployment to Windows Forms and console applications. To get started, right click on your solution in the Solution Explorer, click Properties then select the Security tab. 

In addition, you can use any of the many free and commercially available installation packages.

Posted to KB Topic: Tool Basics
10 years ago
(1 Comments , last by Anonymous )

Code
Nothing New Since Your Last Visit  
8590
Hits

VB.Net Language

Mike Prestwood
298. VB Classic Deployment Overview

VB applications require the VB runtime DLL (for version 6, it's VB600.DLL) plus any additional dependencies you've added such as Crystal Reports, ActiveX controls, and DLLs.

You can use any of the many free and commercially available installation packages.

Posted to KB Topic: Tool Basics
10 years ago

Code
Nothing New Since Your Last Visit
6527
Hits

Visual Basic Classic

Mike Prestwood
299. ObjectPAL Deployment Overview

To deploy a Paradox application, you need to deploy either the full version of Paradox or the Paradox Runtime both of which will include the BDE as well as any dependecies you've added such as psSendMail DLL, ezDialogs, etc.

Posted to KB Topic: Runtime, PDE, Package-It!
10 years ago

Code
Nothing New Since Your Last Visit
6363
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
300. Delphi Deployment Overview

Delphi create native code Windows applications so you can create an EXE with no dependencies that will run on any Windows computer. If you add dependencies (reports, database libraries, DLLs, etc.) use a Windows installer to build an installation program.

D2007 and D2009 are bundled with InstallAware Express CodeGear Edition installer.

Posted to KB Topic: Tool Basics
10 years ago

Code
Nothing New Since Your Last Visit  
9510
Hits

Pascal and Delphi Coding

Mike Prestwood
301. C++ Deployment Overview

You can use any of the many free and commercially available installation packages.

In Visual Studio.Net, you can create a Setup and Deployment project by using any of the templates available on the New Project dialog (Other Project Types).

C++Builder 2007 and 2009 are bundled with InstallAware Express CodeGear Edition installer.

Posted to KB Topic: C++ Language Basics
10 years ago

Code
Nothing New Since Your Last Visit
5862
Hits

C++

Mike Prestwood
302. C# Deployment Overview

C# projects require the .Net framework and any additional dependencies you've added such as Crystal Reports.

In Visual Studio.Net, you can create a Setup and Deployment project by using any of the templates available on the New Project dialog (Other Project Types).

In addition, C# projects also support ClickOnce which brings the ease of Web deployment to Windows Forms and console applications. To get started, right click on your solution in the Solution Explorer, click Properties then select the Security tab. 

In addition, you can use any of the many free and commercially available installation packages.

Posted to KB Topic: Tool Basics
10 years ago

Code
Nothing New Since Your Last Visit
7112
Hits

C# (Visual C# & VS.Net)

Mike Prestwood
303. Delphi Prism Deployment Overview

Prism projects require the .Net framework and any additional dependencies you've added such as Crystal Reports.

In Visual Studio.Net, you can create a Setup and Deployment project by using any of the templates available on the New Project dialog (Other Project Types).

Prism doesn't directly support ClickOnce. At least not yet. In other words, there isn't a Security tab on the solution properties dialog. To create a ClickOnce deploy package, search the internet for mage.exe and mageui.exe.

In addition, you can use any of the many free and commercially available installation packages.

Posted to KB Topic: Tool Basics
10 years ago

Code
Nothing New Since Your Last Visit
7328
Hits

Delphi Prism

Mike Prestwood
304. Delphi Prism Overloading (implicit)

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

Posted to KB Topic: Language Details
10 years ago

Code

KB Post
Nothing New Since Your Last Visit
14109
Hits

Delphi Prism

Mike Prestwood
305. JavaScript Report Tools Overview

No built-in report writer but because JavaScript most frequently targets website development (a document interfaced GUI), a common solution is to simply output an HTML formatted page with black text and a white background (not much control but it does work for some situations).

Posted to KB Topic: Beginners Corner
10 years ago

Code
Nothing New Since Your Last Visit
14054
Hits

JavaScript and AJAX

Mike Prestwood
306. Java Report Tools Overview

Both Eclipse 3.3 and JBuilder 2008 come bundled with Business Intelligence and Reporting Tools (BIRT). BIRT is an Eclipse-based open source reporting system with both a report designer based on Eclipse, and a runtime component that you can add to your app server plus a charting engine that lets you add charts.

Posted to KB Topic: Tool Basics
10 years ago

Code
Nothing New Since Your Last Visit
8741
Hits

Java

Mike Prestwood
307. ObjectPAL Logical Operators

ObjectPAL logical operators:

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

Posted to KB Topic: OPAL: Language Basics
10 years ago, and updated 10 years ago
(1 Comments , last by Anonymous )

Code

Article
Nothing New Since Your Last Visit  
12882
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
308. Delphi Case Sensitivity (No)

Object Pascal is generally not case sensitive.

Posted to KB Topic: Language Basics
11 years ago, and updated 10 years ago
(6 Comments , last by neroqo.m )

Code

KB Post
Nothing New Since Your Last Visit  
19254
Hits

Pascal and Delphi Coding

Mike Prestwood
309. Delphi LeftStr

Delphi LeftStr

Posted to KB Topic: Language Details
11 years ago

Code
Nothing New Since Your Last Visit
10036
Hits

Pascal and Delphi Coding

Mike Prestwood
310. ObjectPAL Unary Operators

The ObjectPAL unary operators are:

+
-
Not

Posted to KB Topic: OPAL: Language Basics
10 years ago
(4 Comments , last by adv.y )

Code
Nothing New Since Your Last Visit
7771
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
311. Delphi Prism Unary Operators

The Prism unary operators are:

+
-
Not

Posted to KB Topic: Language Basics
10 years ago, and updated 10 years ago

Code

KB Post
Nothing New Since Your Last Visit
11861
Hits

Delphi Prism

Mike Prestwood
312. PHP Assignment (=)

PHP uses = for it's assignment operator.

Posted to KB Topic: Beginners Corner
10 years ago
(1 Comments , last by Karian.S )

Code
Nothing New Since Your Last Visit
7370
Hits

PHP & Delphi for PHP

Mike Prestwood
313. C++/CLI Assignment (=)

C++/CLI uses = for it's assignment operator.

Posted to KB Topic: C++/CLI Language Basics
10 years ago

Code
Nothing New Since Your Last Visit
6237
Hits

C++

Mike Prestwood
314. VB Classic Logical Operators (and, or, not)

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 to KB Topic: Language Basics
10 years ago, and updated 10 years ago
(5 Comments , last by Winchester14.R )

Code

Article
Nothing New Since Your Last Visit  
15520
Hits

Visual Basic Classic

Mike Prestwood
315. ASP Classic Logical Operators (and, or, not)

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 to KB Topic: Language Basics
10 years ago, and updated 10 years ago
(4 Comments , last by Chatlie.m )

Code

KB Post
Nothing New Since Your Last Visit  
23751
Hits

ASP Classic Coding

Mike Prestwood
316. Access VBA Logical Operators (and, or, not)

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 to KB Topic: Language Basics
10 years ago, and updated 10 years ago
(3 Comments , last by Uwais.Q )

Code

Article
Nothing New Since Your Last Visit  
25689
Hits

Microsoft Access

Mike Prestwood
317. VB.Net Logical Operators

VB.Net logical operators:

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

Posted to KB Topic: Language Basics
10 years ago
(1 Comments , last by Clarence.O )

Code
Nothing New Since Your Last Visit  
8956
Hits

VB.Net Language

Mike Prestwood
318. PHP Logical Operators (and, &&, or, ||, !, Xor)

PHP logical operators:

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

Posted to KB Topic: Beginners Corner
10 years ago

Code
Nothing New Since Your Last Visit
9724
Hits

PHP & Delphi for PHP

Mike Prestwood
319. Perl Logical Operators

Perl logical operators:

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

Posted to KB Topic: Beginners Corner
10 years ago

Code
Nothing New Since Your Last Visit
8457
Hits

Perl

Mike Prestwood
320. JavaScript Logical Operators

JavaScript logical operators:

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

Posted to KB Topic: Beginners Corner
10 years ago

Code
Nothing New Since Your Last Visit
7813
Hits

JavaScript and AJAX

Mike Prestwood
321. Java Logical Operators

Java logical operators:

&& and, as in this and that
|| or, as in this or that
! Not, as in Not This
& boolean logical OR (not short circuited)
| boolean logical OR (not short circuited)
?: Ternary (short for if-then-else)
~ Unary bitwise complement
<< Signed left shift
>> Signed right shift
>>> Unsigned right shift
^ Bitwise exclusiv OR

Posted to KB Topic: Language Basics
10 years ago
(2 Comments , last by Ashwin.k )

Code
Nothing New Since Your Last Visit
10417
Hits

Java

Mike Prestwood
322. Delphi Logical Operators

Delphi logical operators:

and and, as in this and that
or or, as in this or that
not Not, as in Not This
xor either or, as in this or that but not both

Posted to KB Topic: Language Basics
10 years ago
(1 Comments , last by james.l2 )

Code
Nothing New Since Your Last Visit  
14543
Hits

Pascal and Delphi Coding

Mike Prestwood
323. C++ Logical Operators

C++ logical operators:

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

Posted to KB Topic: C++ Language Basics
10 years ago

Code
Nothing New Since Your Last Visit
6673
Hits

C++

Mike Prestwood
324. Perl Assignment (=)

Perl assignment operators:

= Assignment $x = 8;
+= Addition $x += 8;
-= Substraction $x -= 8;
*= Muliplication $x *= 8;
/= Division $x /= 8;
%= Modulus $x %= 8;
**= Exponent $x **= 8;

Posted to KB Topic: Perl
10 years ago

Code
Nothing New Since Your Last Visit
7742
Hits

Perl

Mike Prestwood
325. PHP Comparison Operators (==, != or <>)

Common comparison operators:

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

PHP 4 and above also offers === for indentical (equal plus same type) and !== for not identical (not equal or not same type).

Posted to KB Topic: Beginners Corner
10 years ago

Code
Nothing New Since Your Last Visit
10208
Hits

PHP & Delphi for PHP

Mike Prestwood
326. PHP If Statement (if..elseif..else)

The PHP if statement consists of using if, elseif, and else.

Posted to KB Topic: Beginners Corner
10 years ago

Code
Nothing New Since Your Last Visit
7378
Hits

PHP & Delphi for PHP

Mike Prestwood
327. Perl If Statement (if..elsif..else)

Notice Perl is different from most other languages in it's spelling of elsif (else is not spelled correctly).

Posted to KB Topic: Beginners Corner
10 years ago

Code
Nothing New Since Your Last Visit
7073
Hits

Perl

Mike Prestwood
328. JavaScript If Statement (if..else if..else)

Same as C/C++ but, as usual, the semicolons are optional.

Posted to KB Topic: Beginners Corner
10 years ago
(1 Comments , last by Anonymous )

Code
Nothing New Since Your Last Visit
6936
Hits

JavaScript and AJAX

Mike Prestwood
329. C++ If Statement (if..else if..else)

Same as standard C.

Posted to KB Topic: C++ Language Basics
10 years ago
(7 Comments , last by sarah.r )

Code
Nothing New Since Your Last Visit
10315
Hits

C++

Mike Prestwood
330. Perl Comparison Operators (==, !=)

Common comparison operators:

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

Posted to KB Topic: Beginners Corner
10 years ago
(3 Comments , last by EliteExpress )

Code
Nothing New Since Your Last Visit
11198
Hits

Perl

Mike Prestwood
331. ObjectPAL Comparison Operators (=, <>)

Common comparison operators:

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

Posted to KB Topic: OPAL: Language Basics
10 years ago
(2 Comments , last by Kellie.H )

Code

KB Post
Nothing New Since Your Last Visit
16076
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
332. JavaScript Comparison Operators (==, !=)

Common comparison operators:

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

Posted to KB Topic: Beginners Corner
10 years ago

Code
Nothing New Since Your Last Visit
8816
Hits

JavaScript and AJAX

Mike Prestwood
333. Delphi Prism Prevent Derivation (sealed, final)

Same keywords as Delphi (sealed uses slightly different syntax). With Prism, use the sealed keyword before the class keyword to prevent a class from being inherited from and use the final keyword to prevent a method from being overridden.

Posted to KB Topic: OOP
10 years ago

Code
Nothing New Since Your Last Visit  
7871
Hits

Delphi Prism

Mike Prestwood
334. Class Helper

A. In Dephi, class helpers allow you to extend a class without using inheritance. With a class helper, you do not have to create and use a new class descending from a class but instead you enhance the class directly and continue using it as you always have (even just with the DCU).

B. In general terms, developers sometimes use the term to refer to any class that helps out another class.

Posted to KB Topic: Object Orientation (OO)
10 years ago, and updated 10 years ago

Definition
Nothing New Since Your Last Visit
9200
Hits

Coding & OO

Mike Prestwood
335. Delphi Class Helpers (class helper for)

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 to KB Topic: OOP
10 years ago, and updated 9 years ago

Code

Article
Nothing New Since Your Last Visit  
25594
Hits

Pascal and Delphi Coding

Mike Prestwood
336. Java Inlining (Automatic)

The Java compiler automatically inlines when it determines  a benefit. The use of final methods is considered a compiler hint to tell the compiler to inline the method if beneficial.

Posted to KB Topic: Language Details
10 years ago

Code
Nothing New Since Your Last Visit
10402
Hits

Java

Mike Prestwood
337. C++ Inlining (inline)

Use the inline keyword to tell the compiler to inline a routine.

Posted to KB Topic: C++ Language Details
10 years ago
(1 Comments , last by alvitar )

Code
Nothing New Since Your Last Visit
9781
Hits

C++

Mike Prestwood
338. VB.Net Inlining (Automatic)

In VB.Net, inlining is automatically done for you by the JIT compiler for all languages and in general leads to faster code for all programmers whether they are aware of inlining or not.

Posted to KB Topic: Language Details
10 years ago

Code
Nothing New Since Your Last Visit  
7194
Hits

VB.Net Language

Mike Prestwood
339. Delphi Prism Inlining (Automatic)

In Prism, inlining is automatically done for you by the JIT compiler for all languages and in general leads to faster code for all programmers whether they are aware of inlining or not.

Posted to KB Topic: Language Details
10 years ago

Code
Nothing New Since Your Last Visit  
7968
Hits

Delphi Prism

Mike Prestwood
340. Delphi Inlining (Inline)

Delphi introduced developer defined function and procedure inlining with Delphi 2005. Use the inline keyword to tell the compiler to inline a routine. Since Delphi will always inline the routine, make sure you test for speed because inlining a routine can lead to slower code under some circumstances.

Posted to KB Topic: Language Details
10 years ago
(3 Comments , last by Lucinda.H )

Code
Nothing New Since Your Last Visit  
15633
Hits

Pascal and Delphi Coding

Mike Prestwood
341. C++/CLI Inlining (Automatic)

In C++/CLI, inlining is automatically done for you by the JIT compiler for all languages and in general leads to faster code for all programmers whether they are aware of inlining or not.

Posted to KB Topic: C++/CLI Language Basics
10 years ago

Code
Nothing New Since Your Last Visit
6383
Hits

C++

Mike Prestwood
342. C# Inlining (Automatic)

In C#, inlining is automatically done for you by the JIT compiler for all languages and in general leads to faster code for all programmers whether they are aware of inlining or not.

Posted to KB Topic: Language Details
10 years ago
(7 Comments , last by Megha.M )

Code
Nothing New Since Your Last Visit
8135
Hits

C# (Visual C# & VS.Net)

Mike Prestwood
343. VB.Net Partial Classes (Partial)

VB.Net supports both partial classes and partial methods.

Posted to KB Topic: OOP
10 years ago

Code

Article
Nothing New Since Your Last Visit
14190
Hits

VB.Net Language

Mike Prestwood
344. Insert GUID Into Source Code

To insert a GUID into code using the Delphi Editor, use Control + Shift + G.

['{BB45987C-0552-415F-A439-636A87E9F4E2}']

 

However, if you are using either the Visual Studio or Visual Basic key mapping emulation, use Control + Alt + G.

Posted to KB Topic: Tool Basics
10 years ago

Tip
Nothing New Since Your Last Visit
9144
Hits

Pascal and Delphi Coding

Mike Prestwood
345. Delphi Prism Assignment (:=)

Same as Delphi.

Posted to KB Topic: Delphi Prism
10 years ago

Code
Nothing New Since Your Last Visit
6773
Hits

Delphi Prism

Mike Prestwood
346. C++/CLI Report Tools Overview

Use any report writer you are comfortable with but Crystal Reports remains popular for Visual C++ and C++/CLI.

Posted to KB Topic: C++/CLI WinForms
10 years ago

Code
Nothing New Since Your Last Visit
5842
Hits

C++

Mike Prestwood
347. C++ Report Tools Overview

Use any report writer you are comfortable with. C++Builder 2009 comes bundled with Rave Reports and Crystal Reports remains popular for Visual C++.

Posted to KB Topic: Standard C++
10 years ago
(1 Comments , last by Alee.A )

Code
Nothing New Since Your Last Visit
7322
Hits

C++

Mike Prestwood
348. New Version of Cross Reference Encyclopdedia

I deployed yet another new version of my Cross Reference Computer Language Encyclopedia. This new version of the software that drives the cross reference data includes fixing defects and some minor enhancements.

Check it out...

The Cross Reference Encyclopedia is also available from the pulldown menu (Programmer Community | Cross Reference Encyclopedia). Enhancements and fixes included:

  • CrossRef stats replaced the ambiguous "Version 1.1a" on the main CrossRef page:
  • Numerous browsing defects fixed. Previously, clicking around led to some unexpected data showing and in some cases no data.
  • Removed "View All" option and replaced it with a shorter "Overview" page. The "View All" page was getting too long to be of much use so I transitioned to a browse feature. You can still print out each category so "grabbing" a printable version is still possible.
Posted to KB Topic: PrestwoodBoards
10 years ago

News
Nothing New Since Your Last Visit
5088
Hits

PrestwoodBoards

Mike Prestwood
349. Delphi Prism Finalizer (finalize())

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 to KB Topic: OOP
10 years ago, and updated 10 years ago

Code

Article
Nothing New Since Your Last Visit  
19254
Hits

Delphi Prism

Mike Prestwood
350. Class Destructor

A special class method called when an object instance of a class is destroyed. With some languages they are called when the object instance goes out of scope, with some languages you specifically have to call the destructor in code to destroy the object, and others use a garbage collector to dispose of object instances at specific times.

Desctructors are commonly used to free the object instance but with languages that have a garbage collector object instances are disposed of when appropriate. Either way, destructors or their equivalent are commonly used to free up resources allocated in the class constructor.

Posted to KB Topic: Object Orientation (OO)
10 years ago, and updated 10 years ago

Definition
Nothing New Since Your Last Visit
16141
Hits

Coding & OO

Mike Prestwood
351. Partial Methods versus Abstract Methods

What is the difference between a partial method and an abstract method?

Posted to KB Topic: Delphi Prism
10 years ago

FAQ
Nothing New Since Your Last Visit
8016
Hits

Delphi Prism

Mike Prestwood
352. C# Member Field

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 to KB Topic: OOP
10 years ago, and updated 10 years ago

Code
Nothing New Since Your Last Visit  
8154
Hits

C# (Visual C# & VS.Net)

Mike Prestwood
353. Member Method

Also known as a Class Method.

A code routine that belongs to the class or an object instance (an instance of the class). Methods that belong to the class are called class methods or static methods. Methods that belong to an object instance are called instance methods, or simply methods.

When a method returns a value, it is a function method. When no value is returned (or void), it is a procedure method.

Methods frequently use method parameters to transfer data. When one object instance calls another object instance using a method with parameters, you call that messaging.

Posted to KB Topic: Object Orientation (OO)
10 years ago, and updated 10 years ago
(1 Comments , last by Andrew.S2 )

Definition
Nothing New Since Your Last Visit
8836
Hits

Coding & OO

Mike Prestwood
354. Access VBA Interfaces

Same as in VB6. Access VBA has limited support for interfaces. You can create an interface of abstract methods and properties and then implement them in one or more descendant classes. It's a single level implementation though (you cannot inherit beyond that). The parent interface class is a pure abstract class (all methods and properites are abstract, you cannot implement any of them in the parent class).

In the single level descendant class, you have to implement all methods and properties and you cannot add any. Your first line of code is Implements InterfaceName.

Posted to KB Topic: OOP
10 years ago

Code
Nothing New Since Your Last Visit
10875
Hits

Microsoft Access

Mike Prestwood
355. Delphi Prism Constructors (constructor + class name)

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

Posted to KB Topic: OOP
10 years ago, and updated 10 years ago

Code

Article
Nothing New Since Your Last Visit  
15206
Hits

Delphi Prism

Mike Prestwood
356. VB.Net Finalizer (Finalize())

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 to KB Topic: OOP
10 years ago, and updated 10 years ago
(1 Comments , last by CarlaB.T )

Code

Article
Nothing New Since Your Last Visit  
18705
Hits

VB.Net Language

Mike Prestwood
357. C# Finalizer (~ClassName)

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 to KB Topic: OOP
10 years ago

Code

Article
Nothing New Since Your Last Visit  
14901
Hits

C# (Visual C# & VS.Net)

Mike Prestwood
358. Access VBA Destructor

When an object instance is destroyed, Access VBA 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, Access VBA calls a special sub called Class_Initialize.

Posted to KB Topic: OOP
10 years ago
(1 Comments , last by Andrea.D )

Code
Nothing New Since Your Last Visit  
12031
Hits

Microsoft Access

Mike Prestwood
359. VB Classic Destructor

When an object instance is destroyed, VB6 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, VB6 calls a special sub called Class_Initialize.

Posted to KB Topic: OOP
10 years ago

Code
Nothing New Since Your Last Visit  
9249
Hits

Visual Basic Classic

Mike Prestwood
360. ASP Classic Destructor (Class_Terminate)

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 to KB Topic: OOP
10 years ago, and updated 10 years ago
(1 Comments , last by Anonymous )

Code

KB Post
Nothing New Since Your Last Visit  
19376
Hits

ASP Classic Coding

Mike Prestwood
361. VB Classic Constructors (Class_Initialize)

When an object instance is created from a class, VB6 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, VB6 calls a special sub called Class_Terminate.

Posted to KB Topic: OOP
10 years ago

Code
Nothing New Since Your Last Visit  
10951
Hits

Visual Basic Classic

Mike Prestwood
362. Access VBA Constructors (Class_Initialize)

When an object instance is created from a class, Access VBA 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, Access VBA calls a special sub called Class_Terminate.

Posted to KB Topic: OOP
10 years ago
(1 Comments , last by verma.r )

Code
Nothing New Since Your Last Visit  
21066
Hits

Microsoft Access

Mike Prestwood
363. VB Classic Member Visibility

In VB Classic, the keywords Private, Friend, Public, and Static are used to set access levels for declared elements.

Posted to KB Topic: OOP
10 years ago

Code
Nothing New Since Your Last Visit
7480
Hits

Visual Basic Classic

Mike Prestwood
364. Java Member Field

In Java, you can set the scope of a field member to public, protected, or private. Additional modifiers are static, abstract, final (assign only once), strictfp (strict floating point values) transient (do not save to persistent storage), and volatile (all threads see same value).

Posted to KB Topic: OOP
10 years ago

Code
Nothing New Since Your Last Visit
8190
Hits

Java

Mike Prestwood
365. Delphi Prism Comparison Operators (=, <>)

Same as Delphi.

Posted to KB Topic: Language Basics
10 years ago

Code
Nothing New Since Your Last Visit
7895
Hits

Delphi Prism

Mike Prestwood
366. ASP Classic Constructors (Class_Initialize)

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 to KB Topic: OOP
10 years ago, and updated 10 years ago
(1 Comments , last by Anonymous )

Code

KB Post
Nothing New Since Your Last Visit  
30633
Hits

ASP Classic Coding

Mike Prestwood
367. C# Constructors (Use class name)

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 to KB Topic: OOP
10 years ago, and updated 10 years ago

Code

Article
Nothing New Since Your Last Visit  
16027
Hits

C# (Visual C# & VS.Net)

Mike Prestwood
368. VB.Net Constructors (New)

 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 to KB Topic: OOP
10 years ago

Code

KB Post
Nothing New Since Your Last Visit  
15292
Hits

VB.Net Language

Mike Prestwood
369. Java If Statement (if..else if..else)

Syntax template:

if (expression) {
  expression1_true_code;
} else if (expression2) {
expression2_true_code;
} else {
  otherwise_code;
}
Posted to KB Topic: Language Basics
10 years ago

Code
Nothing New Since Your Last Visit
5863
Hits

Java

Mike Prestwood
370. Java Comparison Operators (==, !=)

The Java comparison operators are:

  • < less than
  • <= less than or equal to
  • == equal to
  • >= greater than or equal to
  • > greater than
  • != not equal
Posted to KB Topic: Java
10 years ago

Code
Nothing New Since Your Last Visit
9154
Hits

Java

Mike Prestwood
371. C++/CLI Comparison Operators (==, !=)

Same as standard C++.

Posted to KB Topic: C++/CLI Language Basics
10 years ago

Code
Nothing New Since Your Last Visit
7059
Hits

C++

Mike Prestwood
372. C++ Comparison Operators (==, !=)

General Info: Round Floating Point Numbers

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

Languages Focus: Comparison Operators

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

C++ Comparison Operators

Common comparison operators:

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

Posted to KB Topic: C++ Language Basics
10 years ago

Code
Nothing New Since Your Last Visit
7419
Hits

C++

Mike Prestwood
373. VB.Net Comparison Operators (=, <>)

Same as VB Classic.

Posted to KB Topic: Language Basics
10 years ago
(2 Comments , last by Marvin.C )

Code
Nothing New Since Your Last Visit  
11159
Hits

VB.Net Language

Mike Prestwood
374. Delphi Comparison Operators (=, <>)

Common comparison operators:

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

Posted to KB Topic: Language Details
10 years ago, and updated 10 years ago

Code

KB Post
Nothing New Since Your Last Visit
10984
Hits

Pascal and Delphi Coding

Mike Prestwood
375. C# Partial Classes (partial)

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 to KB Topic: OOP
10 years ago, and updated 10 years ago
(1 Comments , last by Assignment.H )

Code

Article
Nothing New Since Your Last Visit  
26425
Hits

C# (Visual C# & VS.Net)

Mike Prestwood
376. C# Constants (const)

In C#, you define constants with the const keyword.

All constants are part of a class (no global constants) but you can make a constant public and have access to it so long as you have added the class to the project (even without creating the class as if they were static, but you cannot use the static keyword).

Constants must be of an integral type (sbyte, byte, short, ushort, int, uint, long, ulong, char, float, double, decimal, bool, or string), an enumeration, or a reference to null.

Posted to KB Topic: Tool Basics
10 years ago, and updated 10 years ago

Code
Nothing New Since Your Last Visit  
10205
Hits

C# (Visual C# & VS.Net)

Mike Prestwood
377. C++/CLI Constants (const or literal)

C++/CLI supports the const and static const keywords of standard C++ as well as the new literal keyword. A literal is equivalent to static const in standard C++ and Microsoft's documentation recommends to replace static const with the new literal keyword because a leteral is available in metadata; a static const variable is not available in metadata to other compilers.

You can use static const within the class declaration or locally within a method. However, literal is only valid in the class declaration section and const is only valid within a method.

Posted to KB Topic: C++/CLI Language Basics
10 years ago, and updated 10 years ago
(1 Comments , last by Uwais.Q )

Code
Nothing New Since Your Last Visit  
17267
Hits

C++

Mike Prestwood
378. C++ Constants (const)

In standard C++, you use const and static const to declare constants.

Posted to KB Topic: C++ Language Basics
10 years ago, and updated 10 years ago

Code
Nothing New Since Your Last Visit
6456
Hits

C++

Mike Prestwood
379. Upload a File to Prestwood / Download Files

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 to KB Topic: Working Remotely with PS
10 years ago

KB Post
Nothing New Since Your Last Visit
7352
Hits

Client Extranet

Mike Prestwood
380. Delphi Prism Partial Classes (partial)

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 to KB Topic: OOP
10 years ago, and updated 10 years ago

Code

Article
Nothing New Since Your Last Visit
12432
Hits

Delphi Prism

Mike Prestwood
381. Partial Class

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.

Posted to KB Topic: Object Orientation (OO)
10 years ago, and updated 10 years ago

Definition
Nothing New Since Your Last Visit
12600
Hits

Coding & OO

Mike Prestwood
382. Microsoft SQL Server 2008 Express with Tools

MS SQL Express 2008 with Management Studio Basic. MS SQL 2008 database management tool only available bundled.

Posted to KB Topic: MS SQL 2008
10 years ago

Download
Nothing New Since Your Last Visit
10594
Hits

DBA, Databases, & Data

Mike Prestwood
383. Microsoft SQL Server 2005 Management Studio Express

Microsoft's free download tool for managing MS SQL 2005 databases.

Posted to KB Topic: MS SQL 2005
10 years ago, and updated 10 years ago

Download
Nothing New Since Your Last Visit
11758
Hits

DBA, Databases, & Data

Mike Prestwood
384. C++/CLI Literals (qoute)

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

Posted to KB Topic: C++/CLI Language Basics
10 years ago, and updated 10 years ago

Code
Nothing New Since Your Last Visit
8271
Hits

C++

Mike Prestwood
385. C++/CLI End of Statement (;)

Same as standard C++. C++ uses a semicolon ";" as an end of statement specifier and you can put multiple statements on a single line of code if you wish as well as split a single statement into two or more code lines.

Posted to KB Topic: C++/CLI Language Basics
10 years ago, and updated 10 years ago

Code
Nothing New Since Your Last Visit
5452
Hits

C++

Mike Prestwood
386. C++/CLI Comments (// or /* ... */)

Commenting Code
Same as standard C++. C++ uses "//" for a single line comment and /* */ for a multiple line comment.

Posted to KB Topic: C++/CLI Language Basics
10 years ago
(3 Comments , last by Erica.r )

Code
Nothing New Since Your Last Visit
5564
Hits

C++

Mike Prestwood
387. New 'New Posts' Page

We updated our New Posts page for all posts and for each group. From the pull-down menu, select Programmer Community | New @ PPC or the What's New option available within each group. The new New Posts page now mixes all types of posts together so you can easily see what's the newest message board post, KB article, comment, blog entry, etc.

  • New @ PPC (also available from the pull down menu, Programmer Community | New @ PPC)
Posted to KB Topic: PrestwoodBoards
10 years ago

News
Nothing New Since Your Last Visit
4836
Hits

PrestwoodBoards

Mike Prestwood
388. C++/CLI File Extensions (.CPP and .H)

The C++/CLI standard file extensions are the same as standard C++. Important C++ file extensions:

  • .CPP = C++ Source file. Your startup source file will have a main() routine.
  • .C = C source file (sometimes used for C++ source files too).
  • .H = Header include file.

Some important Visual C++ file extensions:

  • .SLN = Visual Studio.Net solution
  • .VCPRJ = The Visual C++ project file. See