Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
UDF's second rate citizen in Rushmore ?
Message
From
07/09/2006 10:48:23
 
 
To
07/09/2006 10:13:55
Mike Yearwood
Toronto, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01151219
Message ID:
01151820
Views:
47
>The UDF has to return fixed length values. If a programmer does not know that, the results will be strange and they will blame vfp.
>
>VFP can at least try to compute length based on known functions, but how to guess what comes from UDF?

Even if I wrap my UDF in calls to PADR(MyUDF(), 20) or Cast(MyUDF() as C(20)) ?
Such an index is MUCH safer than the possible inclusion of a private memvar IMHO,
and vfp merrily uses those in optimizing queries.

Especially any CAST()-wrapped UDF should be considered "safe enough".

regards

thomas
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform