Article View: borland.public.vdbase.data.sql
Article #968Re: sql and params in reports
From: Romain Strieff [TeamB]
Date: Tue, 09 Jun 1998 00:00
Date: Tue, 09 Jun 1998 00:00
32 lines
1833 bytes
1833 bytes
In article <357d051d.834705@forums.borland.com>, (Gary White) grudgingly admits... > > Hi Ken, > > PMFJI, but from what I've seen of the dataModule, the share property > is used to determine if a form, report, etc should look for a previous > instance of the dataModule before opening tables. If share is 1 (all) > then it checks for a previous instance. If one is found, the > previously opened tables are used. This being the case, the share > property of the parent form, or the form calling the report is not > required to be ALL. > > > Place an instance of the datamodule on your form. Set the SHARED > > property to ALL. > Actually, the shared property of the dataModRef in the form is > insignificant unless it needs to share tables with whatever calls the > form. ------- That's the only thing you need actually. The Datamodule's share property is just to share the same connection to the Oracle, Informix etc server, which doesn't play for local tables. Use the datamodref's shar property to allow a report, subform etc to share the same record pointer including filters etc. -- Romain Strieff [TeamB] Want quick help? Check previous Q and A at: http://forumsearch.borland.com:88/ and TIs at http://www.borland.com/VdBASE/vdbprod.html
Technical Details
Message-ID:
<MPG.fe738f61f903f3b98ade1@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<6lga00$4ic2@forums.borland.com> <357c821f.1763061@forums.borland.com> <357d051d.834705@forums.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,e334d7e5196c99b2 X-Google-Attributes: gidff5a1,public From: Romain@Do.not.reply.via.e-mail (Romain Strieff [TeamB]) Subject: Re: sql and params in reports Date: 1998/06/09 Message-ID: <MPG.fe738f61f903f3b98ade1@forums.borland.com> X-Deja-AN: 361003096 References: <6lga00$4ic2@forums.borland.com> <357c821f.1763061@forums.borland.com> <357d051d.834705@forums.borland.com> Reply-To: teamb@opto-pps.com Organization: TeamB Newsgroups: borland.public.vdbase.data.sql