K
Kevin
I'm using Access as a database without a GUI. We are querying the data and
obtaining result sets from a Windows C# app. I've written some VB functions
in a code module and tried to use them in SQL stored procedures, viz
NSERT INTO <table>
SELECT <stuff>,
ParseMilePost(Milepost) AS Milepost,
<more stuff>
FROM <another table>
where ParseMilePost is my VB function. When this query runs I get
"Undefined function 'ParseMilePost' in expression".
The function is declared Public and lives in a code module in access. How do
I solve this problem? TIA,
Kevin
obtaining result sets from a Windows C# app. I've written some VB functions
in a code module and tried to use them in SQL stored procedures, viz
NSERT INTO <table>
SELECT <stuff>,
ParseMilePost(Milepost) AS Milepost,
<more stuff>
FROM <another table>
where ParseMilePost is my VB function. When this query runs I get
"Undefined function 'ParseMilePost' in expression".
The function is declared Public and lives in a code module in access. How do
I solve this problem? TIA,
Kevin