Article View: borland.public.vdbase.data.sql
Article #1031Re: not letting me update??
From: Lynn Gruber
Date: Wed, 03 Jun 1998 00:00
Date: Wed, 03 Jun 1998 00:00
40 lines
1589 bytes
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-mailReferences:
<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