Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updatable cursor
Message
 
 
To
03/01/2009 17:57:08
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01370856
Message ID:
01370857
Views:
10
Add READWRITE clause to make cursor updatable
SELECT T1.* from T1 order by T1.cCharField into cursor T2 READWRITE 
>I want to create a cursor, add a blank row, set an order, and have that row appear at the top.
>
>
select T1.* from T1 order by T1.cCharField into cursor T2 
>select T2
>append blank
>brow
>append blank generates "Cannot update the cursor T2 since it is read-only."
>
>It appears that I nead to create a NOT read-only cursor, but can't find the trick. Also, that blank line is added after the "order by" so I suspect that it would be at the bottom, even if I could add it. I could add the row to T1 first, but T1 is a read-only cursor too, that I also created with a select statement.
>
>Bob
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform