Fernando,
first, thank you! i'm using VFP8 SP1, but it's don't work. Any more idea? The test code that im using??
lnconex = SQLSTRINGCONNECT("DRIVER={Oracle ODBC Driver}; DBQ=" + ALLTRIM(Projetos.Oracon) + "; UID=direcdb; PWD=oracle")
lcQueryString = [Select 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")
? SQLSETPROP(lnconex, 'Asynchronous', .T.)
? SQLEXEC(lnconex)
Regards,
---------------------------------------------
Mauro Ricardo Chaves de Oliveira
Petrobras/RJ
Technical Documents Manager
---------------------------------------------