Aug 12, 2003 #1 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
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
Aug 12, 2003 #2 BGrego Programmer Jul 1, 2003 37 US 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. Upvote 0 Downvote
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.
Aug 12, 2003 #3 BGrego Programmer Jul 1, 2003 37 US 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 Upvote 0 Downvote
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