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

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

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

 

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

 -Ñòàòèñòèêà

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


Íå ïîéìó â ÷åì ïðîáëåìà

Âòîðíèê, 30 Àâãóñòà 2016 ã. 18:05 + â öèòàòíèê
Äîáðîãî âðåìåíè ñóòîê, ïîäñêàæèòå ïîæàëóéñòà â ÷åì ìîé êîñÿê....

Âîò ïðèìåð êîäà:
Set rst_1 = b.OpenRecordset("vibor_ip_kalkul")
kol_vo = rst_1.Fields.Count

While Not rst_1.EOF
znach = Trim(rst_1!Vibor)
MsgBox rst_1!Vibor
sqlstr = "select * from ÎÒÂÅÒÛ_ÈÏ where (ÎÒÂÅÒÛ_ÈÏ.ÍÎÌÅÐ_ÈÏ like '" & "* " & znach & " * ')" ' " '"

MsgBox sqlstr
Set rst = CurrentDb.OpenRecordset(sqlstr, dbOpenSnapshot)
'MsgBox sqlstr
ViewRecordset rst
kol_vo1 = rst.Fields.Count
'MsgBox rst1!ÍÎÌÅÐ_ÈÏ
    rst_1.MoveNext
    I = I + 1
Wend


Ñóòü ïðîáëåìû, â òîì, ÷òî Set rst = CurrentDb.OpenRecordset(sqlstr, dbOpenSnapshot) âîçâðàùàåò ïóñòîé ðåçóëüòàò, õîòÿ åñëè â àêñåñå "íà ïðÿìóþ" ñäåëàòü çàïðîñ èç sqlstr = "select * from ÎÒÂÅÒÛ_ÈÏ where (ÎÒÂÅÒÛ_ÈÏ.ÍÎÌÅÐ_ÈÏ like '" & "* " & znach & " * ')" ' " '" ãäå çàìåíèòü & znach & íà êîíêðåòíûå çíà÷åíèÿ êîòîðûå îòîáðàæàþòñÿ, òî çàïðîñ âûâîäèò êîððåêòíûé ðåçóëüòàò....

Òêíèòå ïîæàëóéñòà íîñîì â ìîþ áåçãðàìîòíîñòü â íàïèñàíèè çàïðîñîâ...

http://www.sql.ru/forum/1228825/ne-poymu-v-chem-problema


 

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

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

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

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