🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

SQL: Error-Capability not supported. Visual dBASE 7

#281
From: JonTrimble
Date: Tue, 22 Dec 1998 00:00
38 lines
2338 bytes
I have two tables joined (with left outer join checked) with
an SQL join in a one-to-many (hopefully) relationship
developed in the SQL Designer.  The resulting SQL statement
is:

SELECT Cases.Case, Cases.Intake, Cases.ComplName,
Cases.ComplStreet, Cases.ComplCity, Cases.ComplSt,
Cases.ComplZip, Cases.ComplPhone, Cases.Relation,
Cases.Against, Cases.InfoSource, Cases.ComplConsent,
Cases.ResName, Cases.Gender, Cases.Race, Cases.Age,
Cases.ResStreet, Cases.ResCity, Cases.ResSt, Cases.ResZip,
Cases.ResPhone, Cases.ResConsent, Cases.OmbFirstName,
Cases.OmbLastName, Cases.NumberAffected, Cases.Billing,
Cases.FacName, Cases.Statement, Cases.Hours, Cases.Expenses,
Cases.Miles, Cases.Action, Cases.FollowUp, Cases.Closed,
Complaintcodes.ComplaintCode, Complaintcodes.Case,
Complaintcodes.Class, Complaintcodes.Resolution,
Complaintcodes.Referral
FROM "C:\Program Files\Borland\Visual
dBASE\Complaints\cases.dbf" Cases
   LEFT OUTER JOIN "C:\Program Files\Borland\Visual
dBASE\Complaints\complaintcodes.dbf" Complaintcodes
   ON  (Complaintcodes.Case = Cases.Case)

The problem I am having is that when I just RUN the SQL file
I get a Browser which works.  I used the Form Designer to
design a form with the SQL file as the input.  It appeared
to work perfectly.  The Add, Delete, Save, Abandon, Top of
File... icons were on the top Speed Bar as they should be.
I selected Add and got a new blank row.  I put in some data,
including data for the child table, and clicked Save.  I got
an error, which, of course, is not in the Online Help, that
said Error. Capability does not exist.  This seems to me to
be a most straight forward app.  I did not write a line of
code so I do not know what I could have messed up.  I would
like to get this to work.  Any ideas?

Jon
Technical Details
Message-ID: <36801DAD.979F1C93@juno.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,737b7a12a9c900f0,start
X-Google-Attributes: gidff5a1,public
From: JonTrimble <jontrimble@juno.com>
Subject: SQL:  Error-Capability not supported.  Visual dBASE 7
Date: 1998/12/22
Message-ID: <36801DAD.979F1C93@juno.com>
X-Deja-AN: 424985843
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=us-ascii
X-Corel-MessageType: EMail
Organization: Another Netscape Collabra Server User
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql