Welcome to Foxite.COM Community Weblog Sign in | Join | Help

Data Management (RSS)

Sunday, November 16, 2008 12:50 PM

Designing A Database – Part 2

In the first article in this series I was careful to refer to data (and to differentiate it from ‘information’) only in the most generic sense. It is now important to consider exactly what we mean by data because before we can actually start defining
posted by andykr | 1 Comments
Filed Under:
Sunday, November 09, 2008 11:27 AM

Designing A Database - Part 1

When confronted with the task of designing a database most of us tend to start thinking in terms of tables and columns. This is, generally, a mistake! The reason is that before we can really start to design tables we need to understand the function of
posted by andykr | 0 Comments
Filed Under:
Saturday, October 11, 2008 12:12 PM

Key Design Considerations for a Client Server Application

Whilst it is impossible to be prescriptive about how to build and implement a Client/Server application in the absence of detailed requirements and specifications, there are issues that are common to all applications and which need to be handled differently
posted by andykr | 2 Comments
Filed Under:
Friday, October 03, 2008 1:29 PM

Introduction to Client Server Applications

Following my post about Client Server architecture, it seems logical to take a look at how we go about building an application using that architecture. So here goes… The Challenge Perhaps the biggest conceptual change that most VFP Developers have to
posted by andykr | 0 Comments
Filed Under:
Monday, September 29, 2008 3:08 PM

Introduction to Client Server Architecture

I am often surprised to find that many developers today still do not really understand what is meant by a "Client Server" architecture or what the difference between "tiers" and "layers" is. So I thought I would post the following explanation which, if
posted by andykr | 4 Comments
Filed Under:
Sunday, September 07, 2008 2:13 AM

What is Data Normalization?

Data normalization is a technique that is applied when designing relational database tables in order to minimize the duplication of information and, by so doing, safeguard the database against logical or structural anomalies that could compromise the
posted by andykr | 1 Comments
Filed Under:
Wednesday, September 03, 2008 1:36 PM

What is a Key?

The word "key" has a very specific meaning in relational database design. It refers to a field whose value is shared between tables. The purpose of such data duplication is to enable a record in one table to be associated with a record in another, thereby
posted by andykr | 10 Comments
Filed Under:
Saturday, June 10, 2006 1:19 PM

Opening Tables

One of the most frequently written snippets of code, in almost any application, looks something like this: *** Save Current work arealnSelect = SELECT()*** Select Required AreaIF ! USED( <Alias> )  USE <table_name> IN 0 AGAIN ALIAS <Alias>ENDIFSELECT
posted by andykr | 2 Comments
Filed Under:
Saturday, February 18, 2006 7:51 PM

Detecting and resolving update conflicts in VFP

In the last article in this series I will look at the problem of detecting and resolving what Visual FoxPro thinks are update conflicts. The idea behind this is that we want to ensure that when VFP reports an update conflict there really is one. The reason
posted by andykr | 1 Comments
Filed Under:
Tuesday, December 27, 2005 1:24 PM

Handling buffered data in Visual FoxPro

A couple of months ago I wrote about the basics of buffering, but I deliberately left out any discussion of the two most vital functions when working with buffering - namely TableUpdate() and TableRevert(). These are the basic means by which you, the
posted by andykr | 1 Comments
Filed Under:
Tuesday, October 18, 2005 7:11 PM

Buffering and Locking in Visual FoxPro - an Overview

Where do we start? It seems that working with data buffering in Visual FoxPro causes a lot of confusion. I believe that this is largely due to the rather confusing implementation of buffering, and the somewhat odd use of nomenclature (by conventional
posted by andykr | 3 Comments
Filed Under: