🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Read-Only why ?

#664
From: Geoff Wass
Date: Sun, 02 Aug 1998 00:00
24 lines
1276 bytes
Roger,

Many SQL queries (except SELECT * FROM myFile) cause read-only joins if
made on dBASE tables (but not on other tables).

With dBASE tables, use the Master-Detail form of data linking and do it
within a dataModule (so that you can reuse it).

This will solve your problem, plus it will execute much much faster if
the dBASE tables are large.

--
Geoff Wass
Kuala Lumpur, Malaysia


=============================================================
Please respond to a newsgroup posting by posting a reply (not e-mail).
In this way, all can help and all can learn!

Report Inprise/Borland bugs!
http://www.inprise.com/devsupport/bugs/bug_reports.html
=============================================================
Triumph is in the first syllable.
Technical Details
Message-ID: <35C3ED44.7109CF43@ibm.net>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <6pvjdr$ril6@forums.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,420717107802b0ca
X-Google-Attributes: gidff5a1,public
From: Geoff Wass <gswass@ibm.net>
Subject: Re: Read-Only why ?
Date: 1998/08/02
Message-ID: <35C3ED44.7109CF43@ibm.net>
X-Deja-AN: 377129976
Content-Transfer-Encoding: 7bit
References: <6pvjdr$ril6@forums.borland.com>
Content-Type: text/plain; charset=us-ascii
Organization: Noordindarus Consultancy Sdn. Bhd.
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql