Home > Archive > FoxPro Help and Support > July 2005 > editing in cursor









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author editing in cursor

2005-07-19, 7:24 am

im fetching data too many tables

and result is storing in cursor
now i want to add somerecords in this cursor and also want to change some
data
is this possible. pls help
thanx


Jan Bucek

2005-07-19, 7:24 am

What ver. of VFP?

Capri napsal(a):
> im fetching data too many tables
>
> and result is storing in cursor
> now i want to add somerecords in this cursor and also want to change some
> data
> is this possible. pls help
> thanx
>
>

Olaf Doschke

2005-07-19, 7:24 am

since VFP7:
select ... into cursor mycursor readwrite

before VFP7:
select ... into cursor tempcursor nofilter
use dbf("tempcursor") in 0 again alias mycursor
use in select("tempcursor")
select mycursor

Now you may do:
append blank
replace
....whatever...

Bye, Olaf.


2005-07-19, 7:24 am

im using latest ver 9.0


"Jan Bucek" <bucek.jan@post.cz> wrote in message
news:Opuv1hEjFHA.3692@TK2MSFTNGP09.phx.gbl...[color=darkred]
> What ver. of VFP?
>
> Capri napsal(a):
some[color=darkred]


Dan Freeman

2005-07-19, 11:24 am

As Olaf says, you can use the READWRITE clause on SQL Select. But if you
want your changes reflected in the original data, take a look at views in
the help file.

Dan

Capri wrote:
> im fetching data too many tables
>
> and result is storing in cursor
> now i want to add somerecords in this cursor and also want to change
> some data
> is this possible. pls help
> thanx



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com