-Ïîèñê ïî äíåâíèêó

Ïîèñê ñîîáùåíèé â rss_sql_ru_access_programming

 -Ïîäïèñêà ïî e-mail

 

 -Ïîñòîÿííûå ÷èòàòåëè

 -Ñòàòèñòèêà

Ñòàòèñòèêà LiveInternet.ru: ïîêàçàíî êîëè÷åñòâî õèòîâ è ïîñåòèòåëåé
Ñîçäàí: 16.03.2006
Çàïèñåé:
Êîììåíòàðèåâ:
Íàïèñàíî: 4


×åðåç ðàç îòðàáàòûâàåò INSERT INTO. Builder 6 íà mdb ôàéëå.

Ïîíåäåëüíèê, 18 Àâãóñòà 2014 ã. 14:47 + â öèòàòíèê
×åðåç ðàç îòðàáàòûâàåò INSERT INTO

Èìåþ òàêóþ õðàíèìêó, êîòîðàÿ äîëæíà ïèñàòü â òàáëèöó TempNPP íàáîð äàííûõ. Íî ðàáîòàåò ÷åðåç ðàç. Òàê ïîíèìàþ mdb áëîêèðóåò.


CREATE PROCEDURE procTempNPP
 AS 
INSERT INTO TempNPP (NomZ_v, NomZ_i, NomZ_p, NPP)
SELECT i.NomSoed, i.NomZ, p.NomZ, i.IarusNom*100+p.PorodaNom
FROM TblVydIarus AS i
	INNER JOIN TblVydPoroda AS p ON i.NomZ=p.NomSoed
WHERE i.Iarus NOT IN(17, 19)


Òàêèì îáðàçîì âûçûâàþ õðàíèìêó. Âûçîâ ïðîèçâîæó èç êîìïîíåíòà TADOCommand.
EXECUTE procTempNPP

Îøèáêè íèêàêîé íå âûñêàêèâàåò.

http://www.sql.ru/forum/1111247/cherez-raz-otrabatyvaet-insert-into-builder-6-na-mdb-fayle


 

Äîáàâèòü êîììåíòàðèé:
Òåêñò êîììåíòàðèÿ: ñìàéëèêè

Ïðîâåðêà îðôîãðàôèè: (íàéòè îøèáêè)

Ïðèêðåïèòü êàðòèíêó:

 Ïåðåâîäèòü URL â ññûëêó
 Ïîäïèñàòüñÿ íà êîììåíòàðèè
 Ïîäïèñàòü êàðòèíêó