Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can function inside a DLL be used inside the SQL statement?

Status
Not open for further replies.

Kurtic20

Programmer
Jul 16, 2002
3
US
I'm trying to figure out if a user defined function inside a dll can be used within the Access SQL statement without creating a wrapper function in the module space. I know Access has it's VBA functions stored in a dll. These it is able to call without first creating a wrapper. Is it possible? please help!
Ex:
Access VBA function in dll
Select name, format("12/10/79", yy-mm-dd) from PERSON_TABLE;

User defined function in dll
Select name, to_date("12/10/79", yy-mm-dd) from PERSON_TABLE;
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top