General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only