Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-30-2019, 06:54 AM   #16
plog
Banishment Pending
 
Join Date: May 2011
Posts: 9,389
Thanks: 11
Thanked 2,282 Times in 2,234 Posts
plog is a jewel in the rough plog is a jewel in the rough plog is a jewel in the rough
Re: Are UDFs in queries a bad idea?

I think you're propagating a spam post on another forum. Google the first words of the quoted posted ("111 Power Access Queries/SQL Examples"). The entire text is from a site selling the 111 queries for $40.

plog is offline   Reply With Quote
The Following User Says Thank You to plog For This Useful Post:
NauticalGent (08-30-2019)
Old 08-30-2019, 08:22 AM   #17
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 14,537
Thanks: 92
Thanked 1,678 Times in 1,558 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: Are UDFs in queries a bad idea?

A UDF is sometimes the fastest way to go for a mathematically oriented operation. It was a bizarre case, only happened once, but I had to compute some advanced statistical values for a Binomial Distribution and there wasn't one in any library I could find - so I had to roll my own as a UDF. Actually, despite the fact of it being interpreted rather than compiled, I was able to find "telescoped" functions that would help me speed up the computation.

I think that, like many other things we do, the ability to use a UDF should be a tool in the tool-kit, used when appropriate. We have to be mindful of the fact that if you only have hammers in your tool-kit, everything looks like nails.

__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How can fix it? any better idea please meenctg Forms 2 08-02-2014 03:30 PM
I have an idea but I have no idea where to start isapple General 7 06-26-2014 04:58 AM
No idea how to do this kamamakazii Queries 2 04-13-2008 01:00 PM
UDFs that accept arguments to process UPDATE/INSERT INTO SQL stmts? steve728 Queries 1 03-19-2006 05:08 PM
any one an idea Traden General 2 03-10-2003 02:38 AM




All times are GMT -8. The time now is 06:07 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World