Re: external sql functions accessable from msaccess

["tim.dclinc@xxxxxxxxx" <tim.dclinc@xxxxxxxxx>]

i was able to get it to work using a "pass-through" query...
only problem im having is it prompts me for odbc connection every time. 
There is a place to put in an ODBC connection string, but im not sure 
the syntax...Any ideas?


On 10/15/2012 07:05 PM, Alan Campin wrote:
> You have to give it the library you registered it to. On my iDate, if
> called from a PC I have to do
>
> Select il.iDate(20121014) from system.sysdummy
>
> On lthe AS/400, I can just do Select iDate(20121014) from system.sysdummy
>
> In other words, you to qualify it to tell the AS/400 where the function is.
>
> On Mon, Oct 15, 2012 at 4:47 PM, tim.dclinc@xxxxxxxxx
> <tim.dclinc@xxxxxxxxx> wrote:
> > No sure what forum to post this to but...
> >
> > I created an sql function (isprime) that i use in my sql. Its works
> > great on the iseries.
> >
> > "SELECT CLMNO,ISPRIME(CLMNO) FROM CLAIMS WHERE CLMNO BETWEEN 199950 AND
> > 200050"
> >
> > I would like to give a power user the ability to use it also. He does
> > his work using MS Access. When he tried the previous SQL, he gets an
> > "Undefined function 'isprime' in expression".
> >
> > Is there a way to make iseries functions available to msaccess users?
> >
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.