Can I call a Function that is within a module in vb6.0, from a SQL statement, and pass to the Function the arguments by way of the SQL statement??
I am using an Access 2000 database and evidently jet SQL will not allow a stored Function. Even if it did there is still no available CASE expression. It is the SELECT CASE statement that I want to use in the vb6.0 Function and call it from the SQL statement. Using ADO to process the SQL.
Another thought. Can I call a Function created in a module of VB6.0 from a database stored procedure??
TNN, Tom
TOM
I am using an Access 2000 database and evidently jet SQL will not allow a stored Function. Even if it did there is still no available CASE expression. It is the SELECT CASE statement that I want to use in the vb6.0 Function and call it from the SQL statement. Using ADO to process the SQL.
Another thought. Can I call a Function created in a module of VB6.0 from a database stored procedure??
TNN, Tom
TOM
