Re: VDB7.01 Relating two tables

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

Article #1135

Back to borland.public.vdbase.data.sql Previous Next

#1135

From: hirschv at mindspring dot com Ke...
Date: Fri, 17 Apr 1998 00:00

22 lines
1464 bytes

"H. W. Andersen" <mailbox@anpro.com> wrote:

>This gives me the appropriate Archivep records associated with their Archive
>record.  I want to further limit this to one invoice number so that a grid
>on the form displays only the Archivep records that are associated with the
>Archive record.  Presently, all of the Archivep records are displayed.

The problem with SQL joins is that the data is probably not going to
be editable. (This is a BDE implementation issue, not dbase.) 

Suggest instead that you look into using the masterRowset/masterFields
properties of the rowset objects, and simply place two queries onto
your form (or use a datamodule -- better idea, in the long run). For
more details on the use of datamodules and such, check the Developer's
Guide (this ships with VdBASE) -- chapter 6 ...

Ken
---
Ken Mayer (Golden Stag Productions)
http://www.mindspring.com/~hirschv/homepage.htm
Please respond in the newsgroup unless explictly asked otherwise

Technical Details

Message-ID: <3536a9f1.1891768@forums.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <6h5pug$92q22@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,40162800516bf33c
X-Google-Attributes: gidff5a1,public
From: hirschv at mindspring dot com (Ken Mayer)
Subject: Re: VDB7.01 Relating two tables
Date: 1998/04/17
Message-ID: <3536a9f1.1891768@forums.borland.com>
X-Deja-AN: 344855771
References: <6h5pug$92q22@forums.borland.com>
Organization: Golden Stag Productions
Reply-To: hirschv@nospam.mindspring.com
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message