🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: sql and params in reports

#968
From: Romain Strieff [TeamB]
Date: Tue, 09 Jun 1998 00:00
32 lines
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-mail
References: <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