Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 11 to 15 of 15 total |
Interesting Select Behavior Inside EDB Manager |
Mon, Sep 5 2011 11:34 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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] |
Tue, Sep 6 2011 1:35 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Wed, Sep 7 2011 3:11 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Wed, Sep 7 2011 2:08 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Thu, Sep 8 2011 3:57 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
« Previous Page | Page 2 of 2 | |
Jump to Page: 1 2 |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |