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?
>

_______________________________________________
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.

Reply via email to