Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement