Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Writeable Cursors?
Message
From
16/12/1997 14:47:51
 
 
To
16/12/1997 07:45:25
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00066144
Message ID:
00066336
Views:
32
>sele my_cursor
>use(dbf([my_cursor]) in 0 again alias RWmy_cursor
>
>Probably, updatable view more than reliable way to do what you want.
>
>>How do you make a SQL Cursor writeable ?
>>Select * from my_file into cursor my_cursor

Hi Vladimir,
This probably belongs in another thread, but a cursor created via SQL SELECT would seem to have several advantages over a view:
1.) It does not have to be stored in a DBC
2.) It is dynamic, changing the select statement changes the generated cursor. More flexible than updatable view
The cursor created via use again is bufferable, so the only issue appears to be updating a target table(s).

What's your take on this?

Ned
Ned

Reality is.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform