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.
