select MyFuction(id) as Mydata from datatable ^^^^^^^^^ 其中MyFuction是一个自定义函数,放在access的模块里 fuction MyFuction(ss as string) as string select case ss case = "case1" ...... MyFuction=.... case = "case2" ...... MyFuction=.... case = "case2" .... MyFuction=.... end select end function如果在vb中用 select MyFuction(id) as Mydata from datatable则不行,我不知道应该如何定义MyFuction?
直接发sql或用存储过程都可以
^^^^^^^^^
其中MyFuction是一个自定义函数,放在access的模块里
fuction MyFuction(ss as string) as string
select case ss
case = "case1"
......
MyFuction=.... case = "case2"
......
MyFuction=.... case = "case2"
....
MyFuction=....
end select
end function如果在vb中用
select MyFuction(id) as Mydata from datatable则不行,我不知道应该如何定义MyFuction?
自定义函数查询方式要慎用!
可以换换其他方法
在Recordset的Open里select MyFuction(id) as Mydata from datatable
不行吗?
所以我只好绕了一个弯路,在vb中引用access对象,使用docmd来完成access中的自定义函数查询。