Prev: bBrowser and codeblock and fieldname
Next: Address's
From: Geoff Chambers on 29 Jun 2010 12:24 I have an SQL Server in bBrowser, Once I set up the browser, I'm able to set the bBrowser to a specific ros within the RecordSet. All of this works Ok. What I would like is to force this row to be the first row that displays in the bBrowser. Is this possible?
From: Kevin on 29 Jun 2010 12:48 Geoff, If you mean that that you want the particular row to be the first row in the browser then there are two possible options I can think of, which may or may not suit your needs. 1) Create your SQL statement in such a way that it is the first row that is fetched. For example: select top 100 * from table where prodid >= 100 Where prodid is a column with a unique ID for the row such as an Auto Increment column. 2) Find some value in the row that can use - with an order clause - that will put the row the top o the list. Option 1 is probably the easier, depending on your data. I can't think of any other way of doing it. Hope this helps. Kevin "Geoff Chambers" <gchambers02(a)msn.com> wrote in message news:7a986d19-153a-4327-8892-6134d89dba18(a)j4g2000yqh.googlegroups.com: > I have an SQL Server in bBrowser, Once I set up the browser, I'm able > to set the bBrowser to a specific ros within the RecordSet. All of > this works Ok. What I would like is to force this row to be the first > row that displays in the bBrowser. Is this possible?
From: Geoff Schaller on 30 Jun 2010 08:43 Geoff Yes, bBrowser has a number of properties you can set that obey this. Open the help and scan down the properties for the bBrowser class. You will see quite a few along these lines. Geoff "Geoff Chambers" <gchambers02(a)msn.com> wrote in message news:7a986d19-153a-4327-8892-6134d89dba18(a)j4g2000yqh.googlegroups.com: > I have an SQL Server in bBrowser, Once I set up the browser, I'm able > to set the bBrowser to a specific ros within the RecordSet. All of > this works Ok. What I would like is to force this row to be the first > row that displays in the bBrowser. Is this possible?
From: Geoff Chambers on 30 Jun 2010 16:54 On Jun 30, 8:43 am, "Geoff Schaller" <geo...(a)softxwareobjectives.com.au> wrote: > Geoff > > Yes, bBrowser has a number of properties you can set that obey this. > Open the help and scan down the properties for the bBrowser class. You > will see quite a few along these lines. > > Geoff > > "Geoff Chambers" <gchamber...(a)msn.com> wrote in message > > news:7a986d19-153a-4327-8892-6134d89dba18(a)j4g2000yqh.googlegroups.com: > > > > > I have an SQL Server in bBrowser, Once I set up the browser, I'm able > > to set the bBrowser to a specific ros within the RecordSet. All of > > this works Ok. What I would like is to force this row to be the first > > row that displays in the bBrowser. Is this possible?- Hide quoted text - > > - Show quoted text - Ok, I tried DebugOutput(iRow := SELF:oDCBrowser:SelectionFirstRow()) = 60 DebugOutput(SELF:oDCBrowser:FirstVisibleRowNo,2) = 57 DebugOutput(iREC := SELF:oDCBrowser:CurrentRecNo,3) = 60 SELF:oDCBrowser:SetFirstRow(iRow) = 60 SELF:oDCBrowser:Redraw(#DATA) DebugOutput(SELF:oDCBrowser:FirstVisibleRowNo,4) = 60 The row I want and the one that is selected does = 60 but the first visible row is actually 30 and calling the above methods or assigns doesn't change anything.
From: Geoff Schaller on 30 Jun 2010 18:44
Have you asked Joachim? "Geoff Chambers" <gchambers02(a)msn.com> wrote in message news:79716a82-5a97-43a9-bfbd-33f47b599d4a(a)y11g2000yqm.googlegroups.com: > On Jun 30, 8:43 am, "Geoff Schaller" > <geo...(a)softxwareobjectives.com.au> wrote: > > > Geoff > > > > Yes, bBrowser has a number of properties you can set that obey this. > > Open the help and scan down the properties for the bBrowser class. You > > will see quite a few along these lines. > > > > Geoff > > > > "Geoff Chambers" <gchamber...(a)msn.com> wrote in message > > > > news:7a986d19-153a-4327-8892-6134d89dba18(a)j4g2000yqh.googlegroups.com: > > > > > > > > > > I have an SQL Server in bBrowser, Once I set up the browser, I'm able > > > to set the bBrowser to a specific ros within the RecordSet. All of > > > this works Ok. What I would like is to force this row to be the first > > > row that displays in the bBrowser. Is this possible?- Hide quoted text - > > > > > - Show quoted text - > > > Ok, I tried > > DebugOutput(iRow := SELF:oDCBrowser:SelectionFirstRow()) = 60 > DebugOutput(SELF:oDCBrowser:FirstVisibleRowNo,2) = 57 > DebugOutput(iREC := SELF:oDCBrowser:CurrentRecNo,3) = 60 > SELF:oDCBrowser:SetFirstRow(iRow) = 60 > SELF:oDCBrowser:Redraw(#DATA) > DebugOutput(SELF:oDCBrowser:FirstVisibleRowNo,4) = 60 > > The row I want and the one that is selected does = 60 but the first > visible row is actually 30 and calling the above methods or assigns > doesn't change anything. |