On Saturday 15 December 2007 06:27:38 pm Adrian Klaver wrote:
> On Saturday 15 December 2007 4:49 pm, Ed Leafe wrote:
> > On Dec 15, 2007, at 6:50 PM, Adrian Klaver wrote:
> > > 1) I created a form using the ClassDesigner. One form element is a
> > > grid sizer.
> > > I can navigate through the fields in the grid sizer by tabbing when
> > > the form
> > > is empty. When I populate the form by running it, I lose that
> > > ability. Any
> > > idea why that is?
> >
> > Are the controls (and grid sizer) inside of a panel? Panels are what
> > provides the tabbing ability. If they are, what platform are you
> > running on?
>
> I am running Linux. I have attached screenshot from the object tree if it
> helps. I will also answer Johns question here. When I open the
> ClassDesigner with the form file I am able to move the cursor back and
> forth through the controls in the Grid Sizer by tab or shift-tab. When I
> select Run from the File menu a copy of the form opens and is populated
> with data from the database. In the 'live' form I am unable to navigate
> using tab or shift-tab.
>
> > > 2) For this same form, when I run it the parent bizobject selects 1000
> > > records. Where is this limit set and how do I change it? Also how
> > > can I
> > > select records beyond the initial limit?
> >
> > bizobj.setLimit(42) will set the limit to 42. bizobj.setLimit(None)
> > will remove the limit completely.
> >
> > We default to 1000 records to avoid cases where an app can pull
> > everything from a multi-gig table by default. You can still do that,
> > if you really want, but then it's because of your code, not ours. ;-)
>
> Thanks for the information. For the record where do I locate the current
> setting of 1000? I looked through the generated code and could not find
> it. Another question. If I want to implement a rolling window of records
> how do I go about it? In other words start the form with a limit of 100
> records and when I get to the 100th record pull in the next 100.
>
> > -- Ed Leafe
> > -- http://leafe.com
> > -- http://dabodev.com
>
I sort of sure the default is in dCursorMixin.py
def clearSQL(self):
self._fieldClause = ""
self._fromClause = ""
self._whereClause = ""
self._childFilterClause = ""
self._groupByClause = ""
self._orderByClause = ""
self._limitClause = ""
self._defaultLimit = 1000
Regarding the tabbing:
I forgot that ClassDesigner has the ability to run the app.
If memory serves I think a panel is added automaticly when you start a new
form. I might be wrong about that so please use the "Object Info" and check
that you have a "LayoutPanel" in the list. If not add one.
In the case that the panel does exist please save the form as a "Runable App"
and run it from a command line shell. If it still does not work send me the
file and I'll review. I doubt this is a bug but if does turn out to be a bug
I'll post it.
BTW what database are you using?
--
John Fabiani
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/dabo-users/[EMAIL PROTECTED]
