Re: SQL Code that is submitted to server changes when run on different clients

"Dale" <DaleDeWitt@xxxxxxxxx> wrote:

> Yes, both clients are running the same MDAC version.... I dont see any
> broken references..... I am stumped. I have taken the same UDF and
> created a quick report, and It works on the other client. The only
> difference that I can see is that in the other reports, I use the
> "TRIM" command to get rid of spaces, when I concatenate address fields
> together, for formatting. Where does the "TRIM"Command reside ?? Is
> that in an external reference of some kind ??

The Trim-Function resides in the VBA-Library (VBE6.DLL). While
there may be problems with references and TRIM
(see http://www.mvps.org/access/bugs/bugs0001.htm) I don't think
that this is the reason for this problem.

Nevertheless you may as well remove the spaces in you UDF on the
server (use LTrim + RTrim there) and get rid of the client-side
TRIM.

What about my suggestion to use "SELECT * FROM dbo.yourUDF()"?

Cheers
Phil

--
Access FAQs: http://www.mvps.org/faq/mvp_faq_links.htm#Access
.

Relevant Pages

  • Re: Can MySQL start/fire an external process?
    ... you can mitigate most security concerns by writing your UDF in a "managed" language such as Java with the correct permissions set. ... I thought of another risk of using UDF's in triggers to notify clients: what if the event-raising UDF is invoked within a transaction? ...
    (comp.lang.java.databases)
  • Re: UDF tooltip
    ... some of my clients, and since there are greater than 5 ... >> Is there a way to add a tooltip to a UDF? ... I have a UDF ...
    (microsoft.public.excel.programming)
  • Re: how to trim the last 2 digits??
    ... Answered in .clients ... "ricky" wrote in message ... > i want to trim last 2 digit. ...
    (microsoft.public.sqlserver.mseq)