Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 11 to 20 of 20 total |
Execute Script from a string/varchar |
Thu, Sep 26 2019 10:57 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Yusuf
>understood? Getting there. What are the 20 lines of script? Roy |
Thu, Sep 26 2019 11:07 AM | Permanent Link |
Yusuf Zorlu MicrotronX - Speditionssoftware vom Profi | Roy Lambert wrote:
> Getting there. What are the 20 lines of script? Can be anything, i.e. calculating a m3 from length/width/height or something total different. This is based on customers need. Anything. I think we can't do this with actual Edb-Server. We need something like "ExecScript" from tedbquery component, ie. EXECUTE SCRIPT IMMEDIATE to make it work. It is not important right now, but would be a good new function for Tim -- -- Yusuf Zorlu | MicrotronX |
Thu, Sep 26 2019 12:37 PM | Permanent Link |
Raul Team Elevate | On 9/26/2019 11:07 AM, Yusuf Zorlu wrote:
> Can be anything, i.e. calculating a m3 from length/width/height or > something total different. This is based on customers need. Anything. > I think we can't do this with actual Edb-Server. We need something like > "ExecScript" from tedbquery component, ie. EXECUTE SCRIPT IMMEDIATE to > make it work. > > It is not important right now, but would be a good new function for Tim External function (in external module) should work for this Raul |
Fri, Sep 27 2019 2:53 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Yusuf
My problem is you've given a couple of simplistic examples and seem to be wanting to throw any old requirement and expect it to work. Tim may know a way of doing this I certainly don't. Raul has a valid approach but only if you write specific code for each requirement and given that you don't want to write procedures I can't see that helping much. What is required may be to build your own interpreter. Something I did to implement mail & news rule processing. Roy Lambert |
Fri, Sep 27 2019 9:49 AM | Permanent Link |
Raul Team Elevate | On 9/27/2019 2:53 AM, Roy Lambert wrote:
> Raul has a valid approach but only if you write specific code for each requirement and given that you don't want to write procedures I can't see that helping much. Roy, I think you can write a generic external module that is basically tedbquery and simply executes script to send in - i'm not proposing to write multiple external functions but just one generic "runscript" one. Raul |
Sat, Sep 28 2019 1:09 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Raul
Ah, you're proposing he writes his own EXECUTE IMMEDIATE, interesting, but unless I'm missing something he'd also need to build a script parser into the external function. Roy Lambert |
Sat, Sep 28 2019 11:42 AM | Permanent Link |
Fernando Dias Team Elevate | Yusuf,
You could have the SQL code of the custom tasks in CLOBs and add a functionality to your application to automatically generate a stored procedure for each task when appropriate. Then, an existing JOB would read the list of stored procedures to execute, that could be in a table too. Easy and clean. There is no need reinvent the wheel. -- Fernando Dias [Team Elevate] |
Sun, Sep 29 2019 7:50 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Fernando
Or even less wheel inventing - just write the procedures <VBG> Roy Lambert |
Sun, Sep 29 2019 9:40 AM | Permanent Link |
Fernando Dias Team Elevate | Roy,
Right -- Fernando Dias [Team Elevate] |
Mon, Sep 30 2019 1:53 AM | Permanent Link |
Yusuf Zorlu MicrotronX - Speditionssoftware vom Profi | Thanks guys, we'll write the procedures when needed and delete them
when there is no need for them. -- -- Yusuf Zorlu | MicrotronX |
« Previous Page | Page 2 of 2 | |
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 |