Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 6 of 6 total
Thread SQL/PSM
Fri, Oct 2 2009 6:03 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Tim

Any chance of a command to execute a Windows (or I suppose Linux) command? Reason for the request is that I hold file links with companies and contacts and if they're zapped I want to delete the file as well. I've come up with a rather nifty solution which does have a loophole and it would be nicer to do the whole job in a script.

Roy Lambert
Fri, Oct 2 2009 11:53 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< Any chance of a command to execute a Windows (or I suppose Linux)
command? Reason for the request is that I hold file links with companies and
contacts and if they're zapped I want to delete the file as well. I've come
up with a rather nifty solution which does have a loophole and it would be
nicer to do the whole job in a script. >>

You could easily do something like this with an external module, and it
would be callable from any script.

--
Tim Young
Elevate Software
www.elevatesoft.com

Sat, Oct 3 2009 6:21 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Tim


>You could easily do something like this with an external module,

With all the additional overheads.

>and it
>would be callable from any script.

Wouldn't a built in version?

Roy Lambert
Sat, Oct 3 2009 11:24 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< With all the additional overheads. >>

What overhead ?  You can put all of the functions in one external module.

<< Wouldn't a built in version? >>

Yes, but as you know, there's a limit to how much "built-in" functionality
there can be.  There is a reason why the external module functionality is
there, and this is the exact purpose of it - calling native Win32
functionality that isn't present in SQL or part of the purpose of SQL.  File
I/O is not a function of SQL, apart from what we've already surfaced for the
stores functionality, which is necessary for replication from scripts, etc.

--
Tim Young
Elevate Software
www.elevatesoft.com

Sat, Oct 3 2009 12:00 PMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Tim

>What overhead ? You can put all of the functions in one external module.

There's an overhead to calling an external function.

><< Wouldn't a built in version? >>
>
>Yes, but as you know, there's a limit to how much "built-in" functionality
>there can be.

Fully agree, but "there's no harm in asking"

>File
>I/O is not a function of SQL,

Being picky doesn't database access count as file I/O Smiley

Roy Lambert
Mon, Oct 5 2009 1:51 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< There's an overhead to calling an external function. >>

Yes, but not much more than calling an SQL function.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image