🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: not letting me update??

#1031
From: Lynn Gruber
Date: Wed, 03 Jun 1998 00:00
40 lines
1589 bytes
Thanks, it works great!  But I have ONE more problem (so close!!!).  

Using your example below, what if the file "invoice" had a field, say,
date.  How would you display only customers with orders only on a certain
date?  

Thanks for all your help!
lynn


> 
>    this.CUSTOMER1 = new QUERY()
>    this.CUSTOMER1.parent = this
>    with (this.CUSTOMER1)
>       left = 1.4286
>       top = 0.3182
>       sql = 'select * from "Customer.dbf"'
>       active = true
>    endwith
> 
>    with (this.CUSTOMER1.rowset)
>       indexName = "LAST NAME"
>    endwith
> 
>    this.INVOICE1 = new QUERY()
>    this.INVOICE1.parent = this
>    with (this.INVOICE1)
>       left = 6.2857
>       top = 1.8182
>       sql = 'select * from "Invoice.dbf"'
>       active = true
>    endwith
> 
>    with (this.INVOICE1.rowset)
>       indexName = "CUSTOMER ID"
>       masterRowset = parent.parent.customer1.rowset
>       masterFields = "Customer ID"
>    endwith
> 
Technical Details
Message-ID: <01bd8ef9$dddea9c0$cb237da3@miles.allworld.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <01bd8d91$b5126d60$cd237da3@miles.allworld.com> <6kv5eq$k7615@forums.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,17b280fd54be51c
X-Google-Attributes: gidff5a1,public
From: "Lynn Gruber" <lgruber@allworld.com>
Subject: Re: not letting me update??
Date: 1998/06/03
Message-ID: <01bd8ef9$dddea9c0$cb237da3@miles.allworld.com>
X-Deja-AN: 359146549
Content-Transfer-Encoding: 7bit
References: <01bd8d91$b5126d60$cd237da3@miles.allworld.com> <6kv5eq$k7615@forums.borland.com>
Content-Type: text/plain; charset=ISO-8859-1
Organization: Another Netscape Collabra Server User
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql