Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Same SQL results two different results
Message
De
04/08/2005 12:38:40
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Same SQL results two different results
Divers
Thread ID:
01038597
Message ID:
01038597
Vues:
66
This is weird. The following returns 10 records:
SELECT Thread.Title,Thread.AddDate,Member.Prenom,Member.Nom,Category.Anglais,Thread.Numero,Thread.NoThread;
 FROM Temp0000015806223254185171000;
 INNER JOIN Thread ON Temp0000015806223254185171000.Numero=Thread.Numero;
 INNER JOIN Member ON Thread.NoMember=Member.Numero;
 INNER JOIN Category ON Thread.NoCat=Category.Numero
but the following returns 13 records:
SQLEXEC(lnHandle,'SELECT Thread.Title,Thread.AddDate,Member.Prenom,Member.Nom,Category.Anglais,Thread.Numero,Thread.NoThread '+;
 'FROM \\SERVER5\D$\iis\universa\VisualFoxPro\Temp\Temp0000015806223254185171000 '+;
 'INNER JOIN Thread ON Temp0000015806223254185171000.Numero=Thread.Numero '+;
 'INNER JOIN Member ON Thread.NoMember=Member.Numero '+;
 'INNER JOIN Category ON Thread.NoCat=Category.Numero')
It is the same SQL. What am I missing?
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform