Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Convert a cursor from temporary to permanent
Message
De
15/02/2002 07:35:13
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Allemagne
 
 
À
15/02/2002 02:25:53
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:
00620584
Vues:
28
Dimitris,
Maybe I'm completely wrong. I have no experience with sqlexec.
If I see it right Syntax is

SQLEXEC(nConnectionHandle, [cSQLCommand, [cCursorName]])

for "cCursorName" they wrote 'name of foxpro cursor to send data'

As I understand foxpro, a table is a special kind of cursor.
It is not mentioned if the cursor will be created or the way an existing cursor will be handled.

Have you tried the following?
CREATE TABLE curResult FREE ( ...
SQLEXEC(nConnectionHandle, cSQLCommand, 'curResult')
Agnes

>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
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform