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

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

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

 

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

 -Ñòàòèñòèêà

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


Ïîìîãèòå, ïðèìèòèâíûé ÇÀÏÐÎÑ ÌÅÆÄÓ ÄÀÒÀÌÈ òîðìîçèò áîëüøóþ ðàáîòó

×åòâåðã, 28 Ìàÿ 2015 ã. 07:02 + â öèòàòíèê
Áàíàëüíûé çàïðîñ íà ÿçûêå SQL íå ìîãó ñîòâîðèòü. ×òî òóò íå ïðàâèëüíî?

SELECT * FROM DB WHERE '" & data3 & "' <= Data AND Data <= '" & data4 & "'


çàïðîñ äåëàþ â VISUAL BASIC
Dim c As New OleDbCommand 'ïåðåìåííàÿ "ñ" áóäåò êîìàíäîé ê âûïîëíåíèþ
        c.Connection = conn
        c.CommandText = "SELECT * FROM DB WHERE '" & data3 & "' <= Data AND Data <= '" & data4 & "'" ' ORDER BY Data,Zveno,Pole,Diametr" 'âûáðàòü âñå ïîëÿ èç òàáëèöû DB âíåøíåé áàçû äàííûõ ñ âûáðàííîé äàòîé"
        Dim ds As New DataSet
        Dim da As New OleDbDataAdapter(c)
        da.Fill(ds, "DB")


è íà ïîñëåäíåé ñòðîêå ðóãàåòñÿ ìàøèíà òàê: "Data type mismatch in criteria expression."

http://www.sql.ru/forum/1158810/pomogite-primitivnyy-zapros-mezhdu-datami-tormozit-bolshuu-rabotu


 

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

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

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

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