Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursors with strange behaviour
Message
From
02/10/2001 11:36:51
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
02/10/2001 11:25:08
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00563037
Message ID:
00563081
Views:
16
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform