Ïðèëîæåíèþ Microsoft Access íå óäàåòñÿ äîáàâèòü âñå çàïèñè â çàïðîñå íà äîáàâëåíèå
|
|
Âîñêðåñåíüå, 01 Íîÿáðÿ 2015 ã. 18:06
+ â öèòàòíèê
Äîáðûé âå÷åð, ïîìîãèòå, ïîæàëóéñòà, èñïðàâèòü îøèáêó.
Èçíà÷àëüíûé sql êîä
INSERT INTO Äîñòàâêà
SELECT Äîñòàâêà.ÊîäÄîñòàâêè, Äîñòàâêà.ÊîäÍàçâàíèå, Äîñòàâêà.Òåëåôîí
FROM Äîñòàâêà
WHERE (((Äîñòàâêà.ÊîäÄîñòàâêè)>10000) AND ((Äîñòàâêà.ÊîäÄîñòàâêè) Is Not Null));
Ïîñëå ìîèõ íåáîëüøèõ èçìåíåíèé ñòàëî âûãëÿäåòü ýòî òàê
INSERT INTO Äîñòàâêà ( ÊîäÄîñòàâêè, Íàçâàíèå, Òåëåôîí )
SELECT Äîñòàâêà.ÊîäÄîñòàâêè AS ÊîäÄîñòàâêè, Äîñòàâêà.Íàçâàíèå AS Íàçâàíèå, Äîñòàâêà.Òåëåôîí AS Òåëåôîí
FROM Äîñòàâêà
WHERE (((Äîñòàâêà.ÊîäÄîñòàâêè)>1 And (Äîñòàâêà.ÊîäÄîñòàâêè) Is Not Null));
Ìíå Access ñòàë âûäàâàòü îøèáêó(ôîòî íèæå)
Ñîáñòâåííî ÷òî ýòî çà îøèáêà òàêàÿ è ñ ÷åì å¸ åäÿò?
http://www.sql.ru/forum/1182800/prilozheniu-microsoft-access-ne-udaetsya-dobavit-vse-zapisi-v-zaprose-na-dobavlenie
-
Çàïèñü ïîíðàâèëàñü
-
0
Ïðîöèòèðîâàëè
-
0
Ñîõðàíèëè
-