Well, as usual, I am the booboo! I had another order by in the listbox definition which countered the one in the view! I really must get more sleep... Good night :)
> -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Javier > Valencia > Sent: Tuesday, January 25, 2005 10:59 PM > To: RBG7-L Mailing List > Subject: [RBG7-L] - RE: Order By in a View Definition > > Claudine: > I have run into this before, try: > EDIT USING formname ORDER BY company_name ASC, invoice_nb ASC > And see if it helps... > Javier, > > Javier Valencia, PE > President > Valencia Technology Group, L.L.C. > 14315 S. Twilight Ln, Suite #14 > Olathe, Kansas 66062-4578 > Office (913)829-0888 > Fax (913)649-2904 > Cell (913)915-3137 > ================================================ > Attention: > The information contained in this message and or attachments is intended > only for the person or entity to which it is addressed and may contain > confidential and/or privileged material. Any review, retransmission, > dissemination or other use of, or taking of any action in reliance upon, > this information by persons or entities other than the intended recipient > is prohibited. If you received this in error, please contact the sender > and > delete the material from all system and destroy all copies. > ====================================================== > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Claudine > Robbins > Sent: Tuesday, January 25, 2005 10:51 PM > To: RBG7-L Mailing List > Subject: [RBG7-L] - Order By in a View Definition > > Hello, > > I defined a view with an order by. The view is indeed sorted by > company_name, invoice_nb, however when I create a variable listbox based > on > the view, it is no longer sorted and no other 'order by' makes it right > (edi > using formname ord by company_name, invoice_nb gets the same unordered > result as edi using formname). I did move the fields around as they were > placed in the listbox, so I'm being lazy <g> and instead of trying to > change > it, I'm wondering if that could be the problem... > > Claudine :)
