I think the problem is that you are trying to sort numeric data in a character field.
You can create a new index like Index on padl(invno,10,'0') tag invsort Then you should get the sort you are looking for -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Sytze de Boer Sent: Tuesday, August 31, 2010 3:27 PM To: profox Subject: Re: Any gurus out there? All of this is interesting, but I don't see an answer to my problem. When I browse the table, all is fine, and I don't see any index issues I can browse the table from any workstation, and all appears fine I also created a special little routine where instead of printing the invoice, i simply place a record into a temporary table. i.e. instead of "report form (winreport)", I place it in a table All the records appear in this table in the correct order Its only when we PRINT the invoices that they get out of order S On Wed, Sep 1, 2010 at 6:29 AM, Rafael Copquin <[email protected]>wrote: > Contrary to what I just said, I consulted the book "Taming VFP SQL" > from Tamar Graynor and others and they say: > > "You don't need NOFILTER if you specify READWRITE" > > So, I guess I was wrong, and you were right. I learned something new today. > > Regards > > Rafael Copquin > > > El 31/08/2010 10:33, MB Software Solutions, LLC escribió: > > Rafael Copquin wrote: > >> I would do something like this: > >> > >> select invoice table > >> set order to 0 > >> > >> use in select('curAux') > >> > >> select (fieldlist) from (invoices table) into cursor curAux > >> readwrite nofilter where (dates of invoicing period) update curAux > >> set (invoice number field) = padl(alltrim(invoice number > >> field),5) > > > > I thought if you used the READWRITE, that you didn't need the NOFILTER? > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
