Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Convert a cursor from temporary to permanent
Message
From
15/02/2002 07:35:13
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
 
To
15/02/2002 02:25:53
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00619899
Message ID:
00620584
Views:
30
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]
Previous
Reply
Map
View

Click here to load this message in the networking platform