Hi Shawn, Have you tried the sortable flag for fields in dbforms-config? If i remember right this shouldbe set in fields which are no key fields if you want to sort this fields....
Regards, Henner > -----Urspr�ngliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] Im > Auftrag von shawn > Gesendet: Sonntag, 26. Januar 2003 10:58 > An: [EMAIL PROTECTED] > Betreff: [Jdbforms-developers] orderBy problem with > non-primary keys solved!?! > > > I think I see the error now. > > Internally dbforms will set position such as > > INFO [Thread-4] (DbFormTag.java:1404) - lastPosition 0:1:7-2:1:9 > > when it wants to useNav next > > then in Table.fillWithValues it uses this position to get > names and values from an orderConstraint that has been > generated (correctly I believe). > > INFO [Thread-4] (Table.java:1383) - *** parsing through: 0:1:7-2:1:9 > > However, non-key positions aren't used in calculating the > lastPosition so no information is available. [note the 7 and > 9 in this key is absolutely necessary to builing a query that > takes navigation into account. For it to work though we need > the value of of the non-primary key (1:1:4) to be included. > I verified this by running the generated query with the and > substiting these values. It worked perfectly. But DBforms > doesn't include that non-primary key info when setting the > position so... > > that results in: > WARN [Thread-4] (Table.java:1403) - position entry has null value:n2 > > this means the query that get done will return no results > because it can't fill in a value for the n2 (non-primary key) > and then dbforms automatically turns it into a navlast event > > The net result is that using orderBy with a non-primary key > will skip results in navigation. > > I will confirm this and write a better explaination tomorrow. > > Shawn > > -- > shawn <[EMAIL PROTECTED]> > > > > ------------------------------------------------------- > This SF.NET email is sponsored by: > SourceForge Enterprise Edition + IBM + LinuxWorld = Something > 2 See! http://www.vasoftware.com > _______________________________________________ > Jdbforms-developers mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jdbforms-developers > ------------------------------------------------------- This SF.NET email is sponsored by: SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See! http://www.vasoftware.com _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
