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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calling a Function from a query

Status
Not open for further replies.

Wiszh

Programmer
Aug 3, 2000
134
US
Is there any way to call a user defined (Module) function from a query?

How about from an external query, such as one called from an ASP or ColdFusion page?

Thanks in advance
 
To call a function from a query, just add the function name in the criteria box followed by parens

ex - function()

This will return the value of the function call back to the specific field you set the criteria for.

If the function returns a string, the query will return everything equal to the string for that field.
 
To call a function from a query, just add the function name in the criteria box followed by parens

ex - function()

This will return the value of the function call back to the specific field you set the criteria for.

If the function returns a string, the query will return everything equal to the string for that field.

I don't think its possibly to call an internal function from an external query, but don't quote me on this..

-BGrego
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top