Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Editable Cursors
Message
From
23/08/2001 05:39:17
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
22/08/2001 16:29:07
John Tomblin
Service Station Systems, Inc.
San Jose, California, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00547612
Message ID:
00547815
Views:
12
>If a cursor is created with Create Cursor, the resulting cursor is editable. However if the cursor is created with a SQL-Select, the resulting cursor is not editable. Is there a way to make the later editable?

John,
Yes you can do it with a little code up to VFP7. VFP7 has a new clause 'readwrite' to do it directly.
First be sure it's a true cursor :
-In fox2x either having a nonexistant field or an expression in where could force it to be. ie:

select * from myTable where .t. into cursor MyCursor

-In VFP there is 'nofilter' clause
select * from myTbale into cursor myCursor nofilter

Next use it again.
select * from myTable into cursor crsTemp nofilter
use dbf('crsTemp') in 0 again alias crsRW
use in 'crsTemp'
select crsRW
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
Reply
Map
View

Click here to load this message in the networking platform