Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Convert a cursor from temporary to permanent
Message
From
14/02/2002 13:18:05
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
14/02/2002 13:10:07
Lutz Scheffler (Online)
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00619899
Message ID:
00620189
Views:
29
>Hallo Hilmar,
>
>thats what I do 'til now.
>We started this tread to avoid using a table ... ::)
>
>Agnes

And what is the problem with a table?

There isn't much difference between a cursor and a table, except for the following: A cursor is deleted automatically when you close it. A table is not - if you don't want it any more, you have to delete it manually. You want the latter!

Of course, there is another important difference. With a cursor, VFP creates a temp table name, and assigns the alias you specify. But this, too, you can control yourself. Just use sys(2015) to create the table name.

Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform