Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select into cursor question??
Message
From
07/01/1999 21:15:53
 
 
To
07/01/1999 21:01:11
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00173861
Message ID:
00173896
Views:
34
>>>>I think someone ask this before , but once you get your cursor
>>>>after a " Select fields, into cursor Mycursorx', can I change
>>>>that cursor (Mycursor) structure somehow, or it is Read-Only
>>>>always...
>>>>
>>>>Mark Oliva
>>>
>>>Mark,
>>>
>>>Before you select into your cursor, create the cursor with CREATE CURSOR... The cursor will then be read/write. I have never tried modifying the structure of of cursor after it is created, but I see no reason you could not.
>>>
>>>regards,
>>
>>Any time you SELECT...INTO CURSOR, the resulting cursor is read-only, no matter what you do before hand. You can fake it out by USE DBF('thatcursor') ALIAS rwcursor into making a R/W cursor. Your SELECT statement must not be a "filtered-view" so use the NOFILTER clause in your SELECT.
>
>Fred,
>
>you're right. I was thinking of views. Oh well.
>
>regards,

Jim, no problem. At first I thought you had a neat trick to create a R/W SQL cursor. I'm always looking for new thingies to try, especially if they solve some sort of thorny problem!
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform