Ïî íåïîíÿòíîé ïðè÷èíå- ïîñòîÿííî ìåíÿåòñÿ èñòî÷íèê ïîäñòàâëÿåìûõ ñòðîê
|
|
×åòâåðã, 02 Àïðåëÿ 2015 ã. 23:25
+ â öèòàòíèê
ïîäñêàæèòå :
èìååòñÿ 2 òàáëèöû :
1) èíôîðìàöèÿ î ÷èòàòåëå (Ôàìèëèÿ,Èìÿ,îò÷åñòâî, àäðåñ, òåëåôîí, áëîêèðîâêà(ëîãè÷åñêèé))
2) âûäà÷à êíèã (êîä âûäà÷è, êîä ÷èòàòåëÿ, êîä êíèãè, äàòà âûäà÷è, äàòà âîçâðàòà)
ïîëå êîä ÷èòàòåëÿ íàïîëíÿåòñÿ
èñòî÷íèê ñòðîê: SELECT [Èíôîðìàöèÿ î ÷èòàòåëå].[Êîä] FROM [Èíôîðìàöèÿ î ÷èòàòåëå];
à äîëæíî íàïîëíÿòüñÿ èç çàïðîñà
òåêñò çàïðîñà:
SELECT [Èíôîðìàöèÿ î ÷èòàòåëå].Êîä, [Èíôîðìàöèÿ î ÷èòàòåëå]![Ôàìèëèÿ]+" "+[Èíôîðìàöèÿ î ÷èòàòåëå]![Èìÿ]+" "+[Èíôîðìàöèÿ î ÷èòàòåëå]![Îò÷åñòâî] AS Âûðàæåíèå2
FROM [Èíôîðìàöèÿ î ÷èòàòåëå]
WHERE ((([Èíôîðìàöèÿ î ÷èòàòåëå].[Áëîêèðîâêà ïîëüçîâàòåëÿ])=False));
ïî êàêîé òî ïðè÷èíå - ñòàâëþ èñòî÷íèê ñòðîê- âûøå èçëîæåííûé çàïðîñ- ñîõðàíÿþ, îïÿòü îòêðûâàþ
èñòî÷íèê ñòðîê: SELECT [Èíôîðìàöèÿ î ÷èòàòåëå].[Êîä] FROM [Èíôîðìàöèÿ î ÷èòàòåëå];
ïðè÷åì ïîëå "êîä êíèãè" - íàïîëíÿåòñÿ àíàëîãè÷íî è âïîëíå ðàáîòàåò
÷òî ÿ äåëàþ íå òàê?
http://www.sql.ru/forum/1150292/po-neponyatnoy-prichine-postoyanno-menyaetsya-istochnik-podstavlyaemyh-strok
-
Çàïèñü ïîíðàâèëàñü
-
0
Ïðîöèòèðîâàëè
-
0
Ñîõðàíèëè
-