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.
OffThere is no place like [::1]