From: Grant on 15 Dec 2009 17:42 I am trying to figure out how to use Scopes to seperate out only record (s) of interest but I must be missing a big step in the logic. I have a data window that will display data from a single indexed server. When I apply the scope conditions for top and bottom scopes nothing happens. Can someone tell me if I missing something here. Method PostInit(oWindow, iCtlID, oServer, uExtra) CLASS dtwMyData
From: Grant on 15 Dec 2009 17:49 On Dec 15, 2:42 pm, Grant <gra...(a)dunsmoreinfo.com> wrote: > I am trying to figure out how to use Scopes to seperate out only record > (s) of interest but I must be missing a big step in the logic. I have > a data window that will display data from a single indexed server. > When I apply the scope conditions for top and bottom scopes nothing > happens. Can someone tell me if I missing something here. > > Method PostInit(oWindow, iCtlID, oServer, uExtra) CLASS dtwMyData (Sorry - hit the wrong key!) LOCAL odbsServer as DBServer odbsServer L= svrCustomer{} odbsServer:GoTop() odbsServer:OrderScope(TOPSCOPE, "FIELDGET(#NAME) == 'Woodside Construction ") odbsServer:OrderScope(BOTTOMSCOPE, FIELDGET(#NAMEA) == 'Woodside Construction ") odbsServer:GoTop() I am using Scope in his example to sort one record out of about 100 but in the final app there will be more. I am trying to fiure this method out so I playing with small test programs. Thanmks for any help.
From: Geoff Schaller on 15 Dec 2009 18:27 Grant, Scopes are not an expression, they are a value. The value must match the order expression fields used. Geoff "Grant" <grantd(a)dunsmoreinfo.com> wrote in message news:d64473eb-8b1c-4abd-b01d-94a01c0c8471(a)g22g2000prf.googlegroups.com: > I am trying to figure out how to use Scopes to seperate out only record > (s) of interest but I must be missing a big step in the logic. I have > a data window that will display data from a single indexed server. > When I apply the scope conditions for top and bottom scopes nothing > happens. Can someone tell me if I missing something here. > > Method PostInit(oWindow, iCtlID, oServer, uExtra) CLASS dtwMyData
From: Grant on 15 Dec 2009 19:59 On Dec 15, 3:27 pm, "Geoff Schaller" <geo...(a)softxwareobjectives.com.au> wrote: > Grant, > > Scopes are not an expression, they are a value. > The value must match the order expression fields used. > > Geoff > > "Grant" <gra...(a)dunsmoreinfo.com> wrote in message > > news:d64473eb-8b1c-4abd-b01d-94a01c0c8471(a)g22g2000prf.googlegroups.com: > > > > > I am trying to figure out how to use Scopes to seperate out only record > > (s) of interest but I must be missing a big step in the logic. I have > > a data window that will display data from a single indexed server. > > When I apply the scope conditions for top and bottom scopes nothing > > happens. Can someone tell me if I missing something here. > > > Method PostInit(oWindow, iCtlID, oServer, uExtra) CLASS dtwMyData- Hide quoted text - > > - Show quoted text - ok The server is indexed on the 'Name' field. Can I not use a text value (in quotes) to set a scope for the 'Name' field of the server? I thought the data was all resolved to a value when the file was indexed. Still confused!
From: Roger Lawton on 15 Dec 2009 21:07
Grant: Unless I am mistaken you would want something like odbsServer:OrderScope(TOPSCOPE, "Woodside Construction") odbsServer:OrderScope(BOTTOMSCOPE, "Woodside Construction ") Assuming the you have the server set to an index that starts with your "Name" column. HTH -- Roger Lawton Product Manager SOMAX, Inc. "Grant" <grantd(a)dunsmoreinfo.com> wrote in message news:6b17014a-0ad5-4c19-9e89-79cf7d64f81a(a)y32g2000prd.googlegroups.com... On Dec 15, 3:27 pm, "Geoff Schaller" <geo...(a)softxwareobjectives.com.au> wrote: > Grant, > > Scopes are not an expression, they are a value. > The value must match the order expression fields used. > > Geoff > > "Grant" <gra...(a)dunsmoreinfo.com> wrote in message > > news:d64473eb-8b1c-4abd-b01d-94a01c0c8471(a)g22g2000prf.googlegroups.com: > > > > > I am trying to figure out how to use Scopes to seperate out only record > > (s) of interest but I must be missing a big step in the logic. I have > > a data window that will display data from a single indexed server. > > When I apply the scope conditions for top and bottom scopes nothing > > happens. Can someone tell me if I missing something here. > > > Method PostInit(oWindow, iCtlID, oServer, uExtra) CLASS dtwMyData- Hide > > quoted text - > > - Show quoted text - ok The server is indexed on the 'Name' field. Can I not use a text value (in quotes) to set a scope for the 'Name' field of the server? I thought the data was all resolved to a value when the file was indexed. Still confused! |