Are you getting any errors? What does SQLEXEC() return?


>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,