🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Updating SQL files

#615
From: Michael Rotteck
Date: Sun, 20 Sep 1998 00:00
27 lines
1377 bytes
On Sat, 19 Sep 1998 15:26:03 -0500, Carl White <whitecw@earthlink.net>
wrote:
Hi Carl,

it's a limitation of Local SQL.

When you have more as two tables for a join with SQL the answer table
is always read-only.

>I'm brand-spanking new to dBase 7.01 and, even though I've been working
>with dBase 5.6 for a few years, I feel like this is a whole new
>product.  Almost immediately I ran into a "problem" trying to set up a
>simple update form using an SQL query I built.
>
>The query has 3 files (a main plus 2 lookup tables).  However, when I
>try to do anything but browse the form (e.g., edit or add records) I get
>an error.  Wading through the help files only served to confuse me
>more.  Is there a way (and I'm sure there is) to set up the SQL query so
>I can update it?  What steps do I follow to do this?
>
>I would appreciate any help I know you folks can provide.
>
>Thanks.
>

--
Michael Rotteck
Technical Details
Message-ID: <3604c005.259978534@forums.borland.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <3604135B.24D6F1A4@earthlink.net>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,29f1301de53c716e
X-Google-Attributes: gidff5a1,public
From: 100277.441@compuserve.com (Michael Rotteck)
Subject: Re: Updating SQL files
Date: 1998/09/20
Message-ID: <3604c005.259978534@forums.borland.com>
X-Deja-AN: 392941958
References: <3604135B.24D6F1A4@earthlink.net>
Organization: Another Netscape Collabra Server User
Newsgroups: borland.public.vdbase.data.sql