>Cetin,
>>SQL cannot access records in buffer.
>>browse, locate, seek, scan..endscan etc can work with buffered.
>>Cetin
>
>Thanks, didn't know even after 2 years of VFP :-(
>
>You don't know of any workaround by any chance (without committing the buffer of course) ?
>
>
>Pascal.
I don't know what you want to do. Possibly I'd do like this:
use myView
afields(aStruc)
create cursor myParallel from array aStruc
append from myView
and duplicate inserts :
insert into myView ..
insert into myParallel ..
Or better :
lcTemp=sys(2015)+'.dbf'
Copy to (lcTemp)
*Do whatever
erase (lcTemp)
Or if applicable (size wise):
use myView
afields(aStruc)
create cursor myParallel from array aStruc
appen from myView
*insertions
copy to array myArray for recno() < 0
insert into myParallel from array myArray
Cetin