Ïî÷åìó ñáèâàåòñÿ ôèëüòð â çàïðîñå?
|
|
Ïÿòíèöà, 28 Íîÿáðÿ 2014 ã. 09:10
+ â öèòàòíèê
Ãîñïîäà, ó ìåíÿ ïî÷åìó-òî ïåðèîäè÷åñêè (íå çíàþ îò ÷åãî) ñáèâàåòñÿ çàïðîñ. ÒÅ åñòü äîñòàòî÷íî ïðîñòîé çàïðîñ, êîòîðûå îòîáðàæàåòñÿ â ïîä÷èíåííîé ôîðìå. Ñîðòèðîâêà èäåò ïî êîäó. ÍÎ îíà ïî÷åìó-òî ñòàðèííûì îáðàçîì ñáèâàåòñÿ è îòîáðàæàåò äàííûå ïðîèçâîëüíûì ïîðÿäêîì. Òîå íîðìàëüíî òàê: 1,2,3,4..., à îòîáðàæàåò ïî ôàêòó: 1,
3,2,4.
Xnj ìîæåò ñëóæèòü ïðè÷èíîé???
Âîò ñàì çàïðîñ:
SELECT Çàÿâêè.Êîä, Çàÿâêè.[ÔÈÎ Ñîòðóäíèêà]FROM Çàÿâêè
WHERE (((Çàÿâêè.Êîä)<>104 And (Çàÿâêè.Êîä)<>108 And (Çàÿâêè.Êîä)<>109))
ORDER BY Çàÿâêè.Êîä;
http://www.sql.ru/forum/1129331/pochemu-sbivaetsya-filtr-v-zaprose
-
Çàïèñü ïîíðàâèëàñü
-
0
Ïðîöèòèðîâàëè
-
0
Ñîõðàíèëè
-