Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Read only cursor
Message
From
08/04/2002 07:41:34
 
 
To
08/04/2002 07:35:49
Joao Godinho
Fredesenvolv, Lda
Lisbon, Portugal
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00642103
Message ID:
00642106
Views:
18
>> select mycursor
>> append blank -> error cannot update cursor !!
>> What to do !! i need to insert a few rows

OK, so this is a good one! Foxpro created cursors as read only, so you need to open for read/write, you have to be carefull coz if you close it it gets deleted (thats the idea of cursors). Use the following


SELECT myCursor
lcDbfName=DBF()

SELECT 0
USE (lcDbfName) AGAIN ALIAS MyCopy
Append blank -> etc.....
USE

SELECT myCursor

Hope this helps


Gary
Previous
Reply
Map
View

Click here to load this message in the networking platform