Èñïîëüçîâàíè â çàïðîñå ïîëüç. ôóíêöèé
|
|
×åòâåðã, 04 Äåêàáðÿ 2014 ã. 00:46
+ â öèòàòíèê
Äîáðîãî äíÿ ãîñïîäà !
Èìåþ áàçó C:\WORK\DB1.MDB â ìîäóëÿõ êîòîðîé, îïèñàíà ôóíêöèÿ ïîëüçîâàòåëÿ AA00
Function AA00() As Integer
AA00 = 100
End Function
Çàïðîñ â Access-å âûãëÿäèò òàê
SELECT t2.F1, t2.F2, AA00() AS F100
FROM t2;
Ìîæíî ëè ýòó ôóíêöèþ âûçâàòü èñïîëüçóÿ Microsoft jet (ADODB)
Ò.å.
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\WORK\db1.mdb;User Id=admin;Password=;
select t2.f1,t2.f2, aa00() as f100 from t2
Êàê èìåííî ?Âîïðîñ äâà
Ãäå íàéòè Microsoft.Jet.4.0 (èëè âûøå) SP8 äëÿ WIN7 (íåîáõîäèìà ôóíêöèÿ InStrRev)
Çàðàíåå áëàãîäàðåí !
http://www.sql.ru/forum/1130416/ispolzovani-v-zaprose-polz-funkciy
-
Çàïèñü ïîíðàâèëàñü
-
0
Ïðîöèòèðîâàëè
-
0
Ñîõðàíèëè
-