Hello ALL,

I'm use Pass-Through in VFP 8 and Oracle 8.0.5 / 8.1.6 and I try to set a Asynchronous query with SQLSETPROP, I'm the code Below:

USE \\s5700as05\c$\Inetpub\wwwroot\swapp\dados\projetos.DBF
*
lnconex = SQLSTRINGCONNECT("DRIVER={Oracle ODBC Driver}; DBQ=" + ALLTRIM(Projetos.Oracon) + "; UID=direcdb; PWD=oracle")
SQLSETPROP(lnconex, 'Asynchronous', .F.)
SQLSETPROP(lnconex, "QueryTimeOut", 300)
SQLPREPARE(lnconex,lcQueryString,"TQUERY")
*
lcQueryString = [Select DISTINCT " + ;
[LTRIM(RTRIM(a.documentname)) as Documento, b.Revisao] + ;
[, LTRIM(RTRIM(a.documenttitle)) as Titulo from brteceng a] + ;
[, (select c.documentname, max(c.i2revision) as revisao from brteceng c where c.projectname = 'P50' group by documentname) ] + ;
[b where a.documentname = b.documentname and a.i2revision = b.revisao and ] + ;
[ a.projectname = 'P50'] + ;
[ and ISNULO(a.documentauthor) like '%PPC%' ] + ;
[ order by documento, revisao]
*
SQLPREPARE(lnconex,lcQueryString,"TQUERY")
CURSORSETPROP("FetchSize", 100, 0)
SQLSETPROP(lnconex, 'Asynchronous', .T.)
SQLEXEC(lnconex)

I'm doing something wrong???

Regards,