Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cursors with strange behaviour
Message
De
02/10/2001 11:36:51
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
02/10/2001 11:25:08
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00563037
Message ID:
00563081
Vues:
17
>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
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform