Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Same SQL results two different results
Message
 
 
To
04/08/2005 12:38:40
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
01038597
Message ID:
01038603
Views:
23
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform