Hi Tim,

I had one external module already registered and working, when I added
another and registered the functions they also appeared in the EDB Manager
function list, however, I was unable to get any of the new functions to
work. They could be used in SQL statements, but always returned NULL. I
placed ShowMessages, Codesite messages, and then tried to remotely debug the
external module .. no part of the code was ever reached! Is it possible to
register more than one external module (it appears so coz the functions
appear in the list), or have I stumbled across an issue?

Best regards

Steve

Forgot to add, .. when I combined the 2 external modules into one, the new
functions started to work correctly.

"Steve Forbes" <ozmosysspamfree@optusnet.com.au> wrote in message
news:83317482-7F86-4E1F-8391-45CEC98F0FDC@news.elevatesoft.com...
> Hi Tim,
>
> I had one external module already registered and working, when I added
> another and registered the functions they also appeared in the EDB Manager
> function list, however, I was unable to get any of the new functions to
> work. They could be used in SQL statements, but always returned NULL. I
> placed ShowMessages, Codesite messages, and then tried to remotely debug
> the external module .. no part of the code was ever reached! Is it
> possible to register more than one external module (it appears so coz the
> functions appear in the list), or have I stumbled across an issue?
>
> Best regards
>
> Steve
>

Steve,

<< I had one external module already registered and working, when I added
another and registered the functions they also appeared in the EDB Manager
function list, however, I was unable to get any of the new functions to
work. They could be used in SQL statements, but always returned NULL. I
placed ShowMessages, Codesite messages, and then tried to remotely debug the
external module .. no part of the code was ever reached! Is it possible to
register more than one external module (it appears so coz the functions
appear in the list), or have I stumbled across an issue? >>

Did you make sure to specify the correct external module in the CREATE
FUNCTION statement that you used to create the function ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Hi Tim,

I am sure I did, but I will try again to make sure and let you know.

Best regards

Steve

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:A17B7784-F0D3-435A-8611-C213AC3B0EF7@news.elevatesoft.com...
> Steve,
>
> << I had one external module already registered and working, when I added
> another and registered the functions they also appeared in the EDB Manager
> function list, however, I was unable to get any of the new functions to
> work. They could be used in SQL statements, but always returned NULL. I
> placed ShowMessages, Codesite messages, and then tried to remotely debug
> the external module .. no part of the code was ever reached! Is it
> possible to register more than one external module (it appears so coz the
> functions appear in the list), or have I stumbled across an issue? >>
>
> Did you make sure to specify the correct external module in the CREATE
> FUNCTION statement that you used to create the function ?
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>

Hi Tim,

Just retested with a cut-down external module, .. definitely used the
correct external module in the CREATE FUNCTION statement, and the same thing
happened.

One final piece of information, I named the external module DLL
EDBExternals.dll .. before doing so I did a search to ensure this was not
already being used (which it is not), but is the name possibly the cause?

Best regards

Steve

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:A17B7784-F0D3-435A-8611-C213AC3B0EF7@news.elevatesoft.com...
> Steve,
>
> << I had one external module already registered and working, when I added
> another and registered the functions they also appeared in the EDB Manager
> function list, however, I was unable to get any of the new functions to
> work. They could be used in SQL statements, but always returned NULL. I
> placed ShowMessages, Codesite messages, and then tried to remotely debug
> the external module .. no part of the code was ever reached! Is it
> possible to register more than one external module (it appears so coz the
> functions appear in the list), or have I stumbled across an issue? >>
>
> Did you make sure to specify the correct external module in the CREATE
> FUNCTION statement that you used to create the function ?
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>

Steve,

<< Just retested with a cut-down external module, .. definitely used the
correct external module in the CREATE FUNCTION statement, and the same thing
happened. >>

Could you send me what you've got so far ?  It will save me some time, and I
can have an answer for you quicker.

<< One final piece of information, I named the external module DLL
EDBExternals.dll .. before doing so I did a search to ensure this was not
already being used (which it is not), but is the name possibly the cause? >>

Nah, that should be fine.

Thanks,

--
Tim Young
Elevate Software
www.elevatesoft.com

Hi Tim,

I will bundle it up and send to you tomorrow.

This is not a high priority so don't worry about a quick answer. I am adding
the functions to the first module for the time being, however, it makes
sense to me to be able to modularise the functions based on category down
the track.

For example I have added the following functions today

BitAnd
BitNot
BitOr
BitShl
BitShr
BitXor
GetBit,
IsBit, and
SetBit

These would ideally be contained in a separate DLL called EDBExtBit.dll (or
some such)

Best regards

Steve

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:B32D9B4B-23D6-452F-99F1-75228CBFBC62@news.elevatesoft.com...
> Steve,
>
> << Just retested with a cut-down external module, .. definitely used the
> correct external module in the CREATE FUNCTION statement, and the same
> thing happened. >>
>
> Could you send me what you've got so far ?  It will save me some time, and
> I can have an answer for you quicker.
>
> << One final piece of information, I named the external module DLL
> EDBExternals.dll .. before doing so I did a search to ensure this was not
> already being used (which it is not), but is the name possibly the cause?
>  >>
>
> Nah, that should be fine.
>
> Thanks,
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>

Steve,

<< I will bundle it up and send to you tomorrow. >>

Thanks.

<< This is not a high priority so don't worry about a quick answer. >>

No problem.  I'm getting a new build ready by next week, so I can squeeze it
in there.  I'm sure the fix is simple.

<< For example I have added the following functions today >>

Cool.

--
Tim Young
Elevate Software
www.elevatesoft.com

Steve


Since you're posting in the extensions ng I presume you ARE going to share these general purpose extensions aren't you?

Roy Lambert

Hi Roy,

Of course .. sometime next week I'll upload the package complete with
DUnit tests as a Christmas present

Best regards

Steve

"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:F51391C9-97F1-4E40-BB59-9291CAFB31FC@news.elevatesoft.com...
> Steve
>
>
> Since you're posting in the extensions ng I presume you ARE going to share
> these general purpose extensions aren't you?
>
> Roy Lambert
>