Article View: borland.public.vdbase.data.sql
Article #615Re: Updating SQL files
From: Michael Rotteck
Date: Sun, 20 Sep 1998 00:00
Date: Sun, 20 Sep 1998 00:00
27 lines
1377 bytes
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-mailReferences:
<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