Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 9 of 9 total
Thread XML
Tue, Jun 10 2008 6:11 PMPermanent Link

"Jerry Hayes"
With v 2.0 have any XML capabalities?

If not, what would be the best path to add some custom functions?  Some
basic xpath queries and updates, don't mind assuming MS DOM availability.

Thanks all.

Tue, Jun 10 2008 9:59 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Jerry,

<< With v 2.0 have any XML capabalities? >>

Yes, but not initially.

<< If not, what would be the best path to add some custom functions?  Some
basic xpath queries and updates, don't mind assuming MS DOM availability. >>

Do you want to manipulate XML stored in the database tables, like in CLOB
columns ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Wed, Jun 11 2008 12:49 AMPermanent Link

"Jerry Hayes"
> Do you want to manipulate XML stored in the database tables, like in CLOB
> columns ?

Yes.  I'd like to create a few functions, (operating on the memo field), one
to return the value of an XPath and one to set a value.

Wed, Jun 11 2008 7:07 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Jerry,

<< Yes.  I'd like to create a few functions, (operating on the memo field),
one to return the value of an XPath and one to set a value.>>

Sure, you can do that in EDB.  You can either try to do it using straight
SQL/PSM (might be a bit dicey) or do it using native DLL in an external
module.  If you want to proceed with the native Delphi, just let me know and
I'll give you the steps on how to create one and install it.

--
Tim Young
Elevate Software
www.elevatesoft.com

Wed, Jun 11 2008 1:21 PMPermanent Link

"Jerry Hayes"
> << Yes.  I'd like to create a few functions, (operating on the memo
> field), one to return the value of an XPath and one to set a value.>>
>
> Sure, you can do that in EDB.  You can either try to do it using straight
> SQL/PSM (might be a bit dicey) or do it using native DLL in an external
> module.  If you want to proceed with the native Delphi, just let me know
> and I'll give you the steps on how to create one and install it.

Tim,

RE: Native Delphi...yes, I'd like some pointers here.  I know in DBISAM you
had the 'customfunction' event, I guess since EDB is more formal, that's no
longer hooked, right?  If it can be done by compiling a special server, that
would be fine, since I could put some other code in there too and it would
make deployment and licensing easier for me.

BTW, hello from beautiful Apopka Florida WinkDid you know that 'Post Lake'
apartments aren't called that anymore?  The lake looks good right now,
plenty of water.

Anyway, thanks for the whatever info; I do *not* mind pointers being
specific to 2.x.

Jerry

Wed, Jun 11 2008 4:20 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Jerry,

<< RE: Native Delphi...yes, I'd like some pointers here.  I know in DBISAM
you had the 'customfunction' event, I guess since EDB is more formal, that's
no longer hooked, right? >>

Correct.

<< If it can be done by compiling a special server, that would be fine,
since I could put some other code in there too and it would make deployment
and licensing easier for me. >>

No need - everything is done external to the server.

==================

You can define a stored procedure as external:

http://www.elevatesoft.com/scripts/manual.dll?action=mantopic&id=edb1sql&category=10&topic=162

The EXTERNAL NAME clause specifies that you want to use an external module
instead of an SQL/PSM body, and the name is the same as an existing external
module:

http://www.elevatesoft.com/scripts/manual.dll?action=mantopic&id=edb1sql&category=0&topic=13

You can create an external module very easily by doing the following in
Delphi 5-7 (2005+ is a little different because they moved the object
repository):

File/New
Select the ElevateDB tab
Double-click on the ElevateDB External Module icon

This will generate an empty template application for creating an external
module that can contain any number of external procedures.  And, this is all
native Delphi code instead of SQL/PSM, which is ideal for situations where
you need to interface with external hardware or libraries.

==================

<< BTW, hello from beautiful Apopka Florida WinkDid you know that 'Post Lake'
apartments aren't called that anymore?  The lake looks good right now,
plenty of water. >>

Wow, that lake was almost bone-dry when we left Orlando in 1998.  What are
the Post Lake apartments called now ?  We actually really like living there
way back when - they really ran the place very well and it was a great place
to live in the late 80's/early 90's.

--
Tim Young
Elevate Software
www.elevatesoft.com

Wed, Jun 11 2008 5:26 PMPermanent Link

"Jerry Hayes"
[snip]
> << If it can be done by compiling a special server, that would be fine,
> since I could put some other code in there too and it would make
> deployment and licensing easier for me. >>
>
> No need - everything is done external to the server.

Thanks for the references.

Just curious, *CAN* the code be added easily for a custom embedded server,
or must it be external?


[much snipping]
> Wow, that lake was almost bone-dry when we left Orlando in 1998.  What are
> the Post Lake apartments called now ?  We actually really like living
> there way back when - they really ran the place very well and it was a
> great place to live in the late 80's/early 90's.

http://zomrent.com/barringtonatmirrorlake/main-page.asp

Wed, Jun 11 2008 6:06 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Jerry,

<< Just curious, *CAN* the code be added easily for a custom embedded
server, or must it be external? >>

Not at this point, no.  However, Oliver Bock requested this, and it's still
on the list.

<< http://zomrent.com/barringtonatmirrorlake/main-page.asp >>

Wow, still looks pretty nice.  Did they change all of the Post* apartment
complexes to something else, or just Post Lake ?  Also, it's funny that the
address is still 700 Post Lake Place. Smiley

--
Tim Young
Elevate Software
www.elevatesoft.com

Wed, Jun 11 2008 6:17 PMPermanent Link

"Jerry Hayes"
> << Just curious, *CAN* the code be added easily for a custom embedded
> server, or must it be external? >>
>
> Not at this point, no.  However, Oliver Bock requested this, and it's
> still on the list.

Thanks, Tim.  Put me at +1 on this.

Image