且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何从SQL查询内部调用VBA函数?

更新时间:2023-01-19 16:54:36

是的,这是可能的。
但是,我不认为这是可能的凡(...)

Yes, it is possible.
However, I don't think it's possible with WHERE IN (...).

下面是一个正常的,其中查询一个例子:

Here is an example for a normal WHERE query:

Public Function Test() As String
    Test = "Smith"
End Function

...然后:

...and then:

SELECT * FROM Users WHERE Name = Test();

它的工作原理,只要把函数只返回一个值。
但我认为它的不可以可以让你的函数返回类似史密斯,米勒并使用,如:

It works, as long as the function only returns one value.
But I think it's not possible to let your function return something like "Smith, Miller" and use that like:

SELECT * FROM Users WHERE Name In (Test());

(至少我不知道如何做到这一点)

(at least I don't know how to do it)