Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Asynchronous Pass-Through Don't Work
Message
De
28/02/2005 15:54:46
 
 
À
28/02/2005 15:23:13
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Oracle
Divers
Thread ID:
00991315
Message ID:
00991355
Vues:
18
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
---------------------------------------------
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform