I thought a cursor created with a SQL select was read-only..is there a way to make it read-write w/o selecting to a table?

Chris

>Even better, select to a cursor and it goes away when the form is closed. That way there are never conflicts with othe users, and you don't have to worry about deleting the tmp tables.
>
>>Thanks for the help. I'll just select to a table with a random filename, clear the values that I don't want, and run the report on that.
>>
>>Thanks,
>>Chris
>>
>>>I cheat! I run my query to a read/write cursor with a field for the subtotal you want, then update that field using a SELECT DISTINCT.... or other means. Since you're working only with the report cursor this step is usually very fast.
>>>
>>>When the report prints, it prints the subtotal like it prints every other field with the header information - just once. If I need final totals, I will sometimes make a separate 'totals' cursor, index it and relate it to the original.
>>>
>>>HTH
>>>Barbara
>>>
>>>>First a little explanation, then the problem:
>>>>
>>>>Lets say you have a report that prints invoices (some header information, followed by one or more detail lines).
>>>>
>>...
>>>>
>>>>VFP 6.0, using the VFP report writer.
>>>>
>>>>Thanks,
>>>>Chris Vesper
>>>>softdev@yahoo.com