Hi Dave
Thanks for that.
However in my form method code I have something like: -
DO CASE
CASE PARAM.PCODE="1"
RETURNVALUE="OFFICE"
CASE PARAM.PCODE="2"
RETURNVALUE="WORKS"
...
ENDCASE
Does this mean that I have to go through all the code in all the methods
and
change that to
...
CASE VPARAM.PCODE="1"
...
All the controlsources on the forms are bound to Param.
Doesn't that mean I also have to go through each one of those and change the
control source to vParam.?
This would mean as well as having different dbcs for views and tables (which
is okay) different screens for those that talk direct to the tables and
those that talk to the views.
I am sure that is not the case because that would mean rewriting each and
every screen plus all the other methods.
In CM6 I used data environment classes with
define class clParam as customDataEnv
Add Object vParam as CustomCursor with cursorSource="Param"
define class customCursor as Cursor
...
DataBase=".\data\compviews.dbc"
function init()
this.alias=this.cursorSource
endfunc
Its been a while but I am fairly sure this code did work with views and not
just tables.
> Regards
> Graham
>
>
> ----- Original Message -----
> From: "CodeMine Support" <Support (AT) codemine D.OT com>
> To: "Graham" <gbrown@compsys.co.uk>
> Sent: Saturday, May 31, 2003 3:36 AM
> Subject: Re: Views
>
>
> > > DBC to contain just tables (appdata.dbc)
> > > A second dbc to contain just local views (compview.dbc)
> > > A local view called lvParam which looks at appdata.Param
> > > This local view is set to update etc
> > > I then put the local view on the form and exported its CDE to
CDEVParam
> and
> > > then ensured the NDE had gone.
> >
> > OK
> >
> > > I obviously want the alias to be "Param" so I don't have to change
code,
> the
> > > name property has been left as LVParam
> >
>
> > That is the problem. You cannot have a local view alias with the same
name
> as
> > the table. The table is opened by the SELECT SQL command, so the view
must
> > have a different alias name. Usually a "V" prefix on the alias is the
> standard
> > for views.
> >
> > -Dave
> > Tech Support
> >
> >
> >
>
©2003 Graham |
