How to delete record in cursor

Hi Expert,
Please advice how to delete/remove a record from the
CURSOR that I get from the following code:

SELECT *FROM CUSDTA INTO CURSOR CURDTA

so, I want to delete record or some record in CURDTA

Thank's for advices
Hidayat

Cindy
Sun Jan 04 19:44:19 CST 2004

In news: 037201c3d32b$7eba7830$a101280a@phx.gbl,
Hidayat <anonymous@discussions.microsoft.com> wrote:
> Please advice how to delete/remove a record from the
> CURSOR that I get from the following code:
>
> SELECT *FROM CUSDTA INTO CURSOR CURDTA
>
> so, I want to delete record or some record in CURDTA

Hi Hidayat,

Which version of FoxPro are you using? In VFP8 use the READWRITE keyword to
make CurDta readwrite and then just use the DELETE command.

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden@mvps.org www.cindywinegarden.com

Hidayat
Sun Jan 04 21:12:45 CST 2004

Sorry Cindy I write uncomplete information, I use VFP7.
Thank's
Hidayat


>-----Original Message-----
>In news: 037201c3d32b$7eba7830$a101280a@phx.gbl,
>Hidayat <anonymous@discussions.microsoft.com> wrote:
>> Please advice how to delete/remove a record from the
>> CURSOR that I get from the following code:
>>
>> SELECT *FROM CUSDTA INTO CURSOR CURDTA
>>
>> so, I want to delete record or some record in CURDTA
>
>Hi Hidayat,
>
>Which version of FoxPro are you using? In VFP8 use the
READWRITE keyword to
>make CurDta readwrite and then just use the DELETE
command.
>
>--
>Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
>cindy.winegarden@mvps.org www.cindywinegarden.com
>
>
>
>.
>

Jack
Sun Jan 04 21:39:27 CST 2004

In article <ODPjO8y0DHA.4008@tk2msftngp13.phx.gbl>,
cindy.winegarden@mvps.org says...
> In news: 037201c3d32b$7eba7830$a101280a@phx.gbl,
> Hidayat <anonymous@discussions.microsoft.com> wrote:
> > Please advice how to delete/remove a record from the
> > CURSOR that I get from the following code:
> >
> > SELECT *FROM CUSDTA INTO CURSOR CURDTA
> >
> > so, I want to delete record or some record in CURDTA
>
> Hi Hidayat,
>
> Which version of FoxPro are you using? In VFP8 use the READWRITE keyword to
> make CurDta readwrite and then just use the DELETE command.

READWRITE is also available in VFP7.

budieko
Sun Jan 04 18:07:55 CST 2004

just write SELECT * FROM CUSDTA INTO CURSOR CURDTA READWRITE


"Hidayat" <anonymous@discussions.microsoft.com> wrote in message
news:000801c3d339$ca5d61e0$a001280a@phx.gbl...
> Sorry Cindy I write uncomplete information, I use VFP7.
> Thank's
> Hidayat
>
>
> >-----Original Message-----
> >In news: 037201c3d32b$7eba7830$a101280a@phx.gbl,
> >Hidayat <anonymous@discussions.microsoft.com> wrote:
> >> Please advice how to delete/remove a record from the
> >> CURSOR that I get from the following code:
> >>
> >> SELECT *FROM CUSDTA INTO CURSOR CURDTA
> >>
> >> so, I want to delete record or some record in CURDTA
> >
> >Hi Hidayat,
> >
> >Which version of FoxPro are you using? In VFP8 use the
> READWRITE keyword to
> >make CurDta readwrite and then just use the DELETE
> command.
> >
> >--
> >Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
> >cindy.winegarden@mvps.org www.cindywinegarden.com
> >
> >
> >
> >.
> >

Hidayat
Sun Jan 04 22:32:38 CST 2004

Hi BudiEko,
I just checked what Cindy said for VFP8, Actually that
option also support VFP7 (as you said as well). Thank's
for all of your advices.
Regards
Hidayat
>-----Original Message-----
>just write SELECT * FROM CUSDTA INTO CURSOR CURDTA
READWRITE
>
>
>"Hidayat" <anonymous@discussions.microsoft.com> wrote in
message
>news:000801c3d339$ca5d61e0$a001280a@phx.gbl...
>> Sorry Cindy I write uncomplete information, I use VFP7.
>> Thank's
>> Hidayat
>>
>>
>> >-----Original Message-----
>> >In news: 037201c3d32b$7eba7830$a101280a@phx.gbl,
>> >Hidayat <anonymous@discussions.microsoft.com> wrote:
>> >> Please advice how to delete/remove a record from the
>> >> CURSOR that I get from the following code:
>> >>
>> >> SELECT *FROM CUSDTA INTO CURSOR CURDTA
>> >>
>> >> so, I want to delete record or some record in CURDTA
>> >
>> >Hi Hidayat,
>> >
>> >Which version of FoxPro are you using? In VFP8 use the
>> READWRITE keyword to
>> >make CurDta readwrite and then just use the DELETE
>> command.
>> >
>> >--
>> >Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
>> >cindy.winegarden@mvps.org www.cindywinegarden.com
>> >
>> >
>> >
>> >.
>> >
>
>
>.
>