Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Convert a cursor from temporary to permanent
Message
From
15/02/2002 02:25:53
 
 
To
14/02/2002 13:18:05
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00619899
Message ID:
00620520
Views:
30
Sorry for getting into,
but what about when you get a query result from a remote query via sqlexec. Is there a way to make the relulted cursor permanent with out using any of the copy to e.t.c. commands ???

Thank You
Dimitris

>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform