Êàê îáðàòèòüñÿ ïî èìåíè ê çàïðîñó ñ ïàðàìåòðàìè â áàçå Access c ïîìîùüþ ADO
|
|
Ïîíåäåëüíèê, 23 ßíâàðÿ 2017 ã. 01:31
+ â öèòàòíèê
Çäðàâñòâóéòå. Îïðåäåëèòå, ïîæàëóéñòà, â ÷åì îøèáêà.
Åñòü áàçà äàííûõ accdb, â íåé åñòü çàïðîñ íà âûáîðêó ñ ïàðàìåòðàìè. Õî÷ó îòêðûòü ýòîò çàïðîñ ñ ïîìîùüþ ADO. Îáðàùàþñü ê çàïðîñó ïî åãî èìåíè.
Dim q = New ADODB.Command
q.ActiveConnection = cnn
q.CommandText = "Èìÿ Çàïðîñà"
q.CommandType = ADODB.CommandTypeEnum.adCmdStoredProc
q.Parameters.Append(q.CreateParameter("Èìÿ ïàðàìåòðà", adVarChar, adParamInput))
 ïîñëåäíåé ñòðîêå âîçíèêàåò îøèáêà: "Íåïðàâèëüíî îïðåäåëåí îáúåêò Parameter. Ïðåäîñòàâëåíû íåñîãëàñîâàííûå èëè íåïîëíûå ñâåäåíèÿ". Ïàðàìåòð çàïðîñà òåêñòîâûé.
http://www.sql.ru/forum/1246966/kak-obratitsya-po-imeni-k-zaprosu-s-parametrami-v-baze-access-c-pomoshhu-ado
-
Çàïèñü ïîíðàâèëàñü
-
0
Ïðîöèòèðîâàëè
-
0
Ñîõðàíèëè
-