I wasn't actually referring to the addition of the 'NOFILTER' as much as using the dbf() function to get the temp table name that VFP would use.
SELECT ... INTO CURSOR MyCursor NOFILTER
USE (dbf('MyCursor')) SHARED AGAIN IN 0 ALIAS MyWritableCursor
BOb
>Bob,
>
>Absolutely right if you are only using one table and not aggregating anything.
>
>I guess I use multiple tables so often that I forget that one.
>
>
>>I think you would need to do:
>>
>>SELECT ... INTO CURSOR MyCursor NOFILTER
>>USE (dbf('MyCursor')) SHARED AGAIN IN 0 ALIAS MyWritableCursor
>>
>>BOb
>>
>>
>>
>>>Mohammed,
>>>
>>>The way to make a cursor writable is
>>>SELECT ... INTO CURSOR MyCursor
>>>USE MyCursor SHARED AGAIN IN 0 ALIAS MyWritableCursor
but as the others have said, this is not really what you want to do.
>>>
>>>In VFP7 there will be a
READWRITE
clause in the
SELECT
statement which will automatically make the resulting cursor writable.
>>>
>>>
>>>
>>>>Hi, All
>>>>
>>>>I am developing my first application under visual foxpro 6.0. I usually use clarion under dos. I made a grid control to display a result of SELECT command it works fine. but, it does not allow me to edit any field in the grid control . I made sure that the read only is off and I went all over the step again and again but I could not know what's wrong. can anybody help me to edit to the table directly from the grid control ?
>>>>
>>>>thanks.
>>>>
>>>>
>>>>M. Sameer