How to determine if application fetches the result set?

Hi
I have a FoxPro application here to deal with. How do I determine whether
the application fetches the result set to completion or not?
Do I have to look for SQLCloseCursor in ODBC trace? What are the signs to
look for?
Many thanks,
Oskar
Hi
You should get SQL_SUCCESS returned from your SQLExecute/SQLFetch statement
if it has completed or SQL_STILL_EXECUTING if it hasn't.
John
"Oskar" wrote:

> Hi
> I have a FoxPro application here to deal with. How do I determine whether
> the application fetches the result set to completion or not?
> Do I have to look for SQLCloseCursor in ODBC trace? What are the signs to
> look for?
> --
> Many thanks,
> Oskar
>
sql

How to determine if application fetches the result set?

Hi
I have a FoxPro application here to deal with. How do I determine whether
the application fetches the result set to completion or not?
Do I have to look for SQLCloseCursor in ODBC trace? What are the signs to
look for?
Many thanks,
OskarHi
You should get SQL_SUCCESS returned from your SQLExecute/SQLFetch statement
if it has completed or SQL_STILL_EXECUTING if it hasn't.
John
"Oskar" wrote:

> Hi
> I have a FoxPro application here to deal with. How do I determine whether
> the application fetches the result set to completion or not?
> Do I have to look for SQLCloseCursor in ODBC trace? What are the signs to
> look for?
> --
> Many thanks,
> Oskar
>