masterrowset

i have an index  ( p_id ), and a masterfield  ( p_id )  but can't seem to hook
up to the master rowset.
snippet :
this.DATABASE1 = new DATABASE()
   this.DATABASE1.parent = this
   with (this.DATABASE1)
      left = 41.0
      top = 375.0
      databaseName = "HCV"
      active = true
   endwith

   this.QUERY1 = new QUERY()
   this.QUERY1.parent = this
   with (this.QUERY1)
      left = 52.0
      top = 440.0
      database = form.database1
      sql = "@PER_TELECARD.sql"
      active = true
   endwith

   with (this.QUERY1.rowset)
      onAppend = class::ROWSET_ONAPPEND
      indexName = "P_ID"
      masterFields = "P_ID"
   endwith

Well, you're only showing us one query. MasterRowset references the 
PARENT rowset for the query ...

Ken

charles wrote:
> i have an index  ( p_id ), and a masterfield  ( p_id )  but can't seem to
hook up to the master rowset.
> snippet :
> this.DATABASE1 = new DATABASE()
>    this.DATABASE1.parent = this
>    with (this.DATABASE1)
>       left = 41.0
>       top = 375.0
>       databaseName = "HCV"
>       active = true
>    endwith
> 
>    this.QUERY1 = new QUERY()
>    this.QUERY1.parent = this
>    with (this.QUERY1)
>       left = 52.0
>       top = 440.0
>       database = form.database1
>       sql = "@PER_TELECARD.sql"
>       active = true
>    endwith
> 
>    with (this.QUERY1.rowset)
>       onAppend = class::ROWSET_ONAPPEND
>       indexName = "P_ID"
>       masterFields = "P_ID"
>    endwith
> 


-- 
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/

*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase/dBASEBooks.htm

charles wrote:
> Hi ken :
> 
> At this time, the form has only one query.  so,  the master rowset isn't
necessary ?  and it is for when you join databases or queries.

Yes. MasterRowset (and masterFields) can be used to link two tables. 
That's the only purpose. It's designed for non-DBF tables, although it 
can be used with them.

Ken

-- 
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/

*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase/dBASEBooks.htm

charles wrote:
> Ken :
> 
> I had an entryfield and a combobox on page 1 and page 2 which i was trying
to join together. after a lot of trying the light bulb finally came on. seeing
there in the same location and same size,  I just changed the page number 0 and
now i have a lot less to deal with.  why i was trying to set the master rowset
was, i want to select from the combobox and have it go to the correct record or
rowset. i have a grid in the back ground and if i use  first, next, prev, last,
it seems to be on the correct record.
> thanks - charlie k 

The combobox is *not* designed to navigate a rowset. Suggest you 
reconsider, using a SEEKER and a grid, or a listbox instead. While you 
can force a combobox to do it, it's not the purpose, and frankly it 
makes little sense when you have tools that are designed to do what you 
want.

Ken

-- 
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/

*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase/dBASEBooks.htm

Ken Mayer [dBVIPS] Wrote:

> Well, you're only showing us one query. MasterRowset references the 
> PARENT rowset for the query ...
> 
> Ken

    
> 
> charles wrote:
> > i have an index  ( p_id ), and a masterfield  ( p_id )  but can't seem
to hook up to the master rowset.
> > snippet :
> > this.DATABASE1 = new DATABASE()
> >    this.DATABASE1.parent = this
> >    with (this.DATABASE1)
> >       left = 41.0
> >       top = 375.0
> >       databaseName = "HCV"
> >       active = true
> >    endwith
> > 
> >    this.QUERY1 = new QUERY()
> >    this.QUERY1.parent = this
> >    with (this.QUERY1)
> >       left = 52.0
> >       top = 440.0
> >       database = form.database1
> >       sql = "@PER_TELECARD.sql"
> >       active = true
> >    endwith
> > 
> >    with (this.QUERY1.rowset)
> >       onAppend = class::ROWSET_ONAPPEND
> >       indexName = "P_ID"
> >       masterFields = "P_ID"
> >    endwith
> > 
>       
> 
> -- 
> /(Opinions expressed are purely my own, not those of dataBased
> Intelligence, Inc.)/
> 
> *Ken Mayer* [dBVIPS]
> /Golden Stag Productions/
> dBASE at goldenstag dot net
> http://www.goldenstag.net/GSP
> http://www.goldenstag.net/dbase/dBASEBooks.htm
> http://www.goldenstag.net/dbase

Hi ken :