Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Extensions » View Thread |
Messages 1 to 10 of 13 total |
External Module Strange Behaviour |
Tue, Dec 15 2009 11:42 PM | Permanent Link |
Steve Forbes Team Elevate | 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 |
Wed, Dec 16 2009 12:03 AM | Permanent Link |
Steve Forbes Team Elevate | 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 > |
Wed, Dec 16 2009 11:50 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@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 |
Wed, Dec 16 2009 3:40 PM | Permanent Link |
Steve Forbes Team Elevate | 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 > |
Wed, Dec 16 2009 3:57 PM | Permanent Link |
Steve Forbes Team Elevate | 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 > |
Wed, Dec 16 2009 8:51 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@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 |
Thu, Dec 17 2009 12:32 AM | Permanent Link |
Steve Forbes Team Elevate | 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 > |
Thu, Dec 17 2009 1:20 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@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 |
Thu, Dec 17 2009 1:34 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Thu, Dec 17 2009 3:50 PM | Permanent Link |
Steve Forbes Team Elevate | 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 > |
Page 1 of 2 | Next Page » | |
Jump to Page: 1 2 |
This web page was last updated on Wednesday, June 12, 2024 at 01:54 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |