Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Convert a cursor from temporary to permanent
Message
De
15/02/2002 02:25:53
 
 
À
14/02/2002 13:18:05
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00619899
Message ID:
00620520
Vues:
31
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform