Article View: borland.public.vdbase.data.sql
Article #1170Re: VDB7 - DMD Question
From: Patricia Dilmore
Date: Thu, 23 Apr 1998 00:00
Date: Thu, 23 Apr 1998 00:00
75 lines
2408 bytes
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-mailReferences:
<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