Article View: borland.public.vdbase.data.sql
Article #281SQL: Error-Capability not supported. Visual dBASE 7
From: JonTrimble
Date: Tue, 22 Dec 1998 00:00
Date: Tue, 22 Dec 1998 00:00
38 lines
2338 bytes
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-mailShow 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