I depends on what you want to do. I quote from help:
quote
NOFILTER creates a cursor that can be used in subsequent queries.
unquote
Even though help also says that the nofilter clause can slowdown the
query a bit, I never found this to be a substantial delay, so
I use it automatically, least I forget.
Nofilter is really applicable when you derive a select from other
selects, because it ensures that the data comes from the previous queries.
BTW, it has nothing to do with READWRITE. This one just makes the cursor
modifiable.
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.
