Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Asynchronous Pass-Through Don't Work
Message
From
28/02/2005 15:54:46
 
 
To
28/02/2005 15:23:13
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Oracle
Miscellaneous
Thread ID:
00991315
Message ID:
00991355
Views:
16
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
---------------------------------------------
Previous
Reply
Map
View

Click here to load this message in the networking platform