Âòîðíèê, 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
-
Çàïèñü ïîíðàâèëàñü
-
0
Ïðîöèòèðîâàëè
-
0
Ñîõðàíèëè
-