Michael


>That's a good idea, thanks. I take it you are a golfer (Fore)

No. I enjoy walking our dogs but have no intention of abusing a small round ball!


>I'm only on day four here using EDB. I'll have to add "External
>Functions" to my reading list. Care to share a simple glimpse of what
>one of these "External Delphi Sql Functions" look like!

They come in two flavours - SQL& Delphi

Have a look in the extensions ng for some examples of Delphi ones - about the 6th post down under my name.

An SQL one

CREATE FUNCTION "RCF" (IN "In1" VARCHAR COLLATE ANSI, IN "In2" VARCHAR COLLATE ANSI, IN "Separator " VARCHAR COLLATE ANSI)
RETURNS VARCHAR COLLATE ANSI
BEGIN
DECLARE Output VARCHAR;
SET Output = COALESCE(In2,'');
IF (In1 IS NOT NULL) AND (In1 <> '') THEN
IF (In2 IS NOT NULL) AND (In2 <> '') THEN
 SET Output = Output + Separator + In1;
 ELSE SET Output = In1;
END IF;
END IF;
RETURN Output;
END
DESCRIPTION 'Reverse combine fields'
VERSION 1.00


>I have been doing this all from within EDB Manager. I figured if I can
>make it work inside EDB Manager then plugging into Delphi should be as
>simple as wiring up the TEDBStoredProc object.

Good idea and it will work for things SQL. However, remember, even with SQL/PSM its not a full programming language. You can achieve much but for some you need to jump through several hoops and it works best with a long legged female assistant to distract your mind

Roy Lambert [Team Elevate]

Roy,

<< Whatever you do do not use Outlook Express or MS Mail. >>

Ahem, I've always used OE and Live Mail, although primarily because I never
got around to using your news client.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


><< Whatever you do do not use Outlook Express or MS Mail. >>
>
>Ahem, I've always used OE and Live Mail, although primarily because I never
>got around to using your news client.
>

Out of interest how often have they corrupted? And how often messed up the threads because they use the title rather than the reference list?

Roy Lambert

Roy,

<< Out of interest how often have they corrupted? >>

I can't ever remember there being any corruption.

<< And how often messed up the threads because they use the title rather
than the reference list? >>

That happens a lot - I can lose threads completely because of that stupid
"feature".

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


><< Out of interest how often have they corrupted? >>
>
>I can't ever remember there being any corruption.

Interesting. The main reason I developed my own was I hold all the ElevateSoft newsgroup info and a fair wadge of the Borland/CodeGear stuff (c200k records now) and way back OE would corrupt and I'd have to download all again.

><< And how often messed up the threads because they use the title rather
>than the reference list? >>
>
>That happens a lot - I can lose threads completely because of that stupid
>"feature".

I'm beginning to think I may have to build it in for the CG ngs - someone edits a post and new reference ID trail.


Roy Lambert