SQL and GRID object

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

Article #754

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

#754

From: Doug MacKinnon
Date: Sat, 11 Jul 1998 00:00

31 lines
1352 bytes

I have two databases: CUSTOMER and FULFILLMENT

I have a grid object on a form where I want the entries from the FULFILLMENT
to correspond to the matching CUSTOMER.

The CUSTOMER database has a field "Customer ID" autoincrement.
The FULFILLMENT database has a field "Customer ID"  numeric, width 6

The entries.sql is:SELECT Fulfillment."Month", Fulfillment."Year",
Fulfillment."Type", Fulfillment."Serial Number"
FROM "customer.dbf" Customer, "fulfillment.dbf" Fulfillment
WHERE  Customer."Customer ID" = Fulfillment."Customer ID"

The customer info appears correctly on the form but the entries in the grid
do not display.

   this.GRID1 = new GRID(this)
   with (this.GRID1)
      dataLink = form.entries1.rowset

      bgColor = "white"
      pageno = 3
      height = 4
      left = 32
      top = 12
      width = 57
   endwith

Your help is VERY much appreciated. Thanks.

Doug

Technical Details

Message-ID: <6o9af8$rrh1@forums.borland.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,9780f046f4c80b16,start
X-Google-Attributes: gidff5a1,public
From: "Doug MacKinnon" <dmack@home.com>
Subject: SQL and GRID object
Date: 1998/07/11
Message-ID: <6o9af8$rrh1@forums.borland.com>
X-Deja-AN: 370632114
Organization: Another Netscape Collabra Server User
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Newsgroups: borland.public.vdbase.data.sql