Re: SQL Question

Article View: borland.public.vdbase.data.sql

Article #319

Back to borland.public.vdbase.data.sql Previous Next

#319

From: Geoff S. Wass
Date: Sat, 02 Jan 1999 00:00

17 lines
1072 bytes

Craig,

The use of SQL with .DBF tables is not normally recommended. The
recommended method for .DBF tables it to use a dataModule with the
master-detail type of linking. There are two advantages: (1) is runs at
least as fasts as SQL if not faster; (2) the result is always updateable
while SQL generally results in read-only views.

Re-do this using a dataModule and master-detail linking. It is easy and
worth the effort.

--
Geoff Wass
Kuala Lumpur, Malaysia


=>=> More dBASE info at http://members.theglobe.com/Geoff_Wass <=<=

Technical Details

Message-ID: <368D954E.28E39F7B@ibm.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <368D3114.82F8A14A@cfi.net>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,2e1c13aae25a9cd4
X-Google-Attributes: gidff5a1,public
From: "Geoff S. Wass" <gswass@ibm.net>
Subject: Re: SQL Question
Date: 1999/01/02
Message-ID: <368D954E.28E39F7B@ibm.net>
X-Deja-AN: 427896234
Content-Transfer-Encoding: 7bit
References: <368D3114.82F8A14A@cfi.net>
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
Organization: Noordindarus Consultancy Sdn. Bhd.
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message