Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Same SQL results two different results
Message
 
 
À
04/08/2005 12:38:40
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
01038597
Message ID:
01038603
Vues:
22
Different SET DELETE setting?

>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?
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform