🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: VDB7 - DMD Question

#1170
From: Patricia Dilmore
Date: Thu, 23 Apr 1998 00:00
75 lines
2408 bytes
This is a multi-part message in MIME format.

--------------7ECE156C7BC0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Bowen Moursund wrote:

> Use a rowset.canGetRow event handler.
> 
> Next complaint????
> __
Not that I'm complaining or anything, but...... , the cangetrow event
only 'gets' the first record in the table (and disregards the remaining
700 or so records).  Here's the dmd.  I'm dropping it onto a report in
the report designer.

--------------7ECE156C7BC0
Content-Type: text/plain; charset=us-ascii; name="CLAIMS.dmd"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline; filename="CLAIMS.dmd"

** END HEADER -- do not remove this line
//
// Generated on 04/23/98
//
class CLAIMSDataModule of DATAMODULE


   this.CLAIMS1 = new QUERY()
   this.CLAIMS1.parent = this
   with (this.CLAIMS1)
      left = 3
      top = 1
      sql = 'select * from "claims.dbf"'
      active = true
   endwith



   this.PROCS1 = new QUERY()
   this.PROCS1.parent = this
   with (this.PROCS1)
      left = 10
      top = 1
      sql = 'select * from "PROCS.DBF"'
      active = true
   endwith


   with (this.PROCS1.rowset)
      indexName = "CLAIMNO"
      masterRowset = parent.parent.claims1.rowset
      masterFields = "CLAIMNO"
   endwith


   with (this.CLAIMS1.rowset)
      canGetRow = class::ROWSET_CANGETROW
		filter = "closed = false"
   endwith

   this.rowset = this.claims1.rowset

   function rowset_canGetRow
		printrow = false
      if this.parent.parent.PROCS1.rowset.fields["TOS"].value = 'X'
   	      printrow = true
    	endif
      return printrow

endclass

--------------7ECE156C7BC0--
Technical Details
Message-ID: <353FDCA1.6480@Bellsouth.net>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <353D1963.4C0D@Bellsouth.net> <6hivn8$mc49@forums.borland.com> <353D5D1A.3682@Bellsouth.net> <6hl6j9$okg7@forums.borland.com> <353E7483.513D@Bellsouth.net> <6hnq54$r4g9@forums.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,438323d64b0ab196
X-Google-Attributes: gidff5a1,public
From: Patricia Dilmore <pdilmore@Bellsouth.net>
Subject: Re: VDB7 - DMD Question
Date: 1998/04/23
Message-ID: <353FDCA1.6480@Bellsouth.net>
X-Deja-AN: 347081892
References: <353D1963.4C0D@Bellsouth.net> <6hivn8$mc49@forums.borland.com> <353D5D1A.3682@Bellsouth.net> <6hl6j9$okg7@forums.borland.com> <353E7483.513D@Bellsouth.net> <6hnq54$r4g9@forums.borland.com>
Content-Type: multipart/mixed; boundary="------------7ECE156C7BC0"
Organization: Patricia Dilmore
Mime-Version: 1.0
Reply-To: pdilmore@Bellsouth.net
Newsgroups: borland.public.vdbase.data.sql